How to Convert a PDF Table or Bank Statement to Excel
Tax time brings a familiar chore: a year of bank statements as PDFs, and a need to total up rent, insurance and donations. Copy-pasting from a PDF into a spreadsheet gives you one long column of mush. PDF to Excel finds the tables, shows you where it thinks the columns are, lets you fix them, and hands you an .xlsx where the amounts are actual numbers.
How the table detection works
The page reads the position of each piece of text using pdf.js. A line with two or more chunks separated by a wide gap is treated as a table row. Gaps that run vertically through all those rows become column dividers. You see this as a preview with the dividers drawn in.
The number handling is the bit that saves the most time. Amounts written as 1,250.00, the Indian style 1,00,000, accounting negatives like (500), and percentages like 12.5% are stored as real numbers, so SUM, sorting and filters work immediately. Things that only look numeric, like dates, account numbers and codes with leading zeros, are kept as text so Excel doesn't mangle them.
Steps
- Open the tool and choose the PDF. Add a page range if the tables sit on only a few pages.
- Press Find tables.
- Check each preview. Drag a divider that's in the wrong spot, use Add a column divider where two columns merged, or select a divider and press Delete.
- Untick any table you don't want.
- Press Download .xlsx. Each table gets its own sheet.
Example: tallying a statement
A typical downloaded statement has Date, Narration, Debit, Credit and Balance. Occasionally a long narration pushes into the Debit column and the detector draws a divider in the wrong place. Drag it right, check that the Balance column lines up, download. In Excel, filter the narration column for your landlord's name and SUM the debits. Then do the sanity check that matters: the last balance in the sheet should equal the closing balance on the PDF.
Where it struggles
- Scanned statements. Detection relies on the text stored in the PDF. A scan has none. OCR it with OCR PDF first, then try again, and check the numbers carefully.
- Tables without clear gaps. If columns are packed tightly, the gap-based detection may merge them. Adding a divider by hand fixes most of these.
- Multi-line cells. A narration wrapped over two lines can become two rows. Merge them in the spreadsheet afterwards.
- Locked PDFs. Many banks password-protect statements. Remove the password with Unlock PDF using the password you already have.
Tips
- Run one month first and get the dividers right, then do the rest. Statements from the same bank usually line up the same way.
- Keep the account number column as text even if Excel offers to convert it.
- If you just want the text and not a table, PDF to Word is the better fit.
Privacy
Bank statements are exactly the documents you shouldn't upload to a random converter. The tool page says the PDF isn't uploaded and the spreadsheet is built on your device, with pdf.js reading it inside the tab. Google ads run on the page as on the rest of the site.
FAQ
Will my bank statement work? Usually, if it's a downloaded PDF and not a scan. Check the dividers and compare totals.
Are numbers real numbers? Yes: commas, decimals, bracketed negatives and percentages are converted. Dates and codes stay text.
Can I fix a wrong column split? Yes, in the preview. The download matches what you see.
Does it open in Google Sheets? Yes, as well as Excel, Numbers and LibreOffice.
Tax season or expense report coming up? Try PDF to Excel on one statement first.
— Alok Kumar Singh