MT940 to CSV
Universal Format Converter
Convert between CSV, TSV, JSON, and Excel. Supports multiple files, primary data, and batch operations.
Select a data source to begin conversion
No data loaded
Upload files or use primary data to start converting
About MT940 to CSV
Convert SWIFT MT940 bank statement files into CSV rows with value date, amount, credit/debit indicator and remittance info.
MT940 is the SWIFT message format European and multinational banks use for corporate account statements, and it shows up constantly in treasury and reconciliation workflows even though almost no ordinary spreadsheet tool reads it natively.
This converter pairs each ":61:" transaction line with its following ":86:" remittance information line, extracting value date, debit/credit indicator, amount and reference into one clean CSV row per transaction.
It's built for the messy reality of real bank exports — statements with dozens or hundreds of transactions in a single file — rather than a single toy example.
Since everything is parsed in-browser, it's a fast way to get a corporate statement into a format your accounting or BI tooling can actually ingest, without exposing account activity to an external upload.
Category: Financial FormatsCommon Use Cases
- Importing SWIFT statements into treasury spreadsheets
- Auditing corporate bank feeds
Key Features
- Pairs each ":61:" transaction line with its ":86:" remittance line
- Extracts value date, debit/credit indicator, amount and reference per row
- Handles statement files with dozens or hundreds of transactions
- Parses in-browser, keeping corporate account activity off external servers
The MT940 to CSV tool is compatible with: European Business Banking, SWIFT Statements.
Convert an MT940 statement here, then use CAMT053_TO_CSV for banks that have already switched to the newer ISO 20022 format, so both statement generations land in the same CSV structure for treasury reconciliation.
Frequently Asked Questions
Finance and treasury teams handling European or multinational corporate bank statements, since MT940 is a core SWIFT messaging format.
Yes, it pairs each transaction line with its following remittance information line into one CSV row.
Built for European treasury and finance teams who need SWIFT statement data in a spreadsheet without a dedicated banking middleware tool.
Read the related guide →