Spreadsheet Data To Gmail Contacts Group

This is the process for taking a spreadsheet of contact information and importing it into GMail. First you need to save your data as a csv file. Bellow are the menu selections from a Google Docs Spreadsheet, but it would be similar in Excel of Open Office. Just export your file to a comma delimited csv file.

From GMail select Contacts. Then select the More dropdown, and import.

Select the csv file you created and import it. GMail will create a group called Imported followed by the date. Select the group and you should see your contacts. Again select the More drop down and rename the group.

If you have problems importing the csv file you may have to edit the file. Here are the instructions for that process. https://support.google.com/mail/answer/12119