Convert MT940 to Excel
Turn an MT940 statement into a proper .xlsx workbook — dates as real date cells, amounts as real numbers, in the same consistent layout every time regardless of bank. Free and no signup.
Your file is processed in temporary storage and permanently deleted within 10 minutes. We never read, store, or share the transaction data in your file.
Drop your bank statement here
or click to choose a file — MT940 or CAMT.053, up to 10MB
Free tier includes the generic layout — Pro adds QuickBooks, Xero and more.
Don't have a statement file handy? Try it now with sample data:
Sample data is entirely synthetic — fabricated names, amounts and test IBANs. Nothing is uploaded from your device.
See it working — no upload needed
The same synthetic statement, raw on the left and converted on the right.
Raw MT940 file
:20:MT2C-2026-001 :25:NL02RABO0123456789 :28C:1/1 :60F:C260104EUR12500,00 :61:2601050105C2500,00NTRFMT2C-2026-0001 :86:Salary January 2026 EXAMPLE EMPLOYER BV :61:2601060106D58,40NTRFMT2C-2026-0002 :86:Invoice 2026-0042 office supplies :61:2601070107D214,90NTRFMT2C-2026-0003 :86:Invoice 2026-0043 equipment :61:2601080108D120,00NTRFMT2C-2026-0004 :86:105?00SEPA OVERBOEKING?20Transfer to supplier — invoice 2026-0044?31NL85RABO0312345678?32EXAMPLE SUPPLIES BV
Converted result
| Date | Description | Amount |
|---|---|---|
| 2026-01-05 | Salary January 2026 EXAMPLE EMPLOYER BV | +2500.00 |
| 2026-01-06 | Invoice 2026-0042 office supplies | -58.40 |
| 2026-01-07 | Invoice 2026-0043 equipment | -214.90 |
| 2026-01-08 | SEPA OVERBOEKING Transfer to supplier — invoice 2026-0044 | -120.00 |
| 2026-01-09 | SEPA OVERBOEKING Invoice 2026-0038 paid | +890.50 |
| 2026-01-10 | Direct debit premium January | -75.25 |
A spreadsheet your accountant will actually trust
Business banking delivers MT940 through EBICS, host-to-host and SWIFT feeds — not through a uniform CSV. And when banks do offer CSV, columns and date/decimal formats differ between them. MT2CAMT normalises any MT940 into one consistent workbook: dates are date cells, amounts are numeric cells with a currency format, and the header row is frozen so a long statement stays readable.
MT940 text can be a mess of bank-specific :86: narratives. Where the bank uses structured subfields, MT2CAMT pulls out the counterparty name and IBAN for you; where it does not, the full original text is kept — nothing is silently dropped.
Your file is processed in temporary storage and permanently deleted within 10 minutes. We never read, store, or share the transaction data in your file.
MT940 to Excel — common questions
Why not just rename the CSV to .xlsx?
You can — but you get a text dump, not a spreadsheet. Dates stay text, amounts need re-formatting, and accented names can garble. MT2CAMT writes real cells so the file is usable the moment it opens.
Will the Excel file work on a Mac and in Windows?
Yes. The file is a standard .xlsx opened by Excel, LibreOffice, Google Sheets and most accounting packages.
Is Excel the same as CSV with extra steps?
For import into accounting software, Excel is a separate export target with its own value. Both are supported here — convert to whichever your workflow needs.