Getting a table out of a PDF and into real cells
A table in a PDF is an illusion. The file records a set of text fragments at fixed coordinates, and your eye assembles them into rows and columns. Nothing in the document says this is a table, which column a value belongs to, or where one record ends. Turning that back into a spreadsheet means rediscovering a structure that was thrown away when the PDF was created.
How the reconstruction works
- Rows come from vertical position. Text fragments sharing a baseline are grouped into one row, then ordered left to right.
- Columns come from repetition. The tool collects the horizontal start position of every fragment on the page and looks for positions that recur across many rows. Those recurring positions become column edges, so a genuine column has to prove itself across the page rather than appear once.
- Gaps are the fallback. When no consistent edges emerge, each row is split on its wider internal spaces instead. Less precise, but it keeps loosely structured pages usable.
- Numbers are typed, not just copied. Values that read as numeric are written as numbers, so totals and averages work without a cleanup pass first.
- One page, one worksheet. Each PDF page becomes its own sheet, named Page 1, Page 2 and so on, which keeps a multi page report navigable.
What converts well, and what fights back
Improving the odds
When you control how the PDF is produced, small choices upstream pay off. Exporting a wide table in landscape keeps columns apart instead of squeezing them until their edges blur. Turning off cell wrapping keeps one record on one line. Leaving generous column spacing gives the edge detection something unambiguous to find.
When you do not control the source, cropping helps. Removing headers, footers and margin notes with Crop PDF takes stray text out of the page before conversion, so it stops competing with the real columns. On a long report, isolate the pages that actually hold the table with Split PDF first.
Check before you calculate
Any extracted table deserves one verification pass before it feeds a decision. Compare the row count against the source, add up a column you already know the total of, and look at the first and last record on every sheet. Reconstruction errors cluster at page boundaries and in the widest columns, so those are the places to spend your attention.