Banking formats
Bank exports are rarely one universal format. Corporate banking portals, accounting apps, and personal finance tools all use different statement files. This hub explains what each format is for and links the conversion paths that turn those exports into clean CSV.
Use CAMT.053 for ISO 20022 XML exports, MT940 for SWIFT-style statements, and OFX when the bank provides an Open Financial Exchange download. Convert the final file to CSV for spreadsheet reconciliation.
Quicken and QuickBooks-style exports are common for personal and small-business banking. CSVall links those formats into CSV workflows for Excel, Google Sheets, and imports.
Choose the format your bank already exports. CAMT.053 and MT940 are common in business banking and treasury workflows. OFX, QFX, QBO, and QIF appear more often in accounting and personal finance tools. PDF is common when the bank only offers a printable statement, but structured formats usually convert more reliably.
CSV is the practical working format after conversion because spreadsheets, reporting tools, databases, and reconciliation systems can read it without special banking software.
If you are not sure what you have, start with the Bank Statement to CSV tool. It is designed as the broad entry point for bank exports. If you already know the exact extension, go directly to the dedicated CAMT.053, MT940, OFX, QFX, QIF, or QBO converter.
