Setting up a file (.csv) to import contacts (import & export contacts in webmail) not gmail

This article will brief you on how to set up a CSV(comma-separated values) file, which can then be used to import/update your contact list 

Requirements

The import file must be a CSV(comma-separated values) file.

The file will have an object type/header for the Name and for the Email respectively, both of these being mandatory.

The import file should not contain more than 1000 contacts.

Please make sure there are no special characters in your import file.

 

Convert Excel file to CSV

 Open the Import file. This can be done through spreadsheet software such as Microsoft Excel and can also be done via TextEdit (Mac) or Notepad (Windows)

Select your import File. 

Enter your contact details for Name and Email

Click Save As.

Rename the file if you prefer then select .csv (Comma delimited.)

Click Save.

 

Convert Google Sheets to CSV

Log into your Google account and select Google Sheets

Enter your contact details

Select File > Download > Comma Separated Values(.csv)

The file will be saved in your downloads folder

 

Please note, if you have a file with multiple sheets/tabs, you will have to export each sheet/tab in a separate CSV file and merge it manually.

 

here you can download a sample file which has the format you need to upload contacts and two other files that are examples

 

Article Details

Article ID:
10
Category:
Rating :

Related articles