Google Mail: Create Contact Group from an Excel File

Before you start...

Google Mail allows you to import a contact group into contact from an Excel file. This involves 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: To enter contacts into an Excel file and save it as a .CSV

  1. Open Microsoft Excel. In the first row, label the first three columns the following:
    • First Column: First Name
    • Second Column: Last Name
    • Third Column: Email Address
  2. In the rows below, 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].
  7. If a window pop-ups asking if you want to keep the workbook in this format, click [Yes].

Note:

In addition to columns for First Name, Last Name and Email Address, you may also add columns for other information, such as Home Address and Mobile Phone.

Step 2: To import the .CSV file into Google Contacts

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

Note:

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

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