Get Your Free

Xero Courses Now

Tired of bad quality homemade Xero tutorials? Our easy-to-follow FREE Xero courses will help you learn the essentials in only 2 hours.

Xero Contacts – How to Export Contacts

by | 13 Jul 2018 | Contacts

If you have a list of contacts that you want to transfer to another Xero account or a different system, you can start by exporting your Xero contacts into a CSV file. In this tutorial, we will export the contacts list from Xero’s demo company and see what the downloaded CSV file looks like.

Contacts Section in Xero

To get to the right place in Xero, go to Contacts → All Contacts from the main menu:

0116-xero-contacts-export-contacts-01

How to Export Contacts from Xero

Next, click on the Export button at the top of the screen:

0116-xero-contacts-export-contacts-02

Xero will download a CSV file that can be opened with a spreadsheet program such as Microsoft Excel or Google Sheets. Let’s take a look at what the first few rows and columns of the downloaded contacts file looks like in Excel:

0116-xero-contacts-export-contacts-03

As you can see, each row contains the details of one of your Xero contacts. There is also a header row at the top containing the names of each field, such as *ContactName. You can now use the CSV file to upload the contacts into another Xero account or into another system.

If you want to upload the exported contacts into a different Xero account, you can import the CSV file in its current format. There is no need to change anything. Please see our tutorial on how to import Xero contacts to find out how to import the CSV file.

If you want to upload the exported contacts into a different system, you may need to make changes to the CSV file or copy and paste the data into a different import file. The system you want to upload the contacts into should provide instructions on the format and layout of the import file it requires.

ultimate-guide-to-setting-up-xero-550x623
xero-big-bundle-course-600x600

Get All 5 Xero Courses and Save 48%

Do you want all our Xero courses? Save 48% by getting them all today for one low price!

  • The best value Xero training anywhere online today.
  • With 240+ lessons and 1200+ minutes of learning you will become a Xero expert fast!
  • Get on top of your Payroll, BAS & GST, Bank Accounts and much more much faster than you can going it alone.

$49.00