How to Convert PDF to Excel Without Losing Your Tables

Converting a PDF to Excel sounds like a one-click job. Sometimes it is. Other times you get a spreadsheet with every value crammed into column A, merged cells everywhere, and numbers stored as text. The difference is almost always how the PDF was made.

Here is how to convert PDF to Excel, and how to get a usable table out of the hard cases.

Why some PDFs convert perfectly and others do not

A PDF does not contain a table. It contains instructions for drawing text and lines at coordinates. Whether a converter can rebuild a table depends on the PDF's origin:

• PDF exported from Excel or Word — the underlying structure is usually intact, so columns and rows map cleanly.
• PDF from a reporting tool or invoice system — often structured, but with repeated headers and page breaks that need cleaning.
• A scan or a photo — there is no text layer at all. This needs OCR first, and OCR of a table is genuinely hard.

If your PDF is a scan, expect to clean up the output. No converter magically recovers a perfect spreadsheet from a photo of a page.

Step by step: PDF to Excel

1. Open the PDF to Excel tool.
2. Upload your PDF.
3. Run the conversion and download the XLSX.
4. Open it and check three things immediately: column count, number formatting, and whether the header row repeated on every page.
5. Fix the small issues (below) before you build anything on top of the data.

The five problems you will actually hit

1. Everything lands in one column. The converter could not detect column boundaries. Fix: use Excel's Data → Text to Columns, or re-export the source PDF if you still have the original application.

2. Numbers are stored as text. You see a green triangle in the corner of each cell. Fix: select the column, then Data → Text to Columns → Finish; or multiply by 1 in a helper column.

3. Merged cells from the original layout. Headers that spanned several columns in the PDF come back merged and misaligned. Fix: unmerge, then fill down.

4. Repeated page headers. A 40-page statement gives you 40 copies of the column headers. Fix: filter out the repeated rows, or delete them in a batch after sorting.

5. Dates in the wrong format. 03/04/2026 is ambiguous. Fix: set the column format explicitly, and check whether the source used day-first or month-first.

When to convert to Excel, and when not to

Excel is the right target when you need to sort, filter, sum, or chart the data. It is the wrong target when you only need to read the numbers — in that case, keeping the PDF and using Extract Table to pull the raw table out may be enough.

If the PDF is a form rather than a table — fields with labels, not rows and columns — use Extract Form Data instead. Forms and tables need different extraction logic, and using the wrong one wastes time.

A workflow that avoids rework

If you have a stack of similar PDFs (monthly statements, supplier invoices), build the process once:

1. Convert one file with PDF to Excel.
2. Note exactly which cleanup steps it needed.
3. Apply the same steps to the rest — in Excel, a recorded macro or a Power Query import handles the repetition.
4. Keep the PDFs as the source of truth; the spreadsheet is a derived artefact.

If the PDFs need to be combined before conversion, merge them first so you clean up once instead of per file.

Related guides

• How to Convert PDF to Word — the better target when the content is paragraphs.
• How to Repair a Corrupted PDF — a file that will not open converts to nothing.
• How to Unlock a PDF — remove restrictions before extracting anything.

FAQ

Does conversion keep the formatting? Bold text and cell colours usually survive; complex layouts and merged headers often do not.

Can I convert a scanned PDF to Excel? Only with OCR, and the accuracy depends on scan quality. Straight, high-resolution scans of simple tables work best.

Is the output a real .xlsx file? Yes — an editable workbook, not an image of a table.

What about PDF to Word instead? If the document is mostly prose rather than tables, PDF to Word gives a better result; tables convert poorly to flowing text.

Open the PDF to Excel tool and start with one file — check the output before converting the whole stack.