Import your contacts

To save time when setting up your accounts, you can import your contacts using Comma Separated Value (CSV) files. CSV files are files held in a standard windows format that other software can use. They’re therefore often used to transfer information between different software such as Sage and Microsoft Excel.

To save an Excel file as csv, from within the workbook, open the File menu > Save As > Save as type > CSV (Comma delimited)(*.csv).

If required, you can also import your product and service records using CSV files.

When importing contacts, the import file must be in the correct format. To ensure the file is in the correct format, you can download the template CSV file from the link below or as part of the import routine. The template CSV file includes an example of what you need to enter in each column.

Contact CSV file format

To import your contact records, the CSV file needs to be in the following format:

To ensure your information imports successfully, you must include a header row in your CSV file, using the same headings as in the Field name column below.

Column Field name Type Length Compulsory
A Name Text 50 This is only compulsory if column B is blank.
B Company Text 50 This is only compulsory if column A is blank.
C Telephone Text 50 No
D Mobile Text 50 No
E Email Text 100 No
F Vat Number Number 14 No
G Primary Address 1 Text 50 No
H Primary Address 2 Text 50 No
I Primary Town Text 50 No
J Primary County Text 50 No
K Primary Postcode Text 10 No
L Primary Country Text 2 – For example, GB for Great Britain or IE for Ireland No
M Delivery Address 1 Text 50 No
N Delivery Address 2 Text 50 No
O Delivery Town Text 50 No
P Delivery County Text 50 No
Q Delivery Postcode Text 10 No
R Delivery Country Text 2 – For example, GB for Great Britain (UK) or IE for Ireland No
S Notes Text 500 No

To import your contact records

  • 1. Contacts > Import Contacts > choose Customers or Suppliers.

You can also import contacts from Contacts > Customers or Suppliers > Import Customers or Import Suppliers.

  • 2. If required, to download the template > click the download a template csv file here link.

Depending on your Internet browser, one of the following happens:

  • The file opens in Microsoft Excel.
  • The file downloads automatically to your Downloads folder > browse to your Downloads folder and open the file.
  • You’re prompted to open or save the file > Open.

If you’ve already created a CSV file without using the template, you must download the template and check your file is in the correct format. If it isn’t, before continuing, you must amend your file so it matches the template. If you don’t, the import can fail. The second line of the template shows an example of what you should enter. You should delete this line before importing your contacts into Sage One. Do not amend the column headings.

  • 3. Enter the required information > File > Save As.
  • 4. Browse to the location in which you want to save your file, for example your Windows desktop.
  • 5. Save as type > CSV (Comma delimited)(*CSV) > Save > close the file.
  • 6. From within Sage One > Browse or Choose File > browse to your CSV file > Open > Upload.

You can’t use Sage One while the data is uploading.

If for any reason the upload fails, a message appears advising why it’s failed. You should fix the errors then try uploading the CSV file again.

You’ve successfully imported your contacts and they appear on the contacts list.

If you haven’t already done so, you can also import your products and services.

Did you find this helpful?

Still need help?

Ask the Sage City community. Sage City is the place to ask questions, share tips and ideas, get practical advice and all the breaking news. Alternatively, find out other ways of getting in touch.

Visit Sage City