Getting tables out of a PDF and into Excel

A PDF does not contain a table. It contains characters positioned at coordinates — the grid you see is drawn lines and aligned text. Extraction tools have to infer the table structure, which is why results vary from perfect to scrambled.

When it works well

PDF to Excel reconstructs rows and columns from the text positions. It performs best on:

• Digitally created PDFs (exported from Excel, accounting software, database reports) — the alignment is exact, so the inference is reliable.
• Regular grids — consistent columns, one header row, no merged cells spanning half the page.

When it struggles — and the fixes

• Scanned tables contain no text at all, just an image. Run OCR PDF first so there are characters to extract, then convert. Expect to check the numbers — OCR on dense digits is good but not perfect, and a transposed digit in a financial table matters.
• Multi-line cells and merged headers often come out split across rows. It's usually faster to convert via PDF to Word instead, where the table arrives as an editable Word table you can copy into Excel.
• Statements with running layouts (bank statements are the classic) sometimes mix table and non-table text. Convert, then delete the stray rows — still much faster than retyping.

A sanity check that catches most errors

After any extraction, sum a column that the original document also totals (statements and invoices almost always print totals). If your sum matches the printed total, the rows came through intact.

Privacy note

Table extraction runs on our server (the layout engine is too heavy for a browser), and files are auto-deleted after processing. For documents you'd rather keep entirely local, the OCR step can run fully in-browser with OCR (scanned files) — then paste the text into Excel manually.