DataMimiDataMimi

Convert a bank statement PDF to Excel

One row per transaction, amounts as numbers, every page in one sheet.

Want it to work exactly your way?

Keep this tool in your Mini-Apps to run it again in one click, or describe the job and AI builds an app of your own.

✦ Make your own app

How to use Convert a bank statement PDF to Excel

  1. 1Select your file, or drop it on the page
  2. 2Run it — nothing to set up
  3. 3Download statement.xlsx

Your file is opened in an isolated sandbox with no internet access, processed and deleted with it. It is read the way people's spreadsheets really are — headers that are not on row 1, merged cells, totals pasted at the bottom, dates in two formats — and everything that is changed is listed back to you.

Questions

How do I convert a bank statement PDF to Excel?

Upload the PDF you downloaded from your bank. Each transaction becomes one row with its date, description and amounts in their own columns, across every page, and you download it as an .xlsx file.

Does it work with statements that have no table lines?

Yes. Most statements line their columns up with spaces rather than ruling lines. The reader follows the headings — Date, Description, Withdrawals, Deposits, Balance — and places each amount under the heading it lines up with.

What about descriptions that run onto a second line?

A line that does not start with a date is treated as the rest of the transaction above it, so a long description stays in one cell.

Can it read a scanned statement?

Not a scan: a photographed or scanned page has no text to read. Download the statement as a PDF from your bank's website instead.

Are the amounts numbers I can add up?

Yes. Thousands separators and currency signs are removed and the amounts are written as numbers, so SUM and pivot tables work straight away.

More Excel tools

See all