When you convert a bank statement, you get two export options: CSV and Excel (.xlsx). They contain the same transactions, so the choice seems cosmetic — but picking the wrong one creates real friction: failed imports, mangled dates, or a file you cannot comfortably analyze. The rule of thumb is simple: CSV is for machines, Excel is for people.
The quick comparison
| CSV | Excel (.xlsx) | |
|---|---|---|
| Best for | Importing into software | Reading, sorting, analysis |
| Formatting | None — plain text | Headers, column widths, number formats |
| Compatibility | Universal (QuickBooks, Xero, YNAB, databases) | Spreadsheet apps only |
| Date handling | Text — importer interprets the format | Real date values, displayed as you like |
| File size | Tiny | Larger, still small for statements |
| Risk | Excel can auto-mangle values on open | None — values are stored typed |
Choose CSV when the destination is software
- QuickBooks Online — manual upload requires its 3- or 4-column CSV layout. See the QuickBooks import guide.
- Xero — accepts CSV, OFX, and QIF; CSV is the format you can produce from any statement. See the Xero import guide.
- YNAB, Wave, GnuCash, custom tools — nearly every finance app with an import feature speaks CSV.
- Scripts and databases — CSV loads cleanly into Python, R, SQL, and anything else that parses text.
Choose Excel when a human will work in the file
- Reconciliation — you want real date and number values for formulas like COUNTIF and SUMIFS, not text that needs re-parsing. See the Excel reconciliation workflow.
- Review and annotation — add columns, highlight rows, leave comments without breaking anything downstream.
- Sharing with an accountant — a formatted .xlsx opens correctly everywhere, with no "import wizard" guessing at column types.
The date trap (and how to avoid it)
The classic CSV failure: you open the file in Excel to "just look at it", Excel converts dates and strips leading zeros, you hit save, and the accounting import now rejects the file. If you need to inspect a CSV, open it read-only or in a text editor — or just export the Excel version for viewing and keep the CSV untouched for the import. Since the converter lets you download both formats, keep one of each.
Not sure which import format your software expects? The FAQ covers the common targets, and the pricing page explains what the free tier includes for both formats.