MT940 to Excel converter
An MT940 is a text file full of SWIFT codes — not something you want to read through. Upload it and download an XLSX with date, amount, counterparty, description and balance in proper columns.
Upload your MT940 file →2 free conversions · no credit card required
MT940 to Excel in 3 steps
-
Upload your MT940.
Drop the file into StatementBridge. The
.sta,.940,.mt940and.txtextensions are all recognised, whichever bank produced the file. -
Review the transactions.
The
:61:lines and:86:descriptions are parsed and joined into readable rows. Opening and closing balances are shown, so you can see at a glance whether the statement is complete. - Download the Excel file. Pick XLSX as the output format. You get one row per transaction with separate columns — ready to filter, sort or drop into a pivot table.
What accountants use this for
Checking before import
See which transactions a file contains, and whether the period is right, without loading it into your accounting package first.
Reconciliation
Put bank movements next to a ledger or receivables report. In Excel that is a single VLOOKUP.
Sharing a subset
A client or colleague asks for one period or one counterparty. Filter in Excel and send only that.
Readable archiving
MT940 is an interchange format, not an archive format. An XLSX will still open in ten years.
Which columns do you get?
Booking date, value date, signed amount, currency, counterparty account, counterparty name, description and sequence number. Opening and closing balances are listed separately so the reconciliation stays verifiable. If you would rather have a flat file than a spreadsheet, choose CSV in the same step.
Frequently asked questions
Can I open an MT940 file in Excel directly?
Not usefully. Excel will show the raw SWIFT lines — :61: for each movement and :86: for its description — as one long column of codes. The data has to be parsed first before it becomes rows and columns, which is what this conversion does.
Which columns does the Excel file contain?
Booking date, value date, signed amount, currency, counterparty account, counterparty name, description and sequence number. Opening and closing balances are listed separately so you can verify the statement adds up.
Are multi-line :86: descriptions joined correctly?
Yes. MT940 wraps descriptions at 65 characters across several :86: lines. Those are reassembled into a single description per transaction, so nothing is truncated in the spreadsheet.
Can I get CSV instead of XLSX?
Yes — pick CSV in the same step. Use CSV when another system has to read the file, and XLSX when a person does.
Does the original MT940 stay unchanged?
Yes. The conversion only reads your file; it never rewrites it. Generated files are removed from our servers automatically after 24 hours.
Related topics
MT940 to CAMT.053
Needed when your package no longer accepts the SWIFT format.
MT940 converter
Every output format in one place: CAMT.053, CSV, Excel, OFX and CODA.
Bank statement to Excel
Same result, starting from a PDF, CSV or CAMT.053 instead.
OFX to MT940
The other direction: turn an OFX export into SWIFT MT940.