File Converter · free, in your browser

Convert MT940 to Excel

MT940 is the SWIFT statement many banks send to bookkeeping programs. Open it as a workbook with one row per statement line, the opening and closing balances, and a check.

Convert MT940 to Excel

How to do it

1. Drop the MT940 file on the page. It is recognised from its fields (:20:, :25:, :60F:), whatever its name.
2. Bank statement to Excel (XLSX) is chosen for you. Choose Convert, then Download.
3. The Transactions sheet lists every :61: line of every statement in the file, with the :86: text split into text and counterparty where the bank uses the German or Dutch layout.
4. The Statement sheet checks that the opening balance plus the lines equals the closing balance.

Your files stay on this device: File Converter runs in your browser, with no upload, no account and no watermark.

Questions

Can one file hold several days?

Yes. Every statement in the file is read; the Account column says which account each line belongs to when there are several.

How are reversals shown?

A reversal (RC or RD) gets the sign of the money it moves and the word Reversal in the Status column.

Can I get CSV?

Yes. Choose Bank statement to CSV, or use the MT940 to CSV page.

More with File Converter

• Convert a PDF to Word (DOCX)
• Convert a PDF to Excel (XLSX)
• Convert a PDF to PowerPoint (PPTX)
• Convert AVIF to JPG
• Convert an ICS calendar to CSV
• Convert XML to JSON
• A free CloudConvert alternative that stays on your device
• 3D file converter
• Convert a 3D model to STL for printing
• Open an SIE file online
• Convert an SIE file to Excel
• Convert OFX to Excel
• View a camt.053 bank statement
• DNG converter: RAW photos to JPG, PNG or WebP

Related apps

• Page Layout
  Beta
  Lay out pages for print with master pages and text frames.
• Compare
  Beta
  Compare two texts, files, PDFs or pictures and see every change. Nothing uploaded.
• Code Editor
  Preview
  A code editor for your Files files. Nothing uploaded.