A price list, a bank statement or a sales report arrives as a PDF, and you need to add up a column, filter by date or compare figures. Retyping hundreds of numbers invites mistakes. Converting the table to Excel gives you data you can actually work with — if you clean it properly afterwards.
Which PDFs Convert Best
- Digital tables (exported from accounting software or Excel) convert very well.
- Tables with visible borders are detected more reliably than borderless ones.
- Scanned tables need OCR first, and the numbers should be double-checked.
How to Convert
- If the table is only on a few pages, first keep just those pages with Extract Pages.
- Open PDF to Excel and upload the file.
- Download the spreadsheet and open it in Excel or Google Sheets.
Clean the Data Before You Trust It
Converted data often looks right but does not calculate correctly. Work through these checks:
- Remove repeated headers. Multi-page tables bring their header row with every page.
- Fix numbers stored as text. A small green triangle in the cell corner is the giveaway. Remove currency symbols and thousands separators with Find and Replace (for example, replace "Rs " and "," with nothing), then use *Convert to Number*.
- Split combined columns. If a date and description ended up together, use *Text to Columns*.
- Check negative values. Some statements show debits in brackets like (1,500). Replace brackets with a minus sign.
- Verify totals. Add up a column and compare it with the total printed in the PDF.
Example: A Bank Statement
A three-month statement converts into a sheet with Date, Description, Debit, Credit and Balance columns — plus the bank's header repeated at the top of each page. After deleting those repeated rows and converting Debit and Credit to numbers, a simple SUM on the Credit column shows total income for the period, which you can compare with the statement's own summary.
Common Problems and Fixes
| Problem | Fix |
|---|---|
| Everything in one column | Use Text to Columns with a space or tab delimiter |
| Totals do not match | Look for numbers stored as text or rows lost at page breaks |
| Dates look like random numbers | Format the column as Date |
| Merged cells | Unmerge and fill values down |
When a Word File Is Better
If the document is mostly paragraphs with a small table, PDF to Word is more suitable. Keep Excel for data you need to calculate.
For more on the tool itself, see our PDF to Excel guide. If your finished spreadsheet needs to go back out as a PDF, read converting Excel to PDF without cut-off columns.
