MT940 to Excel Converter
Convert a SWIFT MT940 statement into Excel or CSV. Free, no signup, no size limit.
.sta, .mt940, .txt
SWIFT tags this tool reads
:20:— Transaction reference:25:— Account identification:28C:— Statement and sequence number:60F:/:60M:— Opening balance (final / intermediate):61:— Statement line: value date, entry date, debit/credit mark, amount, reference:86:— Information to account owner, joined across continuation lines:62F:/:62M:— Closing balance
The two things that break MT940 imports
First, decimal commas. MT940 is a European format, so an amount is written
1200,50 — and a spreadsheet set to US locale reads that as one thousand two hundred fifty.
This converter normalises the comma to a decimal point before writing the output.
Second, descriptions span lines. The :86: field frequently wraps onto
unlabelled continuation lines. Parsers that read line-by-line drop everything after the first line, or
worse, emit the fragments as separate transactions. Here they are appended to the statement line they
belong to.
Debit and credit come from the mark in :61: — C for credit,
D for debit, plus the reversal variants RC and RD. Debits are
written as negative so the Amount column sums to the real net movement.
Example
:61:2507150715D1200,50NDDTREF67890//BANKREF002 :86:DIRECT DEBIT INSURANCE CONTINUATION LINE FOR INSURANCE
becomes one row: date 2025-07-15, direction DEBIT, amount -1200.50, and the full description including the continuation line.
Frequently asked questions
Is my file uploaded?
No. Everything runs in your browser — there is no server component. You can verify with your browser's network tab, or save the page and use it offline.
Is MT940 still used?
Yes, though it is being replaced by CAMT.053 under ISO 20022. Many banks still deliver MT940 alongside the newer XML format, and plenty of ERP and accounting systems continue to import it.
What about MT942?
MT942 (interim transaction report) uses the same :61: and :86:
structure, so it generally parses correctly here as well.