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 ExcelWhy 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?
- Upload — Drag your bank statement into StatementBridge or select the file
- Review — Check the recognised transactions, balances and account information
- 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.
Related conversions
MT940 Converter
Convert MT940 files to CAMT.053, CSV, Excel and more.
CAMT.053 Import
Convert CAMT.053 XML files for your accounting software.
PDF to MT940
Convert PDF bank statements to MT940 with AI extraction.
Credit Card Statement Converter
Convert Amex, Visa and Mastercard statements for your accounting.