How tables are found and converted
A PDF doesn't store tables, only text placed at positions on the page. To convert PDF to XLSX, each page is checked in two ways. Lines drawn in the PDF, such as cell borders, mark out rows and columns. Where there are no lines, text that lines up in the same columns over several rows is treated as a table. Rows that wrap onto a second line are joined back together.
Your options
- One sheet per page keeps each page separate and easy to compare with the PDF.
- All tables in one sheet is best for long statements: a table that continues across pages with the same header becomes one list you can sort and filter.
- Keep non-table text adds titles, addresses and notes as rows in column A, in reading order.
Values are read carefully. 1,234.56 becomes a number, $45.00 a currency amount, 12.5% a percentage and 15/03/2026 a date. Anything that could be misread, including IDs with leading zeros, stays as text.
Checking your spreadsheet after converting
The header row is bold and frozen, so it stays in view while you scroll, and each column is made wide enough for its contents. A quick check is worth a minute: add up a column with SUM and compare it with the total printed in the PDF. If a number appears on the left of its cell, it was kept as text, usually because it was written in an unusual way; you can change it with Excel's Convert to Number option. Dates use the same order as your PDF, day first or month first, and can be shown in any other format you like.
Who extracts tables from PDF files?
- Students and researchers reuse data tables from reports and papers in their own charts.
- Office and finance work: reconcile bank statements, check invoices against orders, and update price lists.
- Small businesses move supplier catalogues and sales summaries into a spreadsheet to share with the team.
What converts well and what doesn't
Statements, invoices, price lists and reports exported from software convert well, because their columns line up neatly. Results are less reliable for:
- Scanned PDFs and photos of documents, which contain no text to extract.
- Tables with merged cells, nested tables, or columns that are very close together.
- Charts and graphs, which are drawings rather than data.
- Dates written so they could mean two things, which are kept as text to avoid mistakes.
Need the text and layout of the whole document instead? Use PDF to Word.
Is it safe? Your files never leave your device
Bank statements and invoices hold sensitive details, so nothing is uploaded. The PDF is read with pdf.js and the workbook is written with ExcelJS, both running inside your browser. When you close the page, the file is gone from memory.
Tips for best results
- Download statements as PDF from your bank's website rather than scanning paper copies.
- Select only the pages with tables to keep the workbook tidy.
- Use All tables in one sheet for statements that run over many pages.
- Only need a few pages from a long report? Take them out first with Split PDF, or combine several statements with Merge PDF.