How to Convert PDF to Excel (XLSX)

A PDF invoice, a bank statement, a report full of tables - useful to read, useless to actually work with, since you can't sum a column or filter a row in a PDF. Converting to Excel turns static numbers back into data you can sort, calculate, and chart.

What makes a PDF convert to Excel cleanly

The conversion quality depends almost entirely on how the PDF was created. A PDF exported directly from a spreadsheet or accounting system has real, structured table data underneath, and converts back to Excel with rows and columns intact. A PDF that started life as a scanned printout of a table is just a picture of numbers - there's no structure to recover, only pixels.

How to convert a PDF to Excel

1. Upload the PDF containing the table or data you want in spreadsheet form.
2. Select XLSX as the output format.
3. Run the conversion and download the resulting spreadsheet.
4. Open it and spot-check a few rows against the original PDF, especially numbers near merged cells or column breaks.

Common table layouts and how they hold up

• Simple single-table reports (one header row, consistent columns) - convert almost perfectly
• Multi-page tables that repeat headers on every page - convert well, though you may want to delete the repeated header rows afterward
• Financial statements with nested subtotals and merged cells - convert with the right numbers in the right general area, but may need manual realignment of a few cells
• Multiple unrelated tables on one page (side by side) - riskiest case; check carefully, since columns can occasionally interleave

If your PDF is a scanned table

A scanned or photographed page has no underlying text or structure - a converter can only work with what's actually encoded in the file, and an image of a table isn't table data, it's a picture. In that case, the practical options are re-requesting the original spreadsheet from whoever created it, or manually re-typing the data - there's no reliable shortcut around a genuinely image-only source.

After converting: quick checks worth doing

Before you build formulas on top of a converted spreadsheet, do a fast sanity pass: confirm the total row count matches what you'd expect, spot-check a handful of cells against the source PDF, and watch for numbers that landed in the wrong column near a merged-cell boundary. A minute of checking here saves you from building calculations on top of a subtly misaligned column.

Common mistakes converting PDF to Excel

• Assuming every table in the PDF converted correctly without spot-checking a few rows against the original.
• Not checking that numbers converted as actual numbers rather than text - a column of numbers stored as text won't sum correctly in a formula until reformatted.
• Losing track of which sheet is which when a multi-table PDF converts into several separate spreadsheet tabs.
• Expecting formulas from the original source data (if there ever were any) to survive conversion - PDF tables only contain the displayed values, not any underlying formulas that produced them.

Converting financial statements and invoices specifically

Bank statements and invoices are some of the most common PDF-to-Excel conversions, and also some of the trickiest, since they often mix a real table with surrounding text, logos, and multiple smaller tables on one page (like a summary box next to a transaction list). For these, it's worth converting one page at a time rather than a whole multi-page statement at once, since it's much easier to verify a single page's numbers against the original than to comb through dozens of rows spread across a large combined spreadsheet.

When a spreadsheet tool is a better starting point than conversion

If the original data is available somewhere other than the PDF - an export from the accounting software that generated the invoice, for instance - it's worth checking there first, since a native spreadsheet export will always be more reliable than reconstructing the same data from a PDF's visual table layout. Conversion is the right tool specifically when the PDF is the only source you have access to.

For recurring conversions of the same type of document - monthly bank statements, weekly reports in the same template - it's worth doing one careful, thorough check the first time to understand exactly how that specific layout converts, since subsequent conversions of the same template will behave consistently, letting you trust the output more quickly on future rounds.

Finally, once data is in spreadsheet form, it's worth taking a moment to apply proper number formatting (currency symbols, decimal places, date formats) rather than leaving everything as generic converted text - a few seconds of cleanup here makes the spreadsheet immediately usable for calculations and sorting, instead of needing another round of manual fixes before it's actually functional.

Converting a PDF with merged or split cells

Tables with merged cells (a header spanning several columns, for instance) are one of the trickier layouts for PDF-to-Excel conversion, since the underlying spreadsheet format handles merged cells differently than a PDF's visual table rendering. After converting a table like this, it's worth checking whether the merged header converted as a single merged cell in Excel or split into several duplicate cells - if the latter, a quick manual merge in Excel usually resolves it faster than trying to adjust the conversion settings to handle it automatically.