Google Mail: Create Contact Group from an Excel File

Google Mail: Create Contact Group from an Excel File

Google Mail allows you to import a contact group into contact from an Excel file. This process consists of two steps: saving the Excel file with the desired information as a .CSV file and then importing the .CSV file into your contacts.

Step 1: Entering contacts into an Excel file and saving it as a .CSV

  1. Open Microsoft Excel. In the first row, label the first three columns as follows:
    • First Column: First Name
    • Second Column: Last Name
    • Third Column: Email Address
  2. In the rows below those, enter the corresponding information for each contact.
  3. When you are done entering all the information for each contact, navigate to “File” > “Save As”.
  4. From the “Save as type:” drop-down menu, select “CSV (Comma delimited) (*.csv).”
  5. Select a location to save the file.
  6. Click [Save]. If a window pop-ups asking if you want to keep the workbook in this format, click [Yes].


You may also include more contact information by adding columns entitled "Home Address" and "Home Phone". To view the complete list of column headings you can include, create a "Test" Google Contact and fill in all the desired fields. Export (.CSV) the "Test" Google Contact and open it in Excel. Copy and paste all the relevant column headings into the Excel sheet you wish to import into Google Contacts. 

Step 2: Importing the .CSV file into Google Contacts

  1. Navigate to
  2. Click the “Mail” link and log in.
  3. From the Google Apps options across the top of the page, click “Contacts.” The Contacts page will open.
  4. Click [More]. A drop-down menu will appear.
  5. From the drop-down menu, click [Import…]. The Import Contacts window will open.
  6. Click [Choose File]. Navigate to and select the .CSV file you created in Step 1.
  7. Click [Open].
  8. Click [Import]. The group will appear in the sidebar as “Imported MM/DD/YY (#).”
  9. To rename the group, navigate to the group and click [More] > “Rename group.”


If the .CSV filed you imported contained contacts already in your Google Contacts, you may have duplicates of those contacts in the base "My Contacts" group. For more information, see the Google Mail: Merge Duplicate Contacts help page.

Keywords: import contacts from Excel, create .CSV file from Excel, make .CSV file

Email this to a Friend

Help Page Feedback

Did this content help you? *

What is your opinion about the content? *

Suggest new content or let us know how we can improve this content (optional):

If you desire a response, please provide your email address (optional):

Leave this field empty