Converting
How to Convert PDF to Excel and Keep the Table Structure
Get tables out of a PDF and into real spreadsheet cells. What makes a table convert cleanly, and how to fix the ones that do not.
Hamza M.
PDF Workflow Editor
The reason this is hard is that a PDF has no idea it contains a table. It contains text at coordinates. The table you can see is a pattern your eye assembles from alignment and ruled lines — and any converter has to assemble the same pattern from the same clues.
Convert a PDF table to a spreadsheet
- 1Open the PDF to Excel tool and add your file. It is processed in your browser and never uploaded.
- 2Convert. You get an .xlsx workbook with a Summary sheet plus one sheet per PDF page, and each line of text on the page lands in its own row.
- 3Split each row into columns with Excel's Text to Columns (or Split text to columns in Google Sheets).
- 4Check the column boundaries and the totals before you rely on any of it.
Be clear about what this tool does: it gets the text out in the right order, page by page and line by line, and leaves the column split to you. It does not try to guess cell boundaries itself — which means it never silently guesses them wrong, but it does mean the Text to Columns step is part of the job.
PDF to Excel format: what comes back and what does not
Whether you searched "pdf to excel format" or "pdf document to excel", this is often a spreadsheet that someone printed to PDF and that now needs to be a spreadsheet again. The values come back. The calculation layer does not: when a workbook is saved as a PDF, every cell is frozen into the value it displayed, and the formulas, macros, filters and cell formatting that produced it are not in the file at all.
What makes a table convert well
Whether a converter splits the columns or you do it with Text to Columns, the same features decide how cleanly they come apart:
| Feature | Effect on accuracy |
|---|---|
| Ruled lines around every cell | Best case — the boundaries are explicit |
| Consistent column alignment | Good — columns can be inferred from spacing |
| One line of text per cell | Good — row boundaries are unambiguous |
| Wrapped text inside cells | Harder — one row can look like several |
| Merged or spanning cells | Hard — the grid is no longer regular |
| No lines and irregular spacing | Poor — column edges have to be guessed |
| Scanned table without OCR | Impossible — there is no text to read |
Fixing what comes back
- Use Text to Columns when several values have landed in one cell.
- Check for numbers stored as text — they will not sum, and Excel flags them with a green corner.
- Watch for currency symbols and thousands separators pulled into the value.
- Re-join rows that were split because a cell wrapped onto a second line.
- Check dates, which are the most commonly mangled field of all.
Verify before you share the workbook
- 1Re-add a total row and compare it with the printed total on the PDF page.
- 2Spot-check five values spread across different pages against the source.
- 3Audit one date column and one currency column for format drift.
If the source data still exists, ask for it
A PDF is a printout. Someone generated it from a spreadsheet, a database or a report tool, and that source is authoritative in a way that any extraction is not. For a one-off table, converting is quicker than asking. For anything recurring or financially material, asking for a CSV is worth the email.
Scanned tables
A scanned table is a picture, so converting it directly gives you page sheets marked "(empty page)". Run OCR first, then convert. Recognition will be imperfect on faint scans, and columns of digits are exactly where an OCR error is hardest to spot — a 6 read as an 8 looks entirely plausible. Verify totals against the original page.
Do it now
PDF to Excel
Export PDF text to a spreadsheet, one line per row (XLSX). It runs in this browser tab — your file is not uploaded anywhere.
Open PDF to ExcelFrequently asked questions
Why is each row in one cell?+
This converter puts each line of the page in its own row and leaves the column split to you. Use Text to Columns, splitting on spaces or at fixed widths, then check the boundaries.
Can I convert a scanned table?+
Only after OCR, and you should check the figures carefully — digit recognition errors are easy to miss.
Why are my numbers stored as text?+
Extra characters came across with them — a currency symbol, a space, a non-breaking space. Clean the column and Excel will treat the values as numbers.
What about tables that span several pages?+
Each PDF page becomes its own sheet, so a long table is spread across several, and repeated headers appear again on each. Combine the sheets and delete the duplicate header rows.
Will formulas and macros survive the conversion?+
No. A PDF stores the values a workbook displayed, not the formulas behind them, so recreate the totals you need after converting.
Is my data uploaded anywhere?+
No. The conversion runs entirely in your browser and the PDF never leaves your device, so financial and personal tables stay private.