A supplier sends a 12-page PDF of pricing tables. You need the numbers in Excel so you can sort, filter, and run them against your own catalogue. Retyping six hundred rows is not the plan.
Done right, the whole thing takes two minutes.
Why PDF tables are tricky to extract
PDFs don't store tables as tables. They store positioned text — letters at specific x/y coordinates — and a good converter has to reverse-engineer which clusters belong to which row and column.
When the original was exported from Excel, the geometry is precise and detection is near-perfect. When it was scanned, hand-built in InDesign, or assembled from screenshots, the converter has to make educated guesses.
Use a converter built for tables
Flint's PDF to Excel converter detects tables across pages and rebuilds them as proper Excel rows and columns with real cell values. Numbers stay numeric (so SUM works), dates stay dates, text stays text. No giant text blob in column A.
If the PDF has both prose and tables, you'll get one sheet per page or per table — easier to clean than one giant sheet.
Watch for merged cells and borderless tables
Two perennial gotchas: merged cells (a header spanning three columns) are detected by some converters and missed by others. Borderless tables are inferred from column spacing alone — fine when spacing is wide, unreliable when it's tight.
Quick fix: spot-check the first and last rows of every detected table. If something looks wrong, edit in Excel directly — much faster than re-converting.
When OCR enters the picture
Scanned PDF? OCR runs automatically. Expect 95–99% accuracy on clean print, lower on faxes. Numbers in scanned tables are the highest-risk OCR targets — a stray pixel can turn 1 into 7. Double-check column totals if the document is mission-critical, and consider rounding mismatches as a tell that something OCR'd wrong upstream.
FAQ
Will numbers stay numeric?
Yes — the converter type-detects each column. If a column with mostly numbers has one stray text entry, that entry stays text. Easy to spot and fix in Excel.
What about multi-page tables?
Tables that continue across pages are stitched back into a single Excel range when the headers match. If headers are missing on continuation pages, you may get a split — easy to glue back manually.
Can I export to CSV instead?
Yes — convert PDF to CSV for a lean, comma-delimited file. Use CSV when you're feeding the data into a database or another script; Excel for human review.
What about formulas?
Formulas don't survive PDF — only the rendered results do. You'll get values, not formulas, in the converted sheet.
Stop retyping. Convert your PDF to Excel and start working with the numbers.