Convert bank statements to Excel — ready to use in your spreadsheet

Upload your MT940, CAMT.053, CSV or PDF bank statement and download a ready-to-use Excel spreadsheet with all your transactions. Free to try.

Upload and convert to Excel

Why convert bank statements to Excel?

Excel is the most widely used format for financial analysis. Whether you want to review transactions, create a cash flow overview, or share data with your accountant — an Excel file is universally usable.

  • Analyse and filter transactions in a spreadsheet
  • Share data with your accountant or bookkeeper
  • Perform manual reconciliation
  • Import into software that accepts Excel files

Supported input formats

MT940 to Excel

Convert SWIFT MT940 files (.sta, .940, .mt940) to a clear Excel spreadsheet.

CAMT.053 to Excel

Convert ISO 20022 XML files to Excel with all transaction details.

CSV to Excel

Restructure CSV bank statements into a standardised Excel format with correct column layout.

PDF to Excel

Extract transactions from PDF bank statements with AI and export to Excel (Pro).

How does it work?

  1. Upload — Drag your bank statement into StatementBridge or select the file
  2. Review — Check the recognised transactions, balances and account information
  3. Download — Choose Excel as the output format and download your spreadsheet

What does the Excel file contain?

The exported Excel file contains all available transaction data from your source file: transaction date, amount, description, counterparty account (IBAN), counterparty name, currency and other available fields.

One row per transaction, one column per field — no merged cells, no interleaved subheadings. That is deliberate: the moment you want a pivot table or a VLOOKUP, a clean table is the only thing that works. Opening and closing balances are listed separately so the reconciliation stays verifiable.

What you do with it next

The conversion is rarely the goal. These are the four things accountants and bookkeeping firms actually put a bank statement in Excel for:

Reconciliation

Put bank movements next to open items. Sort by amount, match on reference, and what is left over is exactly what needs attention.

Preparing a VAT return

Filter by period and counterparty to check that receipts and payments fall in the right return period.

Handing over a period

A client or accountant asks for one quarter or one counterparty. Filtering and forwarding beats exporting again at the bank.

Checking before import

Confirm the period is right and there are no duplicate movements before loading the file into your accounting package.

Per source format

Each source format has its own quirk. If you specifically have an MT940 file you want to open in Excel, that page describes in more detail how the :61: and :86: lines are parsed.

  • MT940 — descriptions are split across several :86: lines of 65 characters; these are reassembled into one readable description per transaction.
  • CAMT.053 — carries more structured fields than MT940, so this produces the richest spreadsheet: separated counterparty name, references and transaction codes.
  • CSV — bank exports differ widely. If there is a block of account and period metadata above the column headers, it is detected and skipped.
  • PDF — works for PDFs with a text layer. If your statement is a scan, AI extraction is needed; see PDF bank statement import with AI.

Frequently asked questions

Which file formats can I convert to Excel?

You can convert MT940, CAMT.053 (XML), CSV, OFX, CODA and PDF bank statements to Excel. StatementBridge automatically detects the format.

Does the Excel file contain all transaction data?

Yes. The exported Excel file contains date, amount, description, counterparty account (IBAN), counterparty name and all other available fields from your source file.

Is the Excel export free?

Yes. The free plan includes 2 trial conversions with unlimited transactions per file. For regular use, pick Starter (€9/month, 10 conversions) or Pro (€25/month, 50 conversions).

Can I import the Excel file directly into my accounting software?

Some accounting packages accept Excel imports. If your software specifically requires MT940 or CAMT.053, you should choose that format as export option in StatementBridge.