How to convert a PDF to Excel (and get usable numbers)
The numbers you need are sitting in a PDF: a statement, a price list, a report someone exported and then lost the original spreadsheet. Converting a PDF to Excel rebuilds a workbook from the text and its positions on the page — the rows and columns are inferred from how the words line up. Done on the right kind of PDF, the result is genuinely usable. Done on the wrong kind, it is a puzzle. This guide separates the two.
What converts well — and what does not
Born-digital PDFs — exported from Excel, accounting software or a bank — carry real text with exact positions, and their tables usually rebuild cleanly. Scanned PDFs are photographs: there is no text to recover until you run OCR first, and even then, check every figure. Designed documents — brochures, infographics, multi-column layouts — convert messily because their "tables" are visual arrangements, not data. Knowing which kind you hold takes five seconds: try to select a number with your mouse. If it selects, conversion has something to work with.
How the conversion reads a table
The tool groups words into lines by their vertical position, then looks for columns — vertical bands where values align down the page. Regular spacing converts beautifully; irregular layouts (a total that spans two columns, a note inside the grid, numbers with mixed alignment) can land in the wrong cell. Nothing is guessed silently: the values in the workbook are the values in the PDF, but their cell addresses deserve a quick review.
Step by step
1. Open the PDF to Excel tool
Load the file in the PDF to Excel tool. It runs in your browser — financial documents are exactly the kind you do not want on a stranger's server.
2. Convert and download the workbook
Save the .xlsx and open it in Excel, LibreOffice or Google Sheets.
3. Audit before you trust it
Re-add two or three column totals and compare them with the totals printed in the PDF. Check that dates landed as dates, and that negative numbers and decimals survived — a misread decimal separator is the classic silent error.
Aftercare in the spreadsheet
- Formulas do not come back. The PDF stored results, not formulas — the workbook contains values. Rebuild any calculation you need.
- Formats need a pass. Currency symbols and percentages may arrive as text; a few minutes of formatting is normal.
- One table per sheet is the clean case. For a PDF with several reports, converting and then splitting sheets by hand is faster than fighting a merged result. If you only need the words, PDF to Text is simpler; for a document you will edit as prose, use PDF to Word.
A five-minute audit that catches the silent errors
Conversion mistakes rarely shout; they whisper — one figure in the wrong column, one date read as text. Before you use a converted workbook, spend five minutes on this checklist. Totals: re-sum the two or three columns that carry money and compare with the totals printed in the PDF; a mismatch localises the problem rows. Dates: sort the date column — values that refuse to sort are text, not dates, and usually sit in rows where the layout confused the converter. Negatives and decimals: search for brackets and commas; accounting PDFs often write negatives as (1,200) and use commas as thousand separators, and both can arrive in forms Excel treats as words. Percentages: check whether 12% arrived as 12, 0.12, or the text "12%" — each needs different handling downstream. Row count: compare the number of data rows with the pages you converted; a dropped header row repeated across pages is normal and easy to delete, a missing data row is not. Five minutes of this turns a hopeful conversion into a trustworthy one.
Frequently asked questions
Will my formulas be restored?
No. A PDF only stores the displayed results of formulas, so the workbook contains values. Any calculation you need must be rebuilt in Excel.
Can I convert a scanned PDF to Excel?
Not directly — a scan has no text layer. Run OCR first to make it searchable, then convert, and verify the figures carefully against the original.
Are my files uploaded during conversion?
No. The PDF to Excel tool runs 100% in your browser; your document never leaves your device.
Open the free PDF to Excel tool →Runs 100% in your browser — your file is never uploaded.