PDF Table to Excel

How PDF tables become spreadsheets

A PDF has no real “table” — just pieces of text placed at positions on the page. This tool groups text at the same height into rows, then looks for vertical gaps with no text running down many rows to split the columns. The cleaner the grid, the more accurate the result.

Works well with

• Bank and card statements, grade reports, quotes and statistics exported directly from software
• Tables with clear gaps between columns and one line per cell

Struggles with

• Scanned or photographed PDFs — no text inside. Try Image to Text (OCR) first.
• Cells that wrap onto several lines — each line becomes its own row; merge them in Excel.
• Several tables side by side on one page — columns may mix.

Options

Table rows only skips one-cell lines such as titles and notes. Convert amounts to numbers turns values like 1,234,000, -5,000 or (3,000) into real numbers, while IDs starting with 0 and numbers longer than 15 digits stay as text. Turn on “Drop repeated header rows” when every page repeats the same header. Nothing is uploaded.