About pdf to excel
This tool copies text and simple tables from a PDF into an Excel workbook, with one sheet per page.
Best for simple tables
Statements and lists where rows and columns line up give the best result. Complex tables with merged cells or nested headings will need manual adjustment.
After converting
- Check that numbers were read as numbers and dates as dates.
- Compare totals with the PDF to catch any missing digits.
- Remove blank rows and repeated headers from multi-page tables.
A worked example
A bank statement with a table of dates, descriptions and amounts is converted so that each page becomes a sheet. After converting, merge the sheets, convert the amount column to numbers and sort by date.
Verify the numbers
Compare the total of the converted figures with the total printed in the PDF. If they differ, a number was misread or a row is missing.
