Help

PDF to ODS: Turn PDF Text into an OpenDocument Spreadsheet

Convert PDF to ODS online: the selectable text of each page lands in the rows and columns of a spreadsheet that opens in LibreOffice Calc. Simple tables and lists convert best. Complex layouts need cleanup, and scans need OCR first.

4.1 / 5 (724)

// how it works

Convert PDF to ODS in 4 Easy Steps

  1. 01Pick one PDF with real text, or drag it into the upload area.
  2. 02Check it's the right PDF and click Convert to ODS.
  3. 03Wait while the selectable text gets sorted into rough spreadsheet rows and cells.
  4. 04Download the ODS file, open it in Calc and check the important values and formatting against the PDF.

// why pdf-file

PDF to ODS features and limits

  • Fast Spreadsheet ExportGet the selectable text of a PDF into an OpenDocument spreadsheet in a few moments.
  • Approximate Table LayoutWords are grouped into rows and placed by their rough position across the page, not its exact styling.
  • OpenDocument OutputOpen the ODS file in LibreOffice Calc, Apache OpenOffice or any spreadsheet program that reads it.
  • Private ProcessingWe delete your PDF and the spreadsheet from our server automatically within two hours.
  • Honest Fidelity LimitsIt's best at table-like text. Free-form designs, merged cells, formulas, images and scans don't get fully rebuilt.
  • No software to installConvert from a desktop or mobile browser. The conversion itself runs on our server.

PDF to ODS: how the text becomes cells, and a tested example

A PDF shows you a table, but it doesn't store it as cells, so you can't sort, filter or sum anything. Converting PDF to ODS copies the text of each page into an OpenDocument spreadsheet that LibreOffice Calc opens directly.

Our PDF to ODS converter reads the selectable text, puts words that sit on the same line into one row and drops them into columns by where they sit on the page. For a simple table or list it's quick. Complex layouts still need cleanup, and this page explains why.

Convert PDF to ODS now

How to convert PDF to ODS online

It takes one PDF at a time, and there are no settings to pick.

  1. Click Choose Files and pick a PDF with selectable text, or drag it onto the page.
  2. Click Convert to ODS.
  3. Wait while the text gets sorted into rows and cells.
  4. Click Download and open the ODS file in LibreOffice Calc or another spreadsheet program.
PDF to ODS converter with test2.pdf uploaded and the Convert to ODS button
The PDF to ODS screen with a PDF uploaded.

What is an ODS file?

ODS is the spreadsheet format of the OpenDocument Format, an open standard published as ISO/IEC 26300. It's what LibreOffice Calc saves in by default, and most other spreadsheet programs open it fine.

Behind the scenes, our server builds the sheet with the same code as PDF to Excel, saves it as XLSX and then has LibreOffice turn that workbook into ODS. So the cells match in both files. The test below shows the one difference we did find.

How the PDF text becomes spreadsheet cells

  • Everything goes on one sheet, called PDF Text.
  • Each page starts with a row reading Page 1, Page 2 and so on, then its text, with an empty row between pages.
  • Words whose baselines sit within about 5 points of each other share a row, read top to bottom.
  • A word's column depends on how far it sits from the leftmost text on the page, roughly one column per 40 points, so indented text keeps its offset.
  • Every cell holds text, numbers included, so turn number columns back into numbers in Calc before you calculate with them.

Cell borders, merged cells, colours, images, charts and formulas from the PDF don't get rebuilt. A clean table exported from a spreadsheet program converts best; a brochure or a multi-column article leaves you with a sheet that needs a lot of hand work.

What happened when we tested PDF to ODS

We converted our small test file test2.pdf (909 B, 1 page with one line of text), and since there are no options to choose, the tool took the file as uploaded. The download was an ODS spreadsheet of 11.0 KB. Tested in October 2026.

PDF to ODS results screen with a Download button after converting test2.pdf
The results screen after converting test2.pdf.

A two-page statement in ODS and XLSX

In October 2026 we ran a 2.2 KB sample statement with the columns Date, Description, Money in, Money out and Balance through both tools. Its second page was stored portrait and shown landscape through a rotation setting.

  • The text was the same: both files had one sheet named PDF Text with the same 45 values, all stored as text, in the same places. The rotated page kept its rows in both.
  • Empty cells weren't. The XLSX also held 110 cells containing empty text in the gaps between values, while the ODS left those cells truly empty, and counting functions and jumps to the next filled cell treat the two differently in Calc or Excel.
  • The ODS came out smaller: 18.6 KB, against 20.6 KB for the XLSX.

Two things you'll have to fix in both. The right-aligned amounts started to the right of their headings, so the balances sat one column right of "Balance" and money out one column right of "Money out". And the wrapped line "reference 4471-2209" turned into a row of its own under the card payment it belongs to.

Will SUM work on the amounts?

Not directly. A plain SUM over the amounts returns 0, because every cell is text: in LibreOffice Calc 25.2, SUM over the two money-out cells of our statement, 1,250.00 and 84.30, gave 0.

Wrap the cells in VALUE and SUBSTITUTE and it works, without touching the cells: =SUMPRODUCT(VALUE(SUBSTITUTE(K6:K7,",",""))) gave 1334.3. SUBSTITUTE strips the thousands comma first, so the same trick handles amounts printed as 1,500.00.

PDFs that need another tool first

A scanned PDF holds pictures of letters rather than text, and the converter stops with a message saying no selectable text was found. Run the scan through OCR PDF first to give it a text layer, then convert the result.

Got a PDF with many pages? Cut out the ones with the table using our tools to split and organize PDFs. If all you need is the table rows, PDF Table Extract and PDF to CSV write them to a CSV file.

If you still have the original spreadsheet, use that. It holds the real cells and formulas that the PDF printout lost. And to turn an ODS file into a PDF, there's ODS to PDF.

Frequently Asked Questions about PDF to ODS

Is the PDF to ODS converter free?

Yes. You don't need an account, and each PDF can be up to 25 MB.

Will the spreadsheet look exactly like the PDF?

No. The text lands in rows and columns by its position on the page, but styling, merged cells, images and formulas aren't rebuilt.

Why are my numbers stored as text?

The converter copies every word as text. In LibreOffice Calc, select the column and convert it to numbers, for example with Data, Text to Columns.

Does it work with scanned PDFs?

No. A scan has no selectable text, so put it through OCR PDF first.

What happens to my PDF after conversion?

It's converted on our server and deleted automatically within two hours, along with the spreadsheet.

Turn your PDF text into an ODS spreadsheet