Convert MT940 to CSV or Excel

How to convert an MT940 file to CSV

1. Download the MT940 from your bank. In business online banking, look for MT940 or SWIFT among the statement or transaction download formats. The file is usually called something like .sta, .940, .mt940 or .txt. Accounting and treasury systems (SAP, for example) store the same format.
2. Upload it above. Each :61: booking becomes one row, with the :86: line under it as the description. You don't need to rename the file.
3. Check the preview. It shows whether every statement ties (opening balance + bookings = closing balance), how many bookings came in, and money in and out. Money out is negative.
4. Download the Clean CSV. It opens in Excel, Numbers or Google Sheets. In Excel, use File → Save As → Excel Workbook (.xlsx) to keep it as a workbook.

From MT940 lines to spreadsheet columns

The first booking in our sample MT940 (a made-up Dutch business account):

:61:261001D1850,00NTRFNONREF//EX26100100001
:86:/TRTP/SEPA OVERBOEKING/IBAN/NL00EXMP0000000011/BIC/EXMPNL2A/NAME/
Voorbeeld Vastgoed BV/REMI/Huur kantoor oktober 2026/EREF/NOTPROV
IDED

is this row in the CSV:

Date,Description,Amount,Balance
2026-10-01,Voorbeeld Vastgoed BV - Huur kantoor oktober 2026,-1850.00,6562.65

Every MT940 field, including the ones that don't end up in the CSV, is explained with this sample on MT940 format explained.

The balance check

An MT940 carries its own proof: every statement starts with an opening balance and ends with a closing balance. We add up the bookings in between and compare. For the sample file:

When a statement doesn't tie, the preview says how many do, the Balance column stays blank, and you know to download the period again before importing. A file with only part of the bookings, or a statement cut off without its :62F: line, shows up here instead of in your reconciliation.

Opening the CSV in a European Excel

The CSV uses commas between columns and a point for decimals (-1850.00), the way Google Sheets, Numbers, Xero and most importers want it. Excel set to Dutch, German or French regional settings expects semicolons and decimal commas, so a double-click can put everything in one column or turn amounts into text. Instead:

1. Open a blank workbook and choose Data → From Text/CSV.
2. Pick the CSV and set Delimiter to Comma. Choose Transform Data, then set the Amount and Balance columns with Change Type → Using Locale → Decimal Number, English (United States).
3. Load it, then save as .xlsx.

Which MT940 files work

• Plain MT940 files that start with :20:, files with a SWIFT envelope ({1:…}{2:…}{4:) and files with a bank's header lines above the first statement.
• Many statements in one file (a month of daily statements, for example): statements for the same account and currency are joined in order.
• Several accounts in one file: one tab, one CSV per account and a combined CSV with an Account column.
• Not read: MT942 intraday reports. A camt.053 (ISO 20022 XML) file belongs on the CAMT.053 to CSV converter. Free up to 100 bookings per file; files up to 20,000 bookings.

Common problems

Other conversions

• Have a BAI2 file from a US bank? The BAI2 to CSV converter reads previous-day cash-management files (03/16/88 records), puts the decimal point back on amounts in cents and checks each day against the opening and closing ledger.
• Going into Xero, QuickBooks or another app? The same preview downloads Xero CSV, OFX, QuickBooks .QBO and .IIF, and Quicken .QIF. The OFX and .QBO keep the file's currency (EUR, GBP…) and its closing balance. See CSV to Xero and CSV to OFX for import steps.
• Have a camt.053 XML statement instead? Many European banks now offer ISO 20022 next to MT940. The CAMT.053 to CSV converter reads those files the same way, with the same kind of balance check.
• Have an .ofx, .qfx or .qbo download instead? Use OFX / QFX to CSV or .QBO to CSV. A Quicken .qif? QIF to CSV.
• Only have PDF statements? The bank statement PDF to CSV converter runs the same kind of check against each statement's balances.
• Reconciling the CSV against your books? Try the bank reconciliation tool or the free balance checker.