What is SWIFT MT940?
MT940 is a standard SWIFT message type for end-of-day bank statements, common in Europe and corporate banking.
CSV output helps treasury analysts reconcile in Excel or load feeds into ERP systems.
What data is included in the MT940 to CSV export?
Your CSV typically includes:
- Transaction date, formatted for spreadsheets
- Amount, with optional sign flip for your bank convention
- Description, payee, or narrative text when present
- Reference, check number, or category fields when supplied
- Account or currency metadata when the file includes it
Why use this MT940 to CSV converter
Private browser conversion
Files never leave your device. No account required.
Fast preview
See rows before you download so you can catch format issues early.
Free with no watermark
Unlimited conversions for personal and business use.
Works with real bank exports
Built for production statement files, not toy samples.
Excel-ready output
UTF-8 BOM and CRLF options help Excel open the file on the first try.
Batch-friendly
Combine multiple statement files in one session when supported.
Who converts MT940 to CSV?
Accountants and bookkeepers
Reconcile in Excel, match invoices, and share clean tables with clients.
Small business owners
Build cash-flow views without proprietary software.
Treasury and finance teams
Normalize bank feeds before loading a data warehouse or ERP.
Migrating between tools
Move historical transactions into a new accounting platform via CSV.
CSVall vs other ways to convert MT940
Compare common approaches before you pick a workflow.
| Method | Cost | Speed | Data privacy | Ease of use |
|---|---|---|---|---|
| CSVall (this tool) | Free | Instant | Browser-only | Upload and download |
| Manual copy in a text editor | Free | Slow | Local | Technical |
| Desktop converter app | Paid | Fast | Varies | Install required |
| Ask your bank for CSV | Free | Depends on bank | Bank portal | Not always offered |
Getting MT940 files from your bank
Ask your relationship manager or treasury portal for MT940 exports:
- Log in to online banking and open the account.
- Choose Download or Export for transactions.
- Pick the date range you need.
- Select MT940 or the closest format your bank lists.
- Save the .sta or .mt940 file, then upload it here.
Shorter date ranges convert faster and are easier to verify.
Common MT940 to CSV issues
Dates look like numbers in Excel
Pick ISO, US, or EU in options, or format the column as Date after import.
Wrong debit and credit signs
Enable Flip amount sign or multiply the amount column in your sheet.
Garbled characters
Use UTF-8 BOM and import with UTF-8 selected in Excel.
Missing rows
Confirm you exported transactions, not a summary PDF or HTML page.
Related bank formats
Also see CAMT.053 to CSV, bank statement to CSV, and OFX to CSV.