How to Import Contacts to Gmail With a CSV File

Storing all of your contacts in your Gmail account is helpful when you get a new smartphone and want to quickly have access to your contacts on that device. It also makes it much simpler to find email addresses and phone numbers in Gmail when you need them.

But the process of adding new contacts one by one can be tedious through a Web browser or on your phone, so you might be looking for a way to add a lot of contacts at once by importing them to your Gmail account in bulk via a file upload. Fortunately this is something that you are able to do, so continue reading our tutorial below and find out how to import contacts to Gmail via a CSV file.

 

How to Add Contacts to Gmail With a CSV File

The steps in this article were performed using Microsoft Excel. The general process of importing contacts to Gmail through a CSV file will have you download the CSV template from your Gmail account, open that file in Excel so that you can add data, then you save the file and upload it back to Gmail.

A couple of important things to note about importing contacts to Gmail with a CSV file:

  • While we use Excel in the example below, you can also use any other application that can open and edit CSV files, like Google Sheets.
  • This process is going to export all of your existing contacts from Gmail, then you can add new contacts to the list.
  • This is going to result in duplicate contacts in your Gmail account, but you will have the ability to find and merge duplicates after you import the file back to your account. Alternatively you can delete all of the contacts from the exported file and only import new contacts. Just be sure to leave the column headings in row 1 intact.
  • You don’t need to fill in all of the information for new contacts that you add. For example, I only fill in a name file, email address and telephone number in my example below.

Step 1: Go to your Google contacts at https://contacts.google.com. If you aren’t already signed into the Gmail account to which you wish to upload contacts via CSV, then you will be prompted to sign in.

 

Step 2: Click the More option in the column at the left side of the window.

google contacts more menu

 

 

Step 3: Choose the Export option.

export existing google contacts

 

 

Step 4: Confirm that your contacts and the Google CSV options are selected, then click the Export button to download the file.

export contacts as a csv file

 

 

Step 5: Open the exported file in Excel, or whatever spreadsheet application that you wish. For example, you could also choose to open and edit this file in Google Sheets.

 

Step 6: Scroll to the bottom of the list of existing contacts, then begin adding new contacts either by typing them manually or by copying and pasting values from another existing sheet. Note that there may be a very high number of columns in this spreadsheet and that important fields like “E-mail Value 1” and “Phone 1 – Value” might require you to scroll pretty far. For example, these fields were columns AE and AG, respectively, in my exported CSV file. I have hidden a few columns in the image below so you can see what the important ones are labeled as and where they are located.

add new contacts

 

 

Step 7: Click the File tab at the top-left corner of the window.

open excel file menu

 

 

Step 8: Select the Save option.

save the csv contact file

 

 

Step 9: Click the Yes button to confirm that some features may not be compatible with the CSV file format.

confirm the csv file type

 

 

Step 10: Go back to your Google Contacts tab in your browser and click the Import option in the column at the left side of the window.

gmail contacts csv import

 

 

Step 11: Select the CSV or vCard file option.

how to import contacts with a csv file in gmail

 

 

Step 12: Click the Select File button.

upload contacts to gmail with a csv file

 

 

Step 13: Browse to the CSV file on your computer, select it, then click the Open button.

select csv file to import to gmail

 

 

Step 14: Click the Import button to import your CSV file contacts to your Google account.

click the import button

 

 

Step 15: Click the Find Duplicates button at the top of the window.

find duplicates

Step 16: Select the Merge All option to combine any duplicate contacts that were created by this import.

merge duplicate contacts to gmail from csv import

 

 

If you are adding contacts from a number of different CSV files that are all in the same format, then you might be able to save some time by merging all of those csv files into one.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.