Import customers from file

Import customers from file

This feature allows you to import a customer record from an Excel file.
The column names must be specified in the first row of the Excel spreadsheet. The names of the fields that can be imported are as follows:

  • FirstName
  • LastName
  • Address
  • City
  • Province
  • Zipcode
  • CardCode
  • Country
  • Telephone
  • Email
  • MobilePhone
  • BornDate (DD/MM/YYYY)
  • Male (M or F)
  • TaxCode

All fields must be of type Text. The only required fields are FirstName, LastName and CardCode. The format of the Excel file can be XLS (Excel 97-2003) or XLSX (2007 onwards).

Example Excel file to be imported