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 organizations 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
  CSV/
XLS
Google SheetsMYEVariousPDFTXT/
XML
Batch paymentsExport a batch file   Image of a check mark  
BudgetExport budgetImage of a check markImage of a check mark    
Chart of accountsExport COAImage of a check mark     
ContactsExport contactsImage of a check mark     
Fixed assetsExport fixed assetsImage of a check mark     
GL dataExport GL dataImage of a check mark Image of a check mark  Image of a check mark
Inventory itemsExport inventory itemsImage of a check mark   Image of a check mark 
Invoices and billsExport invoices and billsImage of a check mark     
ReportsExport reportsImage of a check markImage of a check mark  Image of a check mark 

You might also be interested in