How to Extract Tables from a PDF into Excel

The slowest way to get numbers out of a PDF report is to retype them, and it is also the way most likely to put a silent typo into your spreadsheet. Converting the PDF to Excel extracts the tables into real cells you can sort, filter, total and chart. This guide explains how table extraction works, which PDFs convert cleanly, how to fix the common problems, and a 30-second check that tells you whether you can trust the result.

Where this comes up

• Bank and card statements that only download as PDF but need to go into a budget or reconciliation sheet.
• Invoices and supplier price lists that have to land in an accounting system or comparison sheet.
• Published reports, such as annual reports, government statistics and research tables, that you want to analyse rather than just read.
• Exports from old systems that only print to PDF.

How PDF table extraction works

A PDF has no concept of a table. A table you see on screen is stored as individual pieces of text placed at exact coordinates, plus some lines drawn around them. Extraction rebuilds the grid by reading where every piece of text sits: values that line up vertically form columns, and values on the same baseline form rows. Consecutive rows that share the same column shape are grouped into a table.

That is why the source matters so much. A table exported from Excel, accounting software or a bank's statement system has clean, consistent positions and converts very reliably. A table that only exists as an image, in a scanned or photographed document, has no text positions at all.

How to convert PDF tables to Excel

1. Open the PDF to Excel tool and add your PDF. Every page is read and the tool reports what it found, for example "3 tables detected", rather than making you convert blind.
2. Review the tables. Each one is listed with its page number, row and column count, and whether a header row was recognised. Click one to preview it as a grid, then tick the ones you want.
3. Choose a format: an Excel workbook (XLSX), plain CSV, or TSV (tab-separated) for Google Sheets.
4. For workbooks, choose whether each table gets its own sheet or they are stacked in one sheet, and whether to keep header rows. Then export.

Everything runs in your browser, so the statement or invoice is never uploaded. That matters for documents full of account numbers and transactions.

Choosing a format

• XLSX for Excel, or to upload to Google Drive and open as a sheet.
• TSV to paste straight into Google Sheets. Tab-separated data splits into columns correctly, and it avoids the classic CSV problem of commas inside amounts like 1,24,500.00 breaking columns apart.
• CSV to import into accounting software, databases or scripts that expect it.

Multi-page tables

A statement that runs over 12 pages is usually one long table split by page breaks, with the header repeated on each page. Choose to stack the tables in one sheet, then remove the repeated header rows. In Excel, a filter on the first column makes them easy to find and delete together. Now you have one continuous table to sort and total.

Fixing common problems after converting

• Numbers stored as text (they align left and won't add up): select the column and use Data → Text to Columns → Finish in Excel, or multiply by 1. Watch for currency symbols and thousands separators that need removing first.
• Dates in the wrong order (3 April becoming 4 March): Excel guesses date formats from your system settings. Use Text to Columns and specify the date order (DMY) explicitly.
• Debit and credit in one column with "Dr"/"Cr" suffixes: split them with a formula or Text to Columns before totalling.
• Merged header cells spanning several columns sometimes come through in the first column only. Fix headers by hand; it is quicker than fighting them.
• Multi-line cells, such as long transaction descriptions that wrap onto two lines, can occasionally split into an extra row. Check the row count against the original.

Always verify the totals

After any conversion, spot-check a few rows against the original. Then, if the table has a totals row, recompute it with a quick =SUM(). If a column sums to the printed total, that is strong evidence every value above it came across intact. For a bank statement, check that the opening balance plus credits minus debits equals the closing balance. It takes 30 seconds and catches the rare misread digit before it reaches a report or a tax return.

Scanned PDFs

If you can't select the text in your PDF, it is an image of a table, and there is no text to extract. The table has to be recognised first with OCR (optical character recognition). The PDF to Word tool has OCR built in for twelve languages and recovers the text. Clean, straight scans recognise well; crumpled photos need careful checking, especially for numbers, where a misread 8 or 3 matters. When accuracy is critical, it is often worth asking the source for a digital copy: banks and suppliers can usually provide a CSV or Excel export directly.

What can't be extracted

Formulas. When a spreadsheet is exported to PDF, every formula is calculated and only the result is printed: a cell that held =SUM(B2:B13) becomes the number 12,480. Extraction recovers that number faithfully, but the formula is gone. If you need the live spreadsheet, ask for the original file. Once the values are in Excel, you can of course write new formulas over them.

Frequently asked questions

Can I convert just one table from a long report?

Yes. Every detected table is listed separately, so tick only the ones you want.

Does it work with Google Sheets?

Yes. Choose TSV and paste, or import the XLSX file into Google Drive.

Can I convert a password-protected statement?

Remove the password first with the Unlock PDF tool, using the password you were given. Banks often send statements protected this way.

What about turning a spreadsheet into a PDF?

That is the opposite direction. Use the Excel to PDF tool.