Convert PDF Tables to Excel

Extract tables from PDF files into Excel-ready rows and columns. Detects table structure, handles multi-page documents. Free, in-browser, no upload.

Bank statements, financial reports, inventory lists — the data you need is trapped in PDF tables, and retyping it is the worst part of the job. This extractor detects table structure in PDFs and reconstructs proper rows and columns, ready to paste into Excel or Google Sheets.

Multi-page documents work too: tables continue across pages and merge into one dataset. Extraction runs locally, so confidential statements and internal reports stay on your machine.

100% in-browser · no upload · no signup · nothing you paste or drop here leaves your device

📊
PDF/PDF to Excel Converter

PDF to Excel Converter

Extract tables from PDF files and export as CSV. Table detection based on text positioning — 100% local, no upload.

100% LOCALTable detectionMulti-pageCSV exportNo upload
Click to select a PDF file
Max 50 MB
Upload a PDF and click Extract Tables to see results here.
Data Source & Legal Disclaimer
Effective: CurrentLast updated: 8 months agoUpdate: Manual review

Table detection uses text positioning heuristics. Scanned PDFs (images) require OCR and may not produce accurate results. For best results, use PDFs with selectable text.

How PDF tables become spreadsheets — illustrated

A PDF table is not a table — it is a scatter of text items, each carrying a string and an(x, y) position from its text matrix. To recover a spreadsheet, this tool clusters items by Y into rows, sorts each row by X into columns, merges cells that are nearly touching, and emits the result as CSV rows and columns. The heuristics handle clean, text-based tables well; scanned pages have no text items to cluster, so they require OCR first.

Text positions → row/column clustering → spreadsheet grid
1 · TEXT POSITIONSItemQtyBolt12Nut48Qty → x=92 · y=8012 → x=112 · y=105each item = (str, x, y)2 · CLUSTERR1ItemQtyR2Bolt12R3Nut48same Y (±3px) → rowsort by X → columnsgap < 20px → merge cell3 · SPREADSHEETItemQtyTotalBolt126.00Nut489.60CSV rows & columnsnumeric cells unquoted→ Excel sees numbersHeuristics: items within 3px of the same Y group into a row; cells sort left-to-right.Adjacent cells merge when the gap is under 20px; rows with fewer than 2 columns are dropped.

Rows are recovered from shared Y baselines, columns from left-to-right X order, and cell boundaries from gaps between items. The CSV keeps numeric cells unquoted so Excel imports them as real numbers.

Turning an invoice line-item table into a CSV

A one-page invoice from a web shop has a 3-column line-item table plus a totals block.

  1. Read text positions:Each token arrives with (str, x, y) from its text matrix — “Qty” at x=90 y=720, “12” at x=170 y=720
  2. Group by Y into rows:Items within 3px of the same Y form a row; rows sort top-to-bottom
  3. Sort by X into columns:Within a row, items sort left-to-right and merge when gaps are under 20px
  4. Export as CSV:3 columns × 5 rows become Item,Qty,Total lines; numeric cells stay unquoted so Excel treats them as numbers

About this convert PDF table to Excel

This page covers extract table from pdf, pdf to spreadsheet converter free, copy pdf table to excel without retyping, pdf data extraction online — all the same underlying task as convert PDF table to Excel. The tool above is FreeToolHub's pdf to excel embedded in full: every feature works right here, and nothing you process is uploaded to any server.

Frequently asked questions

How do I copy a table from PDF to Excel?

Drop the PDF in and the extractor finds table regions, reconstructs the grid, and outputs rows and columns you can copy as CSV or download — open it in Excel and the values land in separate cells, not one text blob. Multi-page tables merge automatically.

Why does my extracted table look misaligned?

Some PDFs store tables as positioned text with no real grid, so reconstruction has to infer column boundaries from spacing. Heavily designed layouts with merged cells are the hardest case — the output editor lets you fix individual cells, and clean tabular data (statements, reports) converts accurately.

Joke of the Day
Sep 6

What do you call a crab that plays baseball?

100% Free, Forever

Keep Tools Free for Everyone

No paywalls, no signups, no data sold. Built by a solo developer who believes useful tools should be accessible to everyone.

Support me on Ko-fi— keep tools free

100% of proceeds go towards hosting & building more free tools.