How to Merge Emails From Excel to Gmailby Aksana Nikolai
Regularly updating your contact list is an important part of staying on top of your communications with colleagues and loved ones. Manually typing dozens or hundreds of email addresses into your Gmail contact list can be time-consuming. You can expedite the process of updating your contact list by importing new contacts from an Excel spreadsheet. To do so, create an Excel spreadsheet, save it in CSV format and upload it to Gmail.
Create CSV File in Excel
Enter the email addresses you want to transfer to Gmail into a table column in an Excel spreadsheet. Put the heading “Email Address” into the first cell of that column.
Create additional columns in the table for any other information you want to associate with the email addresses, such as first and last name. Give these columns appropriate headings, such as “First Name” and “Last Name.” Click “File” and select “Save As.”
Click “File” and select “Save As.” Select the directory on your computer to which you want to save the spreadsheet and enter a name for the file. Select “CSV (Comma delimited) (*.csv)” from the “Save as Type” menu and click “Save.”
Import Excel CSV File to Gmail
Sign in to your Gmail account. Click “Gmail” at the top of the page and select “Contacts.”
Click “More,” then select “Import” from the drop-down menu.
Click “Browse” and navigate to the directory in which you saved the Excel spreadsheet. Select the Excel file and click “Open.”
Click “Import.” Once Gmail is finished with the import process, it displays the number of new contacts imported.
- You may need to reformat the columns and headers in your spreadsheet if you encounter errors while importing contacts (see link in Resources).
- Information in this article applies to Gmail's new look, which was rolled out in 2011. It may vary slightly or significantly with other versions or products.
- Ryan McVay/Photodisc/Getty Images