How to Convert a PDF Table to Excel (Bank Statements, Invoices, Reports)

The numbers you need are often locked in a PDF: a bank statement, an invoice, a supplier price list, an annual report. Copying and pasting usually gives you one long column of jumbled text, and retyping it means mistakes.

A PDF to Excel converter reads where each piece of text sits on the page and rebuilds the rows and columns in a spreadsheet.

Step by step

1. Open the tool. Go to pdfmerger.io/pdf-to-excel.
2. Add your PDF.
3. Choose the layout: one sheet per page, or all pages one after another on a single sheet.
4. Leave "Turn numbers into Excel numbers" on so amounts can be used in formulas.
5. Click "Convert to Excel". Your .xlsx file downloads.

Real numbers, not text

This is what makes the spreadsheet useful. Amounts like 1,250, $12,500.00, 4.5% or (2.0%) become numbers with a matching format, so SUM, sorting and charts work immediately. Codes with leading zeros, such as account numbers and ZIP codes, stay exactly as written.

Want everything exactly as it appears in the PDF? Turn the option off and every cell is kept as text.

Bank statements

Statements usually run over several pages with the same columns. Choose All pages on one sheet to get every transaction in one continuous list, ready to filter by payee or total by month.

Scanned PDFs

A scan is a picture of text, so there is nothing for the converter to read and it will tell you so. Run the file through PDF OCR first to recognize the text, then convert the result.

Frequently asked questions

Does it work with Google Sheets and Numbers?

Yes. The .xlsx file opens in Microsoft Excel, Google Sheets, Apple Numbers and LibreOffice.

What if the columns come out shifted?

Tables without clear spacing between columns can be harder to rebuild. Check the result, and use Excel's own tools to merge or split the odd column.

I need Word, not Excel.

For running text rather than tables, use PDF to Word.