PDF to Excel Known limits

Extract tables from a PDF into an Excel spreadsheet.

Worth knowing before you startTable detection works by analysing the positions of text characters in the PDF content stream and inferring rows and columns from coordinate alignment. This is reliable on clean, bordered tables with consistent spacing. It degrades significantly on merged cells, borderless tables, tables that span pages, and anything where the PDF was produced by a scanner rather than a layout application. Review every table in the output before relying on it.

Choose PDF file or drop it anywhere on this page PDF Processed on your device — never uploaded

This tool does its work with JavaScript in your own browser — that is exactly why your files never get uploaded. Please enable JavaScript to use it.

How to pdf to excel

Open a PDF with tables.
Choose lattice mode for tables with visible borders, or stream mode for whitespace-separated columns.
Extract, review carefully, then download the XLSX.

About this tool

Extracting a table from a PDF into a spreadsheet is one of the most-requested PDF operations, and one of the most reliably disappointing. The gap between what users expect and what is actually possible follows directly from how PDFs work: a bordered table in a PDF is a set of lines and character positions, not a data structure with rows and columns. Inferring the data structure from the geometry is the problem, and it works well only when the geometry is clean and consistent.

Lattice mode — following the drawn border lines — is more reliable than stream mode when borders are present. The output should be treated as a starting point requiring review, not a clean extraction. For a table where accuracy matters, spot-check every row against the source PDF.

Questions

What is lattice versus stream detection?

Lattice detection looks for the line segments that form table borders and infers cell boundaries from them. It is the accurate method when borders are present. Stream detection looks for whitespace gaps between text positions to infer columns. It is the fallback for borderless tables but is prone to merging adjacent columns that have a gap in one row but not another.

Can it handle merged cells?

Poorly. Merged cells break the regular row-column grid that these heuristics depend on. The extracted output usually puts the merged cell's content in one cell and leaves the spanned cells empty, but it can also misalign an entire column. Check merged-cell rows carefully.

What if the PDF is a scanned image?

Scanned PDFs have no text layer, so there are no character coordinates to analyse. Run OCR first to add a text layer, then attempt extraction. OCR accuracy will limit table accuracy.

PDF to Excel Known limits

How to pdf to excel

About this tool

Questions

Related tools