Home › Invoices, banking and VAT › MT940 to Excel converter
MT940 to Excel converter
MT940 bank statement files (.sta, .mt940) into one Excel list: date, amount, counterparty, text and balance after each row.
No statement file at hand? or download the sample. Prefer it fully offline in your browser? The same converter also runs on Hugging Face (no upload).
- Press Select file and choose one or more MT940 files.
- Leave Convert on to Excel.
- Press Convert statements, check the balance check, then download the Excel file.
💡 Simple guide · no technical skills needed
When do I need this?
You have MT940 statement files (.sta, .mt940, .txt) from your bank or old banking software and want them as a table in Excel.
Good to know
- German :86: purpose fields (EREF, SVWZ, IBAN) are split into their own columns.
- Need CAMT.053 instead? The same tool writes it: /instant/mt940-to-camt053.
Words explained
- MT940
- The older file format banks use for account statements.
- Excel
- A spreadsheet program (tables with rows and columns). Google Sheets and LibreOffice open the same files.
- IBAN
- Your bank account number in the international format, e.g. DE89 3704 0044 0532 0130 00.
- camt.053
- The new file format banks use for account statements.
Stuck? Press Help in the bottom corner and write your question in any language. You get an answer in seconds, or a real person answers you.