Convert PDF to ODS Portable Document Format ↔ OpenDocument Spreadsheet Free Online Secure
Your PDF is read here in your browser and written out as ODS. A PDF records where each letter sits, not what it means, so the headings, paragraphs, lists and tables are worked out from position and size — and you get something you can edit again, not a picture of a page.
Convert your file
Drop a PDF here, or choose one.
Your file never leaves this device. Everything runs in your browser.
Nothing uploaded
Why this direction is the hard one
PDF was designed as a one-way street. It does not record that a document has paragraphs, headings, tables or columns; it records that a particular glyph sits at a particular point on the page, in a particular font, and that a line runs from here to there. That is exactly what makes it reliable — nothing is left for the other machine to interpret — and exactly what makes coming back out of it difficult. A converter has to reconstruct meaning that was deliberately thrown away: deciding which lines belong to one paragraph, which runs of text form a table, where a column ends. Going into PDF is a recording; coming out of it is a reading, and readings can differ.
Where you need it
The moment you need to change something you only have as a finished document: a contract to amend, a report whose table you want in a spreadsheet, a deck to reuse, an invoice whose figures must go into the accounts, a page you want as an image for a slide. It is also the usual route when the person who holds the editable original cannot be reached, or when the original was made in software you no longer have.
Questions people ask
Why doesn't the result look exactly like the PDF?
Because the layout had to be rebuilt rather than copied. Text in a PDF has a position but no structure, so the converter infers paragraphs, columns and tables from where things sit — and inference is sometimes wrong. Documents with a single column of plain text come back almost perfectly; multi-column layouts, text wrapped around images, and complex tables are where the guessing shows. Expect to tidy the result rather than to use it untouched.
I converted a scanned PDF and got no text at all. Why?
Because a scanned page contains a photograph of text, not text. To the file there is no difference between a page of writing and a picture of a brick wall — both are just pixels. Extracting words from it needs optical character recognition, which is a separate process that looks at the shapes and guesses the letters. Converting such a PDF to a document gives you the image placed in a document, which is usually not what was wanted.
Does the file lose quality?
It depends on what the two formats can hold. Converting between formats that store the same thing — a PNG to a BMP, a WAV to a FLAC — loses nothing. Converting into a format that throws information away to save space, such as JPEG or MP3, loses a little every time, and converting back does not bring it back. Where a choice exists, this page errs towards keeping the original quality rather than making the smallest file.
Is my file uploaded anywhere?
No. The conversion happens inside your browser, on your own machine; the file never leaves it and there is no server here that could receive it. That is why a large file is limited by your own memory rather than by an upload, and why nothing you convert can appear in anybody's logs — including ours. The audio and video tools do fetch their conversion engine from this site the first time you use them, some thirty megabytes once; after that the work still happens entirely on your machine.
Why people convert PDF to ODS
Figures that arrive in a PDF are figures you cannot work with. A bank statement, a price list, a timetable, a report with a table of results: they look tidy on screen, but you cannot sort them, add them up or paste them into a calculation. The numbers are there, and yet they might as well be a photograph. That is why people convert PDF to ODS: they want the rows and columns of a table back in a spreadsheet, where LibreOffice Calc, Excel or Google Sheets can sort them, filter them and calculate with them. ODS is the spreadsheet format of the OpenDocument family, the native format of LibreOffice and a standard in many schools and public offices.
The difficulty is that a PDF does not store a table as a table. It stores where each piece of text sits on the page: this number here, that word there. The rows and columns that your eye sees are a consequence of the arrangement, not something the file records. A conversion has to rediscover them, and it does so by looking at the gaps. This page does it in your browser, and gives you a spreadsheet you can edit, not a picture of a page.
Your PDF is not uploaded to a server. That matters for bank statements, invoices, payrolls and anything else you would rather not hand to a stranger's machine. Below you will find how the conversion works, what it recognises, what it does not and how to get the best result.
How the conversion works
Rows and columns are found from the gaps
Your PDF is read inside your browser. For each page, the converter collects the text with its positions. Items that sit on the same horizontal line form a row. A column is found by looking for the vertical gaps that it leaves behind: a strip of the page where no text appears, running down beside a block of text. Where such gaps appear in the same place on many lines, the converter draws a column boundary. Each cell is then filled with the text that falls between the boundaries.
One sheet for each page
Each page of the PDF becomes its own sheet, so a ten-page statement arrives as ten sheets, not as one long one. This keeps the pages apart, lets you check each against the original and makes it easy to delete the pages you do not need. If you want all the rows in one sheet, you can copy them together afterwards.
Why gaps work well
Most tables in business documents are laid out with clear space between the columns: dates, descriptions, amounts. That space is the signal the converter uses. The cleaner the spacing, the more accurately the columns are found.
What is kept
Rows and columns
The structure of the table is kept: lines of the page become rows, and the columns found from the gaps become the columns of the sheet. Each cell holds the text that was at that place on the page.
The pages as sheets
The page order is preserved in the order of the sheets, so you can follow the document from the first sheet to the last.
A file that opens in the common programs
The ODS opens in LibreOffice Calc, Excel and Google Sheets, and cells can be edited, sorted and formatted like any you typed yourself.
What is not carried over
No formulas, no cell types, no formatting
A PDF has no formulas, no cell types and no formatting to carry over. It holds only printed text. So everything arrives as text, and you may need to tell the spreadsheet which columns are numbers. A column of amounts will at first be treated as words, and sums will not work until you convert the cells to numbers. In Calc, you can select the column and choose a number format, or use the command that converts text to numbers.
Columns separated by rules are not seen
Columns separated by rules rather than by space are not seen. If a table uses vertical lines to divide its columns but the text itself is packed closely, the converter has no gap to find. It reads the gaps in the text, not the lines that are drawn. When the result puts two columns into one cell, that is the reason.
Prose comes out as one column
A page of ordinary prose comes out as one column, which is the honest answer for a page that was never a table. If you convert PDF to ODS with a document that is mostly text, do not be surprised to see long sentences in a single column of cells.
Scanned PDFs yield nothing
A scanned PDF holds a picture of text, not text. From one of those, nothing comes out. Recognising letters in an image is a different job, called optical character recognition, and this conversion does not do it.
How to convert PDF to ODS here
Add your PDF
Drop the PDF onto the page or pick it from your device. It is opened inside your browser and is not uploaded.
Convert
Press the button. A short document takes a few seconds, and a long one takes longer. Leave the page open until it finishes.
Download and open
Download the ODS and open it in your spreadsheet program. Check the first sheet against the PDF, set the number formats and fix any column that was merged or split.
A closer look at PDF and ODS
Two different ideas of a table
In a spreadsheet, a table is a grid of cells, each holding a value that has a type: a number, a date, a piece of text. In a PDF, a table is a pattern of words and numbers laid out so that people see a table. The first is data; the second is a drawing of data. To convert PDF to ODS is to go from the drawing back to the data, and that always involves some interpretation.
Why everything arrives as text
Because the PDF stores only characters, the converter cannot tell whether 1,250 is an amount, a code or a date fragment. It does not guess. It gives you the characters, and you declare the type once you see the sheet. This avoids a quiet error that would be much worse: a number silently turned into a date or truncated.
Numbers and decimal marks
Be careful with decimal marks and thousands separators. A sheet set for one convention may misread a number written in another. After the conversion, check a few amounts, and if needed use find and replace to switch commas and points before converting the cells to numbers.
Common situations in detail
Bank statements
A statement as a PDF gives a list of dates, descriptions and amounts. Convert PDF to ODS, set the amount column to numbers and you can sort by size, filter by a word and add up the totals. Check the opening and closing balances against the document to be sure nothing was shifted.
Price lists and catalogues
A supplier sends prices as a PDF. In a spreadsheet you can apply a percentage, compare with another list or import the products into a shop. Check the code and price columns first, since they are the ones that matter most.
Public offices and schools
Where LibreOffice is the standard, an ODS is the natural result. A table in a circular or a report becomes data that can be filtered, counted and charted without retyping.
Reports with tables of results
A report that includes tables of results, such as survey figures or accounts, can be brought into a spreadsheet for checking and for building charts. The figures that were locked in the page become data you can use.
Practical advice before you convert PDF to ODS
Test whether the text can be selected
Open the PDF in any viewer and try to select a number with the mouse. If the digits highlight, the file holds real text and you can convert PDF to ODS with good hope. If you can only drag a rectangle over the page, it is a picture, and no conversion of this kind will find any figures.
Prefer tables with clear spacing
Tables laid out with visible space between the columns convert best. When you convert PDF to ODS with a dense table in which columns are separated only by lines, expect to split some cells by hand.
Convert only the pages you need
If the table is on a few pages of a long document, use extract pages from PDF first. A shorter file converts faster and gives you fewer sheets to check.
Keep the PDF open next to the sheet
Compare the two for the first page or two. You will soon see how the converter treats this particular document and how much attention the rest deserves.
Questions people ask before converting
Why are my numbers left-aligned and not adding up?
Because everything arrives as text. Select the column and convert the cells to numbers. Then sums and sorting work as you expect.
Why are two columns in one cell?
Probably they were separated by a rule, not by space. The converter looks for gaps in the text, so it did not see the boundary. Split the cell by hand with the text-to-columns tool of your spreadsheet.
Why is a page of text in one column?
Because it was never a table. The honest result for prose is a single column.
Why did nothing come out?
Almost certainly the PDF is a scan. A scan holds a picture of text, not text.
Is my PDF uploaded?
No. The conversion runs in your browser and the document never leaves your device.
Can I get an Excel file instead?
Yes. PDF to XLS gives a spreadsheet for Excel.
Choosing wisely when you convert PDF to ODS
Start with the cleanest source you have
A PDF exported from a spreadsheet or an accounting program converts far better than a scan or a photograph. If you can ask the sender for the spreadsheet itself, do so; the PDF is a second best.
Decide what you need from the figures
If you need totals and sorting, set the number formats first. If you just want to read the figures, the sheet may be good enough as it stands.
Verify the totals
When you convert PDF to ODS for money, check at least one total against the document. If a figure has shifted by one column, the sum will show it.
Keep the PDF
The PDF is the authority. Keep it so you can compare against it and return to it if the conversion misses something.
Getting a good result after the conversion
Set the types of the columns
Go through the columns and set each to the right type: number, date or text. This one step makes the sheet behave like a proper spreadsheet.
Remove the leftovers
Headers and footers repeated on each page appear as rows in each sheet. Delete them, or filter them out, so that they do not disturb sums.
Join the sheets if you need one list
If the table runs across many pages and you want a single list, copy the rows of each sheet below one another into one sheet, taking care to leave out the repeated headers.
Use the standard filter
Calc has a standard filter and an autofilter. Switch the autofilter on over the header row and you can narrow the list by any column, which is often all that was wanted from the PDF in the first place.
Privacy and handling
Why local conversion matters for figures
PDF files with tables often hold what is private: bank statements, payrolls, invoices, accounts. Many online converters ask you to upload the file to a server, process it and send back the result, and for a while a copy lives on a machine you do not control. Here your own browser does the work, so the document stays on your device.
What happens when you leave
When you close the page, the converted file disappears from the browser, so download it first. Nothing about your document is kept.
If something goes wrong
The columns are shifted
Check the PDF: perhaps a column has long entries that run into the next one. Adjust the cells by hand, or split them with the text-to-columns tool.
The page freezes with a large document
Everything runs on your device, and a long document needs memory. Try again on a computer, or convert the document in parts.
The PDF is password protected
A protected document must be opened with its password first. Without it, the text cannot be read.
Related tools
The same family of tools covers the neighbouring jobs. For an Excel spreadsheet, PDF to XLS works in the same way. For text you want to edit as a document, there is PDF to ODT, and for slides, PDF to ODP. To go back to a PDF, ODS to PDF turns a sheet into a document, and ODS to XLS and XLS to ODS move spreadsheets between the two worlds.
A worked example
Say a town hall publishes a list of fees as a PDF of four pages, and you want to compare them with last year's. You drop the PDF here and press the button. A few seconds later you download an ODS with four sheets, one for each page, with the names of the services and the amounts in separate columns. You set the amount column to numbers, paste last year's figures beside them and add a column for the difference. The PDF stays in your folder as the official copy.
A short checklist
Before converting
Check that the PDF is not a scan. Decide which pages you need. Keep the PDF safe.
While converting
Stay on the page until the file is ready.
After converting
Open the ODS, set the column types, remove repeated headers and check a total against the PDF.
Common mistakes
Trusting the numbers blindly
Always compare a total or a few figures with the PDF before you rely on the sheet.
Expecting formulas
A PDF holds printed values, not formulas. Do not convert PDF to ODS hoping to find the calculations behind the numbers.
Trying it on a scan
A scanned PDF holds a picture of text, so nothing comes out. Check that you can select text before you start.
Your document stays on your device
The conversion happens locally. Your PDF is read by your own browser, rewritten there and handed back as an ODS. Nothing is uploaded, so no copy ends up on a server and nobody else can read it. For figures with private content, that is the safe way to convert PDF to ODS.
Summary
To convert PDF to ODS here, drop the document and press the button. Your PDF is read in your browser and written out as ODS. A PDF records where each letter sits, not what it means, so rows and columns are found by looking for the vertical gaps that a column leaves behind. Each page of the PDF becomes its own sheet. A PDF has no formulas, no cell types and no formatting to carry over, so everything arrives as text and you may need to tell the spreadsheet which columns are numbers. Columns separated by rules rather than by space are not seen, and a page of prose comes out as one column. Nothing leaves your device.