Extract tabular PDF data into XLSX.
Open tool Help guide
How to extract PDF tables to Excel
Pull table-style data out of a PDF and into an Excel workbook for sorting, cleanup, and analysis.
Last updated:
Quick steps
- Find the page numbers that hold your table. Use the page position in the file, not the number printed in the footer.
- Open PDF to Excel and upload the PDF.
- In Pages, keep
allor enter only the pages you need, such as4or1,3,5-9. - Convert and download the XLSX workbook.
- Open it and compare a few rows and the totals against the PDF before using the data.
Why limiting pages helps
A long report often has a few pages of tables and many pages of text. If you export everything, the workbook fills with paragraphs broken into cells, which you then have to delete. Entering just the table pages in Pages gives a cleaner workbook that is easier to review.
If the PDF is large and you want to keep a reference copy of only the table pages, you can also pull them out first with Extract Pages and convert that smaller file.
What converts well
- Tables with clear rows and columns, such as bank statements, price lists, invoices, and exported reports.
- PDFs that were generated by software, where the text can be selected.
Things that need more cleanup:
- Merged header cells spanning several columns.
- Tables that continue across pages, where the header repeats on each page.
- Numbers with currency symbols, thousands separators, or brackets for negatives, which may land as text instead of numbers.
- Scanned tables. A scanned page is a picture, so there are no text cells to read. Start from the original spreadsheet or a digital statement if you can get one.
Worked example
Imagine a 30-page annual report where the financial tables are on pages 12 to
15. You enter 12-15 in Pages, convert, and open the workbook. The header
row repeats at the top of each page’s block, so you delete the duplicates and
keep one. A few amounts arrive as text because of currency symbols, so you
use your spreadsheet’s convert-to-number feature on that column. Finally, you
add up a column and check it matches the total printed in the report.
Troubleshooting
- Everything is in one column. The table may be laid out with spaces rather than real columns. Use your spreadsheet’s text-to-columns feature to split it.
- Formulas do not work on the numbers. They were imported as text. Remove symbols and convert the cells to numbers.
- Rows are out of alignment. Wrapped text in a cell can create extra rows. Merge the split lines back together by hand.
- The workbook is empty or holds only images. The PDF is probably a scan.
When this is not the right tool
If you need the surrounding text and layout, not just the figures, PDF to Word is the better fit. If you only need to share the table, send the PDF itself. And when your analysis is done, turn the workbook back into a tidy PDF with Excel to PDF.
Always keep the source PDF. The spreadsheet is a working copy, and the original is what you check figures against.
Trust center
Trust pages
How We Want PDF handles your files: privacy, security, and how long uploads are kept.
privacy
Privacy
How We Want PDF handles the files you upload, what is needed to use the tools, and which tools send content to an AI provider.
security
Security
How We Want PDF checks uploads, delivers results, limits abuse, and removes queued job files.
retention
File retention
How long We Want PDF keeps uploaded files and results, and when they are removed.