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

  1. Find the page numbers that hold your table. Use the page position in the file, not the number printed in the footer.
  2. Open PDF to Excel and upload the PDF.
  3. In Pages, keep all or enter only the pages you need, such as 4 or 1,3,5-9.
  4. Convert and download the XLSX workbook.
  5. 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.

Read page
security

Security

How We Want PDF checks uploads, delivers results, limits abuse, and removes queued job files.

Read page
retention

File retention

How long We Want PDF keeps uploaded files and results, and when they are removed.

Read page