Bite Apps › SafeCAMT › MT940 to Excel

MT940 to Excel — convert bank statements without uploading them

Open an MT940 statement, see every transaction with counterparty, IBAN, references and purpose in its own column, check that the balances add up, and download it for Excel — all in your browser.

SafeCAMT reads MT940, MT942, camt.053 and BAI2 statements — free to use, nothing is uploaded.

Open SafeCAMT — free, in your browser

English · Deutsch · Nederlands

Open SafeCAMT with an example file Open SafeCAMT and drop your own file

How to convert an MT940 file to Excel

Download the MT940 statement from your online banking — the file usually ends in .sta, .mt940, .940 or .txt.
Open SafeCAMT and drop the file on the page (or several files at once). It detects MT940 and MT942 automatically, including files with several statements and accounts.
Check the Balances & reconciliation tab: SafeCAMT adds up every :61: line and compares the result with the opening (:60F:) and closing balance (:62F:), so you know nothing is missing before you work with the data.
Set the CSV option to “semicolon + 1,23 (EU)” for European Excel (or “comma” for US/UK), download the transactions as CSV and open the file in Excel.

Free: every transaction on screen, the balance check, and a CSV download of the first 100 rows. Pro ($19 one-time, no subscription): all rows and Excel (.xlsx) with Transactions, Balances and Checks sheets.

Three rows from the built-in example statement, as SafeCAMT shows and exports them:

Booking date	Amount	Counterparty	Counterparty IBAN	Remittance information	Bank transaction code
2026-11-02	9,800.00	Nordwind Logistics BV	NL91ABNA0417164300	RF18539007547034	PMNT-RCDT-ESCT
2026-11-02	2,850.00	Atelier Lumiere SARL	FR1420041010050500013M02606	Facture 2026-1187 / commande 5541	PMNT-RCDT-ESCT
2026-11-02	-20.40			Account maintenance fee October	ACMT-MDOP-CHRG

Booking date

Amount

Counterparty

Counterparty IBAN

Remittance information

Bank transaction code

2026-11-02

9,800.00

Nordwind Logistics BV

NL91ABNA0417164300

RF18539007547034

PMNT-RCDT-ESCT

2026-11-02

2,850.00

Atelier Lumiere SARL

FR1420041010050500013M02606

Facture 2026-1187 / commande 5541

PMNT-RCDT-ESCT

2026-11-02

-20.40

Account maintenance fee October

ACMT-MDOP-CHRG

Columns in the export

Column What it contains

Booking date / Value date when the bank booked the entry and when it is valued

Amount, Currency, Credit/Debit signed amount (debits negative) plus currency and C/D

Status booked, pending or information only

Counterparty, Counterparty IBAN/account, Counterparty BIC the other party of the payment

Remittance information, Structured reference free-text purpose and RF creditor reference

End-to-end ID, Bank reference, Entry/customer reference the references you reconcile against

Bank transaction code ISO domain-family-sub-family, e.g. PMNT-RCDT-ESCT (or the MT940 GVC / BAI2 type code)

Return reason, Additional information reason code of returned payments, extra bank text

File, Account, Statement where the row comes from when several files or accounts are open

Column	What it contains
`Booking date / Value date`	when the bank booked the entry and when it is valued
`Amount, Currency, Credit/Debit`	signed amount (debits negative) plus currency and C/D
`Status`	booked, pending or information only
`Counterparty, Counterparty IBAN/account, Counterparty BIC`	the other party of the payment
`Remittance information, Structured reference`	free-text purpose and RF creditor reference
`End-to-end ID, Bank reference, Entry/customer reference`	the references you reconcile against
`Bank transaction code`	ISO domain-family-sub-family, e.g. PMNT-RCDT-ESCT (or the MT940 GVC / BAI2 type code)
`Return reason, Additional information`	reason code of returned payments, extra bank text
`File, Account, Statement`	where the row comes from when several files or accounts are open

What happens to the :86: field

The :86: information line is where banks put the counterparty and the purpose — and every bank formats it differently. SafeCAMT reads the German structured format with ?20–?63 subfields (GVC, name, IBAN, BIC, SEPA references such as EREF+ and MREF+) and the slash-coded format (/EREF/, /REMI/, /BENM/ …), and splits them into the columns above. Anything else stays in the remittance text. The full field list is on the MT940 format reference.

Why not an online converter?

Most “MT940 to Excel” websites upload your bank statement to their server. SafeCAMT is a single web page that does everything in your browser: the file is never sent anywhere, there is no account to create, and you can even download it and use it offline. Need the statement as camt.053 instead? SafeCAMT also converts MT940 to camt.053.

FAQ

How do I open an MT940 file in Excel?

Excel cannot read MT940 directly. Open the file in SafeCAMT, check that the balances reconcile, and download the transactions as CSV; Excel opens the CSV with one column per field.

Is the MT940 file uploaded?

No. SafeCAMT runs entirely in your browser; the file never leaves your computer.

Does it work with German MT940 files (?20–?63 subfields)?

Yes. The German structured :86: format is split into GVC, counterparty name, IBAN, BIC, end-to-end reference, mandate reference and purpose.

Is it free?

Viewing, the balance check and a CSV of the first 100 transactions are free. Pro ($19 one-time) exports all rows and Excel .xlsx files.

Last updated 2026-11-14. Something wrong or missing? Email support@biteapps.cc.