Convert CSV to Xero
Convert CSV bank statements into Xero-compatible import format
CSV Input
Try a sample:
Drop a CSV file here or
Only the first file is used if multiple are dropped.
The request is made directly from your browser. No proxy is used.
Column Mapping
Provide CSV input above to map columns.
Xero CSV
Output will appear here...
Options
CSV Format
Input
Output
How to Use This Tool
This tool converts bank statement CSVs into Xero-compatible import files directly in your browser. No data is uploaded or sent to any server.
- Provide your bank statement — Paste CSV text, upload a file, or try the sample dataset to see how it works.
- Map your columns — Use the Column Mapping panel to tell the tool which of your CSV columns correspond to Xero’s fields (Date, Amount, Payee, Description, Reference, Check Number). Columns with matching names are mapped automatically.
- Download your Xero CSV — Once all required fields are mapped, the output appears instantly. Copy it to your clipboard or save it as
xero-import.csvfor import into Xero.
FAQ
5 questionsDoes this tool upload my bank statement data?
No. All conversion happens entirely in your browser using JavaScript. Your financial data never leaves your device — no server receives, stores, or processes it.
What format does Xero expect for CSV imports?
Xero accepts CSV files with specific column headers: Date, Amount, Payee, Description, Reference, and Check Number. Only Date and Amount are required.
How are dates handled?
The tool detects your bank's date format automatically and normalizes all dates to YYYY-MM-DD (ISO 8601), the format Xero expects for unambiguous date parsing.
What if my bank shows debits as positive numbers?
Open the Options panel and check 'Negate amounts' to flip the sign on all Amount values so debits appear as negative in Xero.
What happens to rows with empty amounts?
Rows where the Amount column is empty or contains only non-numeric characters are automatically skipped in the output.