555555
Don't miss out on your FREE Xero mini-course ... Click Here!

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.

You can copy the steps taken here by using the Demo Company in your Xero account. To learn more about contacts in Xero, please see our tutorials on Xero contacts.

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.

You’re All Set!

That’s it for this lesson. For more helpful tutorials on Xero contacts, please follow this link. For other Xero tutorials, please click here.

Pin It on Pinterest