DJL Training, Inc
DJL Training, Inc
Increasing Efficiency and Productivity

Import Excel Contacts into Gmail

02-22-14 12:06 AM By DeLisa Lee

Gmail Contacts

Do you have a list of contacts in Excel that you would like to import into your Google Contacts?


Google contacts supports importing data from CSV files, Outlook, Yahoo!, Hotmail and more.

To import contacts from a CSV file:
  1. Open your Excel spreadsheet.

    Make sure your column headings are in row 1 and your first contact is in row 2.

    The Name field can be a single column, or you can use separate columns for first name, middle name and last name.

    The must be a column for email address.

    If you have a Notes column, it will be imported into the Contact's Notes field.
  2. Save As... CSV (comma separated value)

    Save as CSV

    Excel may warn you that your file contains features not supported by CSV format. Click OK. 

    Note the location of your saved file.
  3. Open your Google contacts in Gmail.
  4. Click the More button above the contact list and select Import.

    More menu > Import
  5. Click the Choose File button and navigate to your .CSV file. Click Import. Gmail will display the number of contacts to be imported.

    Choose File

  6. You're done! Click My Contacts to view your Contacts.

Additional Notes:

The import process supports a Notes field. However, the maximum size for a contact is 128 KB. So if a contact exceeds this size, the Notes field might be truncated. 

You can upload up to 3,000 contacts at a time. If you have more than 3,000 contacts to upload, you'll need to create more than one CSV file to upload.

DJL Training, Inc. | PO Box 72362 | Durham NC 27722 | www.djltraining.com | firstclass.djltraining.com

(c) Copyright 2010-2019 | All Rights Reserved