How to convert a PDF table to Excel
Financial statements, price lists and reports often arrive as PDFs, and retyping their tables is slow and error-prone. Converting to Excel usually gets you most of the way there — as long as you understand that a PDF does not actually store a table, and check the result with that in mind.
Updated September 15, 20266 min read
On this page
Why PDF tables are tricky
A PDF stores text at coordinates on a page. It has no idea that some of that text forms rows and columns. Any converter has to infer the columns from where the words sit, which is why some tables come through perfectly and others need a little tidying.
- Ruled tables and clearly aligned columns convert most reliably.
- Merged cells, stacked header rows and columns that do not line up are where mistakes happen.
- A screenshot of a spreadsheet is a picture and contains no text to read at all.
How to convert a PDF to Excel, step by step
The PDF is parsed and the spreadsheet is written without the file being uploaded, which matters for financial data.
- Open PDF to Excel and add the PDF that contains the table.
- Choose whether to skip empty rows.
- Run the tool and download the .xlsx file. Each page of the PDF becomes its own worksheet.
- Check the column boundaries against the original before relying on the numbers.
Reconstructed tables are usually right and occasionally off by a column. A quick look at the totals row catches most problems.
Scanned statements need OCR first
If you cannot select the text in the PDF, the pages are images and there is nothing for a converter to read. Run OCR PDF first to add a text layer, then convert the result to Excel.
When CSV is the better choice
If you only need the data — to import into accounting software or a database rather than to edit in a spreadsheet — PDF to CSV gives you plain comma-separated values without spreadsheet formatting.