Exporting & importing
Which export format should I use?
A quick guide to Excel, CSV, QBO, OFX, QIF, QuickBooks CSV and Xero CSV.
| Destination | Best format |
|---|---|
| Excel / Google Sheets | Excel (.xlsx) |
| QuickBooks Desktop | QBO |
| QuickBooks Online | QBO or QuickBooks CSV |
| Xero | Xero CSV or OFX |
| Sage, MYOB, Zoho Books, FreeAgent | OFX or CSV |
| Quicken | OFX (rename to .qfx if needed) or QIF |
| Databases, Python, BI | CSV |