Skip to content

PDF to Excel

Pull table-like text into spreadsheet cells.

Good to know

Finds tables from text alignment and stores numbers as real numeric cells. Ruled tables whose text does not line up, merged cells and scanned tables are not recognised.

About this tool

PDF to Excel finds tables in a PDF and puts them into spreadsheet cells, storing numbers as real numeric values you can add up and sort. It works best on reports and statements whose columns line up neatly.

How to use it

  1. Choose one or more PDFs whose text can be selected; scans will not work.
  2. Pick One sheet per page or Everything on one sheet.
  3. Turn on “Also include text outside tables” if you want headings and other lines too, in reading order.
  4. Select Convert to Excel and check the workbook before you rely on the figures.

Good to know

  • Tables are detected from text alignment, not from drawn lines. A ruled table whose text does not line up may come out as plain rows, and merged cells are not recreated.
  • Scanned tables are not recognised, because a scan has no text to align; run OCR PDF first, accepting that recognition can misread digits.
  • If no table is found on a page, each line of text goes in its own row, split into cells where there are wide gaps, and the result tells you.
  • Several numbers squeezed into one cell usually sit under a heading that spans columns; the result counts these cells so you can split them.
  • Your files are processed in this browser tab and are never uploaded to a server. How your privacy is protected

Common questions

Are the numbers stored as numbers or as text?

As numbers, so formulas, sums and sorting work straight away. Text that is not a number stays as text.

Can it read a table from a photo or a scan?

Not directly. Make the scan searchable with OCR PDF first; even then, check every figure against the original.