How to Get Tables Out of a PDF and into Excel
Published:
Numbers locked in a PDF are frustrating. The bank statement you want in a budget, the supplier price list you need to sort, the table in an annual report you want to chart: you can see every figure, but you cannot add them up. Copying and pasting usually dumps everything into one column, and retyping a hundred rows is how mistakes creep in.
PDF to Excel conversion solves much of this, but not magically, and not for every PDF. In this guide we explain which files convert well, what to do with scanned documents, and the checks we always run before trusting the resulting spreadsheet.
Why some PDFs convert well and others do not
A PDF does not really contain tables. It contains pieces of text placed at exact positions on a page, plus lines that happen to look like a grid. A converter has to look at those positions and guess which text belongs in which row and column. When the PDF was generated digitally, from accounting software, a spreadsheet or a banking portal, the text is real and well aligned, and that guess is usually very good.
The trouble starts with layouts that bend the grid. These are the cases where we expect to tidy up afterwards:
- Merged cells and headers that span several columns.
- Rows where a description wraps onto two or three lines.
- Header rows repeated at the top of every page.
- Tables with no lines at all, where columns are separated only by white space.
- Several small tables side by side on one page.
Scanned PDFs need OCR first
If your PDF is a scan or a photo of a page, there is no text inside it at all, only a picture of text. A table converter has nothing to read and produces an empty or useless spreadsheet. A quick test: try to select a single number in your PDF viewer. If you cannot highlight it, the page is an image.
The fix is to run OCR PDF first. It recognises the characters and adds a real text layer to the document, after which PDF to Excel has something to work with. Be realistic about the results, though. OCR on a clean, straight scan is good, but it can confuse similar characters such as 0 and O, 1 and l, or a comma and a full stop, and in a table of amounts those mistakes matter. Scanned tables always need a closer check than digital ones.
How to convert a PDF to Excel step by step
PDF to Excel runs on our server, because reconstructing tables needs heavier processing than a browser can comfortably do. Your file is uploaded to our server in Germany and deleted right after conversion. You need a free account; the free plan includes 3 tasks per day with files up to 10 MB, and Bronze, Silver and Gold plans allow more.
- 1. If the PDF is long and you need only a few pages, cut it down first with Extract Pages. Less to convert means less to clean up.
- 2. Open PDF to Excel and drop your PDF into the box.
- 3. Click Convert to Excel and wait while the server analyses the pages.
- 4. Download the XLSX file. Each PDF page becomes its own sheet.
- 5. Open it in Excel, Google Sheets, Numbers or LibreOffice and start checking.
Checking the numbers before you trust them
We never use a converted spreadsheet without verifying it, especially for money. The conversion is usually right, but 'usually' is not good enough for a tax return or an invoice dispute. Our checks take a few minutes:
- Compare totals. If the PDF shows a total or a closing balance, add up the column in Excel and compare. A match is the strongest sign everything landed correctly.
- Check that numbers are numbers. Cells aligned to the left are often stored as text and will not add up. Use Excel's 'Convert to Number' or a quick multiply-by-one to fix them.
- Watch decimal separators. A statement using 1.234,56 can be misread in a spreadsheet set to 1,234.56. Set the right regional format before you sum anything.
- Look for shifted rows. Wrapped descriptions sometimes split into an extra row, pushing amounts out of line with their labels.
- Remove repeated headers that came from each page, then combine the sheets into one table if you need to sort or filter across pages.
When another approach is quicker
For one small table, honestly, selecting it in your PDF viewer and pasting into Excel can be faster, especially if you then use Excel's Text to Columns to split the values. For text-heavy documents where tables are only part of the story, PDF to Word keeps paragraphs and tables together in an editable document.
And if you are building a document rather than extracting one, for example an invoice or a simple budget to send to a client, our fillable templates at /templates give you a ready layout you complete in the browser. When the spreadsheet is finished and has to go back out as a fixed document, Excel to PDF closes the loop.
A real example: a bank statement for a budget
A typical job for us is turning three months of bank statements into one budget sheet. We download the statements as PDFs from the banking portal, which gives digital files with real text, the best starting point. If they arrive password-protected, Unlock PDF removes the password first, since a locked file cannot be converted. Then each statement goes through PDF to Excel.
In the spreadsheet we delete the repeated page headers, copy the transaction rows from every sheet into one table, fix the date and amount formats, and compare the sum of each month against the closing balance on the statement. Once those match, we add a category column and build the budget from there. The whole thing takes about twenty minutes, compared with an afternoon of retyping.
Frequently asked questions
Can I convert a scanned PDF to Excel?
Only after running OCR PDF, which adds a text layer. Without text, there is nothing for the converter to read. Check OCR results carefully.
Is my PDF kept on your server?
No. It is uploaded to our server in Germany for the conversion and deleted right after.
Why is each page a separate sheet?
The converter treats each page on its own. Remove repeated headers and combine the sheets if you need one continuous table.
Why won't my converted numbers add up?
Some cells may be stored as text, or the decimal separator may be misread. Convert them to numbers and check the regional format.
Do I need an account?
Yes, a free account. The free plan includes 3 tasks per day and files up to 10 MB.