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