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 importHow toImport file format
  CSVOFX/QIFTXTDOCX
Bank statements

Import a bank statement

Image of a check markImage of a check mark
Bills and credit notesImport bills and credit notesImage of a check markImage of a check mark
BudgetImport budgetImage of a check mark
Chart of accountsImport a COAImage of a check mark Image of a check mark 
ContactsImport contactsImage of a check mark Image of a check mark 
Fixed assetsImport fixed assetsImage of a check mark Image of a check mark 
Inventory itemsImport inventory itemsImage of a check mark Image of a check mark 
Invoices and credit notesImport invoices and credit notesImage of a check mark Image of a check mark 
Manual journalsImport manual journalsImage of a check mark Image of a check mark 
Paypal statementsImport PayPal CSVImage of a check mark   

Export items out of Xero in these file formats

Items you can exportHow toExport file format
  BACSCSV/
XLS
Google SheetsMYEVariousPDFTXT/
XML
Batch paymentsExport a batch fileImage of a check markImage of a check mark  Image of a check mark  
BudgetExport budget Image of a check markImage of a check mark    
Chart of accountsExport COA Image of a check mark     
ContactsExport contacts Image of a check mark     
Fixed assetsExport fixed assets Image of a check mark     
GL dataExport GL data Image of a check mark Image of a check mark  Image of a check mark
Inventory itemsExport inventory items Image of a check mark   Image of a check mark 
Invoices and billsExport invoices and bills Image of a check mark     
ReportsExport reports Image of a check markImage of a check mark  Image of a check mark 

You might also be interested in