Skip to content

Convert MT940 to Excel and CSV

Beta This tool is in beta. It is tested on sample files, and details may still change. Review the result before relying on it.

Open an MT940 bank statement and download it as Excel or CSV for free. Klarbon reads the Swift fields, checks the balances and shows a preview.

No file to hand? Try a sample statement

In short

Turn a bank statement file or a PDF statement into Excel, CSV, CAMT.053, MT940 or OFX. Klarbon reads a PDF statement into a draft; check the result before you use it. CSV and Excel free from bank files, otherwise 1 credit (€1.99).

Klarbon opens an MT940 bank statement file and converts it into Excel (XLSX) or CSV, free on the site. It reads the tagged Swift lines one by one, splits the purpose field into counterparty, IBAN and reference where the German or Dutch layout allows, and checks the opening balance plus every statement line against the closing balance. Reading is in beta. A PDF statement dropped here is read too.

Compare the draft with the original before you download it.

How do I convert MT940 to Excel?

  1. Export MT940 in your online banking; some banks call it SWIFT, STA or MT940 structured.
  2. Drop the file above and confirm the century of its two-digit years.
  3. Check each :20: block in the preview: account, period and whether :60F: plus the lines gives :62F:.
  4. Choose Excel or CSV and save one file per statement.

What is inside an MT940 file?

MT940 is plain text, one tag per line, in the order a bank statement has always been printed:

Tag Meaning
:20: the bank's reference for this message
:25: the account, as an IBAN or as bank code and account number
:28C: the statement number and page
:60F: or :60M: the opening balance (F first, M carried over from a previous page)
:61: one statement line per booking
:86: the information for that line: purpose, counterparty, references
:62F: or :62M: the closing balance
:64:, :65: the available and forward available balance, informative only

Some banks add :90D: and :90C: with the number and total of debits and credits. Klarbon checks those against the lines and refuses a file where they disagree.

How does Klarbon read a :61: line?

Take :61:2611031103D125,40NTRFNONREF//B6K03. It holds the value date (26-11-03), the booking date without a year (11-03), the mark D for debit, the amount 125,40 with a decimal comma, the transaction type NTRF, the customer reference NONREF and the bank reference B6K03 after the double slash. Klarbon writes the value date, gives the booking date the year closest to the value date (so a booking on 2 January for a value date of 31 December lands in the right year), signs the amount, and uses the customer reference unless it is NONREF, then the bank's. RC is a reversed credit and becomes a debit; RD becomes a credit.

How is the :86: field split?

Layout Codes What Klarbon does
German (DK) ?00 posting text, ?20 to ?29 purpose, ?31 IBAN, ?32 and ?33 name purpose to description, IBAN and name to their columns, EREF+ to reference
Dutch structured /TRTP/, /NAME/, /IBAN/, /REMI/, /EREF/ and others REMI to description, NAME, IBAN and EREF to their columns
Any other free text, up to six lines kept as printed in the description

A Dutch field counts as structured only with two or more of its codes, so free text that happens to start with a slash stays whole. Where Rabobank puts the counterparty's IBAN alone on the second line of :61:, Klarbon takes it as the counterparty IBAN.

Common problems

What does it cost?

An MT940 file costs nothing to open, up to 10 files a day without an account and 30 with a free one, and its Excel and CSV are free. Rewriting it as CAMT.053 for software that wants XML costs one credit per started 500 transactions; see CAMT.053 and MT940 both ways. A download from a PDF statement costs one credit per started 10 pages, Excel and CSV included.

Frequently asked questions

How do I open an MT940 file?

Drop it on Klarbon. The file usually ends in .sta, .940, .mt940, .swi or .txt; Klarbon recognises it from its tags, not its name, and shows the account, period, balances and every line.

Why does Klarbon ask me to confirm a date?

MT940 writes years with two digits, so 261103 could be 1926 or 2026. Klarbon shows the first date both ways and you pick the right one once for the file.

The umlauts in my descriptions look wrong. Why?

Klarbon reads the file as UTF-8, and as Windows-1252 when it is not valid UTF-8, which covers what banks export. A file in another code page, such as an old DOS one, can show wrong letters. Export it again as UTF-8 or Windows-1252 if your bank offers the choice.

What is MT942?

The intraday counterpart of MT940, with the bookings of the day so far and no closing balance of its own. Klarbon reads it too, but for bookkeeping use the end-of-day MT940.

Sources

Updated 16 November 2026

Also as an API: Bank statement API