How to Merge Emails From Excel to Gmail

By Aksana Nikolai

Importing contacts into Gmail using an Excel spreadsheet can save you time.
i Ryan McVay/Photodisc/Getty Images

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

Step 1

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.

Step 2

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.”

Step 3

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

Step 1

Sign in to your Gmail account. Click “Gmail” at the top of the page and select “Contacts.”

Step 2

Click “More,” then select “Import” from the drop-down menu.

Step 3

Click “Browse” and navigate to the directory in which you saved the Excel spreadsheet. Select the Excel file and click “Open.”

Step 4

Click “Import.” Once Gmail is finished with the import process, it displays the number of new contacts imported.

×