How to Convert PDF to Excel (Numbers In, Numbers Out)
The short answer
Yes — Excel can open a PDF directly (File → Open), and online converters do the same in your browser. The results vary wildly depending on the PDF: clean tables convert beautifully, complex reports come out scrambled. Set your expectations to “good enough”, not “perfect”.
Convert PDF to Excel with Excel itself
- Open Microsoft Excel, choose File → Open, and select the PDF.
- Excel will warn you it’s converting — that’s normal. It then splits the content into tables and columns.
- Review the result and fix what shifted, then save as .xlsx.
This is the fastest route if you have Excel, and it handles simple, well-structured tables really well.
Convert PDF to Excel online
No Excel? A browser-based converter (check the PDF tools page) uploads the file and returns a spreadsheet. Handy on any device, and some tools let you pick which pages to convert — useful when only one table out of thirty matters.
What breaks in the conversion (the honest part)
Here’s what nobody tells you before you convert:
- Scanned PDFs can’t convert. If the PDF is a photo of a table, there’s no data inside — you need OCR first, and even then expect errors.
- Merged cells and multi-row headers usually come out flattened or duplicated.
- Numbers stop being numbers. Dates, currency, and percentages often land as text, so formulas won’t work until you reformat them.
- Formulas don’t exist in PDFs. A PDF is a snapshot — the underlying spreadsheet logic is long gone. You get the numbers, not the math.
If the PDF was made from a spreadsheet, your real best move is asking the sender for the original .xlsx. Converting a PDF to Excel is for when that’s not possible, and it’s always a reconstruction, not a translation.