I was trying to add my grandparent's e-mail to my Gmail contact list, but gmail kept telling me "Please make sure the email address you entered is valid."  I figured it probably wouldn't import it because they were using something of a non-standard address.

The culprit here happens to be the ampersand sign.  I realized that gmail also has a contacts import option which allows you to import contacts from a CSV file. A CSV file is essentially just a text file with values separated by commas. It essentially allows you to put tabular data into a non-proprietary format.

Editors Note: There is not supposed to be a space after the ampersand, but for some reason my blog software keeps adding it.

To create the file for Gmail, we can either create the file in a simple text editor like Notepad, or even more simply, create an Excel file and save it as a CSV file.  To do this in excel, simply create the file then when you go to save the file, change the file type to Comma Separated (.CSV). The CSV file needs to have headers for the column names and the data below it.  I'll show you what my one entry file looked like.


Name Email Address
John Doe

For those of you interested in what the CSV file would look like once saved, it would be:

And now for the import in Gmail. Click Contacts on the left, then click Add Contacts at the top, click Import, click Browse and find the CSV file you created, then click Import Contacts.


Add comment

About Me

Josh Lyon Profile Picture

Name: Joshua Lyon
Location: Dallas, TX
E-mail: This email address is being protected from spambots. You need JavaScript enabled to view it.
ProfilesGoogle, Twitter, GitHub
Other Sites:
     L2 Technology Services