CAMT to CSV
Convert ISO 20022 CAMT.053 XML bank statements to CSV
CAMT XML input
Paste data, upload a file or load the sample, then click Convert. Your data is not uploaded or stored.
CSV output
Details
Choose which element each field is read from first, then convert again.
Transaction preview
About CAMT to CSV Converter
Our free CAMT to CSV converter transforms ISO 20022 CAMT.053 bank statement files and CAMT.054 debit/credit notification files into structured CSV data in seconds. The ISO 20022 CAMT format is the modern XML-based standard replacing legacy formats like MT940 across European and international banking, and converting it to CSV makes the data accessible for spreadsheets, accounting platforms, and data analysis tools.
This converter features an intelligent semantic field extraction engine that reads the CAMT version from the file and looks for each field in its usual places. It reads CAMT.053 statements, CAMT.052 account reports and CAMT.054 notifications in any schema version, with or without namespace prefixes. A built-in confidence scoring system rates each extracted field to ensure data quality.
Nothing is kept after you close the page. Your sensitive financial data is not uploaded or stored. Load camt.053 statements into an ERP, reconcile booked entries against open invoices, or review SEPA transfers line by line, with nothing to set up.
Key Features
- ISO 20022 Compliance: Reads CAMT.053 statements, CAMT.052 reports and CAMT.054 notifications across schema versions
- Semantic Field Extraction: Priority-based extraction for dates, amounts, references, descriptions, counterparties, and IBANs
- Version Detection: Shows the CAMT message type and version from the document namespace
- Batch Booking Support: Explodes batch entries (BtchBookg) into individual transactions with proper field inheritance
- Credit/Debit Inference: Automatically infers CdtDbtInd from amount signs when the indicator element is missing
- Confidence Scoring: Per-field and overall confidence ratings with low-confidence warnings for data quality assurance
- Customizable Field Mapping: Choose which element each field is read from first in the Details panel
- XML-to-Row Highlighting: Click any transaction row in the preview table to highlight its source location in the XML input
- Multi-Currency Support: Correctly handles EUR, USD, GBP, and other currencies with per-transaction currency tracking
- Counterparty Extraction: Extracts creditor and debtor names plus IBAN details from RltdPties elements
How to Convert CAMT to CSV
- Upload or paste your CAMT XML: Click Upload File to select a .xml or .camt file, or paste the raw XML content directly into the input area.
- Review the XML input: Verify the data appears correctly. Use the Sample button to load example CAMT.053 data for testing.
- Click Convert to CSV: Press the conversion button to parse the XML structure and extract all transaction entries into CSV format.
- Check the detection panel: Review the detected CAMT type and the overall parse confidence score.
- Inspect the transaction preview: Browse the interactive table showing dates, amounts, descriptions, counterparties, and per-row confidence.
- Download or copy the result: Save the CSV file with the Download button or transfer it to your clipboard with Copy.
Use Cases
- Treasury Reconciliation: Convert CAMT.053 statements to CSV for automated bank reconciliation in treasury management systems.
- SEPA Payment Processing: Extract transaction details from CAMT.054 notifications for SEPA credit transfer and direct debit workflows.
- ERP Data Import: Transform CAMT XML into CSV for importing into SAP, Oracle, Microsoft Dynamics, or other ERP platforms.
- Regulatory Compliance: Generate structured transaction records from CAMT files for regulatory reporting and audit trails.
- Cash Flow Forecasting: Import bank statement data into financial models and forecasting tools via CSV intermediary.
- Multi-Bank Consolidation: Standardize statements from different banks using various CAMT versions into a uniform CSV format.
- Accounting Software Integration: Feed CAMT transaction data into QuickBooks, Xero, or other accounting platforms through CSV import.
- FinTech Application Development: Use the tool's sample data and confidence scoring to test and validate CAMT parsing implementations.
Frequently Asked Questions
What is a CAMT file?
CAMT (Cash Management) is a family of ISO 20022 XML message types used for electronic banking. CAMT.053 contains end-of-day bank account statements, while CAMT.054 contains individual debit and credit notifications. These formats are widely used in SEPA countries and are replacing older formats like MT940.
Which CAMT versions are supported?
It reads CAMT.053, CAMT.052 and CAMT.054 files in schema versions 001.02 to 001.08 and later. The version comes from the document namespace and is shown with the result; fields are found the same way in every version.
What if my bank uses a custom CAMT format?
Open Details after converting and choose another source for a field, for example additional entry information instead of remittance information for the description, then convert again.
Does the converter handle batch bookings?
Yes. When the tool detects a batch entry (BtchBookg = true), it automatically expands the TxDtls elements into individual transactions, inheriting entry-level fields like date and currency where needed.
Tips & Best Practices
- Ensure valid XML: The input must be well-formed XML. If you see a parse error, check for truncated files or encoding issues.
- Review confidence scores: After conversion, check both the overall confidence and individual field scores to identify any extraction issues.
- Use click-to-highlight: Use Show on a preview row to select the XML entry it came from in the input.
- Adjust field mappings: If descriptions or references come from the wrong element, choose another source in the Details panel and convert again.
- Handle multiple statements: The converter processes every statement, report and notification in the file, so multi-statement files convert in one go.
- Keep your original files: Always retain the original CAMT XML files as the authoritative source, since CSV conversion may simplify some structured XML data.