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.

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.

Comments (2)

Daren Dahl said:

	Thanks I was having difficulty adding an email address that began with an underscore. This tip worked perfectly. Thanks!
	report abuse vote down vote up

March 06, 2008
Votes: +0

Annie said:

... Clean out those nasty little bugs. The antispyware solution from Search-and-destroy is one of the best scanners I’ve found so far to help me clean out those nasty little bugs that slows down my computer and causes it to freeze up or crash. It keeps my computer running like new and best of all it cost less than many of the other better known scanners that have been available for awhile now. I was glad that I finally found a scan that works and that’s so affordable. Search-and-destroy Antispyware is the best scanner I’ve used so far and you can find out more information by simply visiting http://www.Search-and-destroy.com.

report abuse vote down vote up

May 13, 2009
Votes: +0

Name

Email

Website

Title

Comment

smaller | bigger

Subscribe via email (Registered users only)

Add Comment