Import of contacts can be done on the basis of a comma separated existing, also called CSV format. In Excel 2016 you have to choose the following CSV format: 


In the following dialog the import parameters can be set:



  • Mode: Select from Add/ Add, Modify/Modify/Delete.
  • Date Format: When date fields are read in accordance with the specified format as defined here.
  • Default User: The assigned responsible person who can be assigned per account.
  • Company Match: Select from By name / Via import ID.
  • Add Country: When a non existing country is read in, it can be added.