Import data into and export data out of Xero
Learn what items and file formats you can import into and export out of Xero. Your user role determines which areas in Xero you have access to.
This page doesn't include information on data exchanges to or from other organisations including bank feeds, Xero to Xero sales invoices and bills, and Xero apps.
Import items into Xero using these file formats
Items you can import | How to | Import file format | |||
---|---|---|---|---|---|
CSV | OFX/QIF | TXT | DOCX | ||
Bank statements | ![]() | ![]() | |||
Bills and credit notes | ![]() | ![]() | |||
Budget | Import budget | ![]() | |||
Chart of accounts | ![]() | ![]() | |||
Contacts | Import contacts | ![]() | ![]() | ||
Fixed assets | Import fixed assets | ![]() | ![]() | ||
Inventory items | Import inventory items | ![]() | ![]() | ||
Invoices and credit notes | ![]() | ![]() | |||
Manual journals | Import manual journals | ![]() | ![]() | ||
Paypal statements | Import PayPal CSV | ![]() | |||
Report codes (partners only) | Import report codes | ![]() |
Export items out of Xero in these file formats
Items you can export | How to | Export file format | |||||
---|---|---|---|---|---|---|---|
CSV/ XLS | Google Sheets | MYE | Various | TXT/ XML | |||
Batch payments | Export a batch file | ![]() | |||||
Budget | Export budget | ![]() | ![]() | ||||
Chart of accounts | Export COA | ![]() | |||||
Contacts | Export contacts | ![]() | |||||
Fixed assets | Export fixed assets | ![]() | |||||
GL data | Export GL data | ![]() | ![]() | ![]() | |||
Inventory items | Export inventory items | ![]() | ![]() | ||||
Invoices and bills | Export invoices and bills | ![]() | |||||
Reports | Export reports | ![]() | ![]() | ![]() | |||
Report codes (partners only) | Export report codes | ![]() |
You might also be interested in
- User roles and their access to settings
- Bank feeds
- App marketplace (xero.com website)