ScoutMyTool

PDF to Excel

Get the tables out of a PDF and into Excel: bank and credit-card statements, invoices, bills and reports. Each table becomes its own sheet, rows stay together even when a description runs over several lines, and amounts become real numbers.

By the ScoutMyTool team · Last reviewed 15 November 2026 · How we build our tools

How do I convert a bank statement PDF to Excel?

Choose the PDF and select Convert to Excel. Each table in the statement becomes a sheet; a transaction whose description wraps onto two or three lines stays on one row, and debits, credits and balances become numbers, so totals and formulas work straight away. Check the result against the PDF before relying on it.

or drag and drop it here

Processed on our server over an encrypted connection, then deleted as soon as the result is sent back.

Only used when the PDF is a scan and the text has to be recognised first.

How to use PDF to Excel

  1. Choose or drop your PDF.
  2. For a scanned PDF, pick the language of the text.
  3. Select Convert to Excel and open the .xlsx file.

Built for statements and invoices

Most PDF converters do well on tables with grid lines and badly on bank statements, where there are no lines and a description often wraps onto a second or third line — the amounts end up on the wrong rows and the descriptions are split apart. This converter finds the columns from the way the text lines up and keeps each transaction together, including when the date is printed only once per day or sits in the middle of a tall row.

Page headers and footers that repeat on every page are left out, a table that continues onto the next page stays one table, and the column headings are kept once at the top.

What you get in Excel

Amounts become real numbers with the same decimals as the PDF — including minus signs, amounts in brackets and thousands separators — so SUM and other formulas work. Dates, account numbers and codes are kept exactly as printed, so nothing is silently changed (a date like 03/10 means different things in different countries).

Each table goes on its own sheet, with the heading row in bold and frozen so it stays visible as you scroll.

Good to know

It works best on PDFs made by a computer (downloaded statements and invoices). Scanned paper is read with text recognition first, so check names and numbers carefully. If a document prints a side panel of text right next to a table, that text can appear as an extra column — simply delete it. A quick way to check a statement: the running balance in Excel should follow on from row to row.

Frequently asked questions

Is my statement kept or shared?

No. The file is converted on our server in a temporary folder and deleted as soon as the Excel file is sent back. It is never stored, read by a person or shared.

Does it work with password-protected statements?

Remove the password first with Unlock PDF (you’ll need the password), then convert the unlocked copy.

Why is a date shown as text?

So it stays exactly as printed. Excel can guess dates wrongly (03/10 can be 3 October or 10 March). To convert, select the column and use Data → Text to Columns, choosing the date order your bank uses.

What if my PDF has no table?

You’ll get a message instead of an empty spreadsheet. For ordinary text, use PDF to Word or PDF to Text.

Can it convert a scanned statement?

Yes — the text is recognised first. Results depend on the scan quality, so check the figures against the paper copy.

More tools