How to convert a PDF into an editable Excel spreadsheet
Converting a PDF to Excel pulls the tables locked inside a fixed document back into live, editable cells you can sort, total and chart. Financial statements, invoices, price lists, bank exports and reports are routinely shared as PDFs, and retyping their figures by hand is slow and error-prone. This tool detects the tabular structure on each page and rebuilds it as a proper .xlsx worksheet.
It works best on PDFs that contain real text; a scanned, image-only table should be run through OCR first so the numbers can be read. Each detected table becomes its own worksheet, and numeric-looking cells are written as real numbers rather than text so your formulas work straight away.
A realistic expectation: a clean, ruled table converts essentially 1:1; a borderless bank statement converts well with the occasional column to nudge; a decorative annual-report spread may need a few minutes of tidying. In every case you are correcting a rebuilt grid rather than retyping hundreds of figures — and it is manual retyping that produces the transposed digits nobody notices until they matter.
Step by step
- Open the PDF to Excel tool and upload your document.
- Press Process to begin the extraction.
- Wait while the tables are detected and rebuilt into worksheets.
- Download the resulting .xlsx file.
- Open it in your spreadsheet application and continue working with the data.
Limits and formats at a glance
| Input | Text-based PDFs up to 20 MB free (1 GB with PRO) |
|---|---|
| Output | A standard .xlsx workbook, one worksheet per detected table |
| Detection | Ruled tables extract best; borderless grids recovered from column alignment |
| Numbers | Numeric cells written as real numbers, EU and US decimal styles |
| Scanned PDFs | Run OCR first so the figures are readable text |
| Cost | Free, no account required |
Why use this tool
Getting numbers out of a PDF is one of the most tedious jobs in any office. Copying a table by hand invites transcription mistakes in exactly the figures that matter most, and a simple copy-and-paste from a PDF viewer usually collapses every column into a single messy line. Rebuilding the grid automatically keeps rows and columns aligned so the data lands where it belongs.
Once the figures are back in cells you can do what a spreadsheet is for — sum a column, filter a supplier list, build a pivot table, or drop the numbers into an existing model — without re-keying a thing.
It is the fastest route for the everyday “the data I need is trapped in a PDF” problem: reconciling a bank statement, importing an invoice into your accounts, updating a catalogue from a supplier’s price sheet, or pulling last quarter’s figures into a new report. Tables with visible ruling lines extract most cleanly; borderless, whitespace-aligned layouts are recovered by detecting the column positions, and a plain-text fallback ensures you always get a usable file rather than an empty one.
Two habits make the results better still: convert only the pages that carry the tables — extracting them first with Split PDF keeps the workbook small and focused — and sanity-check totals against the original once the data is in Excel: a column sum that matches the printed total confirms the whole extraction at a glance. For scans, quality in equals quality out, so straighten pages with Rotate PDF and run OCR before converting.
Is it safe? Your privacy
Your PDF is uploaded only to produce the Excel file and is erased from our servers automatically a short time later. The contents are never stored or analysed.
Troubleshooting: common problems and fixes
- Columns are merged or shifted in the output. — This happens with borderless tables whose spacing is irregular. Convert just the relevant pages (extract them with Split PDF), or tidy the few affected columns in Excel — still far faster than retyping.
- Numbers arrive as text and formulas ignore them. — Currency symbols or footnote markers can force a cell to text. Strip the symbols with Excel’s Find & Replace, then convert the column with Text to Columns or VALUE().
- The workbook is empty. — The PDF is probably an image-only scan. Run OCR PDF first, then convert the searchable copy.
- I only need one table out of a fifty-page report. — Extract that page first with Split PDF; a one-page conversion is faster and returns exactly one worksheet.
Frequently asked questions
Which file format do I get back?
A standard .xlsx workbook that opens in Microsoft Excel 2007 and later, as well as Google Sheets, LibreOffice Calc and Apple Numbers.
Can I convert a scanned PDF?
Run it through our OCR tool first so the table contains real, selectable text, then convert it to Excel — an image-only scan has no numbers to read.
Will every table be detected?
Tables drawn with visible lines extract most reliably. Borderless tables that rely on spacing are recovered by detecting where the columns line up, which works well for typical exports; very irregular layouts may need light tidying afterwards.
Are numbers kept as numbers?
Yes. Cells that look numeric are written as real numbers — including European and US decimal styles — so you can total and calculate immediately without cleaning the data first.
What happens to a PDF with several tables?
Each detected table is placed on its own worksheet, named by page, so a multi-page report comes back neatly separated instead of merged into one sheet.
What if my PDF has no real table?
Rather than return an empty file, the tool falls back to laying the page text out row by row, so you always receive a workbook you can work from.
Can I convert a statement of many pages at once?
Yes. Every page is scanned for tables and each one lands on its own worksheet, named by page, so a twelve-page statement arrives ready to work through sheet by sheet.
Will formulas from the original spreadsheet come back?
No — a PDF stores only the printed values, not the formulas behind them. You get the numbers; recreate any calculations in Excel afterwards.