PDF to Excel: how to get tables out without a mess
By Shubham · 4 November 2026 · 3 min read
Bank statements, price lists, reports and invoices often arrive as PDFs, but the numbers are only useful in a spreadsheet. Converting a PDF to Excel can save hours of retyping, but the result depends a lot on how the PDF was made.
Why some PDFs convert perfectly and others don't
A PDF doesn't store a "table". It stores pieces of text at positions on a page, and sometimes lines drawn around them. The converter has to guess which pieces belong in which row and column.
- PDFs exported from Excel or accounting software usually convert well. The text is real and the columns line up.
- Scanned PDFs are pictures. They need OCR first, and the result needs more checking.
- Tables with merged cells, multi-line cells or no grid lines are the hardest to guess.
Step by step
- If the PDF is a scan (you can't select the text), run it through OCR PDF first.
- If you only need one table from a long document, pull out those pages with Extract Pages. Fewer pages means less to clean up.
- Convert with PDF to Excel.
- Open the file and check the totals against the PDF before you trust any formula.
Common problems and quick fixes
Numbers are stored as text. They are left-aligned and SUM gives 0. Select the column, then use Data → Text to Columns → Finish, or multiply by 1 in a helper column. Remove currency symbols and thousands separators first if needed.
One row became two. Long descriptions that wrapped onto a second line in the PDF often become separate rows. Sort or filter by a column that should never be empty (such as date or amount) to find the broken rows, then join them.
Headers repeat on every page. Multi-page tables bring the header row with them each time. Filter the first column for the header text and delete those rows.
Dates look wrong. 03/04/2026 might be read as 4 March instead of 3 April. Check a date where the day is above 12 to see which format was used, then fix the column with Text to Columns and the right date order.
Columns shifted. If one row has an empty cell, the values after it can move one column left. Look for rows where text appears in a number column.
When to use CSV instead
If you'll import the data into another program, PDF to CSV gives a simpler file with no formatting, which many systems prefer.
A note on bank statements
Many banks let you download statements as CSV or Excel directly from net banking. That is always more accurate than converting a PDF, so check there first. If you only have PDFs, convert them, then check the opening and closing balance against the statement.
Privacy
Financial documents are sensitive. On CallMePDF.com, files processed on our server are deleted automatically after processing. Still, don't share converted spreadsheets more widely than the original PDFs.