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  
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, bills and credit notesImport invoices, bills and credit notesImage of a check mark Image of a check mark 
Invoice, credit note, statement and purchase order templatesAdd a branding theme Image of a check mark
Manual journalImport manual journalsImage of a check mark Image of a check mark 
Paypal statements

Import PayPal CSV

Image 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     
Credit notesPrint bulk credit notes    Image 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 your invoices and billsImage of a check mark     
ReportsExport reportsImage of a check markImage of a check mark  Image of a check mark 
Statements Print bulk statements    Image of a check mark