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 involves two steps: saving the Excel file with the desired information as a .CSV file and then importing the .CSV file into your contacts.
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
- In the rows below, enter the corresponding information for each contact.
- When you are done entering all the information for each contact, navigate to “File” > “Save As”.
- From the “Save as type:” drop-down menu, select “CSV (Comma delimited) (*.csv).”
- Select a location to save the file.
- Click [Save].
- If a window pop-ups asking if you want to keep the workbook in this format, click [Yes].
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.
- Navigate to cedarville.edu/google.
- Click the “Mail” link and log in.
- From the Google Apps options across the top of the page, click “Contacts.”
- The Contacts page opens.
- Click [More]. A drop-down menu appears.
- From the drop-down menu, click [Import…]. The Import Contacts window opens.
- Click [Choose File].
- Navigate to and select the .CSV file you created in Step 1.
- Click [Open].
- Click [Import]. The group will appear in the sidebar named as “Imported MM/DD/YY (#).”
- 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