How to Add Contacts to Gmail Using a CSV File

PDF download Download Article
PDF download Download Article


You can add email contacts in bulk to your Google account by importing them from a .CSV file (comma-separated value). Contact CSV files can be made from scratch or exported from your email client of choice. You can use a blank Gmail CSV file as a template to see the acceptable fields, then add your own contacts. Once complete, sign into your Google Contacts and import the CSV file. Don’t forget to double check your imported contacts for accuracy.

CSV Format for Google Contacts

  1. In Google Contacts, click “Export” on the top of the menu.
  2. Select the contacts you’d like to include.
  3. Select “Google CSV” and then click “Export.”
  4. Import the file in Excel or Google Sheets.
  5. Reverse these steps to import contacts from Excel or Google into Google Contacts.
Part 1
Part 1 of 2:

Creating a CSV File Template

PDF download Download Article
  1. Export a CSV file from Gmail. This can provide a template for which fields Gmail will accept for CSV importing. [1]
    • If you are having problems exporting without any contacts, try manually adding a single contact to create an export file.
    • If you are importing a CSV from another email service, you can skip to the import method .
    • If you want to create CSV file from scratch, a full list of the field headers can be found here .
  2. Open the CSV file with a spreadsheet or text program. The first line of the CSV will display the different categories for data entry (e.g. First Name, Last Name, email, etc.). Spreadsheets will separate these categories into different cells, while text editors will list these values on the first line separated by commas.
    • Microsoft Excel or Google Sheets will work for working with a spreadsheet, Notepad or TextEdit will work for working with a plaintext file. [2]
    Advertisement
  3. Enter information to the related cell or list values in order. If no value is needed for a certain area, the cell can be left blank, or in the case of a text file, filled with a “,”.
    • For example, a First Name, Last Name, Telephone, Email on a text file could be “John,,,john@email.com”.
    • Make sure to not to remove any fields or to include a comma in place of a blank field in the case of a text file. Gmail will scan for all fields, so missing fields will cause problems with the import.
  4. Changes to the CSV file must be saved before they can be imported into your Gmail account. [3]
    5. Advertisement
Part 2
Part 2 of 2:

Importing a CSV With a Web Browser

PDF download Download Article
  1. Navigate to Google Contacts in your web browser.
  2. Enter your username and password and click “Sign in”. You will be redirected to your Google Contacts page.
  3. This button is listed in the left panel and will open an import popup window. [4]
    • If you are using the new Contacts preview, this button will be labeled “Contacts”. The preview does not currently support importing contacts and you will be redirected to the old contacts interface and will need to redo this step.
  4. [5]
  5. Browse for the file you exported or created and click “Open”. The file will be added to the import popup window.
  6. After a few moments the import will complete and your contacts will appear listed on your Contacts page. [6]
    • If you find that your contacts did not import correctly (i.e. information imported into the wrong field), you may have removed a field or missed a comma on your CSV file. If you imported many contacts, it may be easier correct the CSV file, delete all imported contacts, and re-import, rather than editing each contact one by one.
    7. Advertisement

Community Q&A

Search
Add New Question
  • Question
    Can I import a CVS file from AOL mail?
    123 786
    Community Answer
    Yes, follow these steps: (1) Once logged into AOL Mail, click on "Contacts" on the left. (2) Click on the Tools menu and choose "Import." (3) Pick a CSV file on your computer. (4) Select an import format (CSV, TXT, or LDIF). (5) Click on the "Import" button.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 7 Helpful 4
  • Question
    How do I import my contacts to a specific group?
    Community Answer
    Each imported contact features a flag (group) that you can select and rename as desired.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 24 Helpful 19
  • Question
    How can I see the contacts that are imported to a Gmail account?
    WRM
    Community Answer
    A list of your contacts can be viewed at contacts.google.com or in the Contacts app of your mobile device (if it has been linked to your Gmail account).
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 10 Helpful 10
See more answers
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      • CSV files currently cannot be imported using mobile devices.
        Thanks
        Helpful 0 Not Helpful 0
      • CSV is likely to be one of the options when exporting your contacts from another email service. These files will be preformatted with your contacts’ information and ready to import into your Google account.
        Thanks
        Helpful 0 Not Helpful 0

      Tips from our Readers

      The advice in this section is based on the lived experiences of wikiHow readers like you. If you have a helpful tip you’d like to share on wikiHow, please submit it in the field below.
      • I found an odd solution to a bug. Google seems to want a specific format that I couldn't figure out, but this worked. Go to Google, select Contacts, and pick one contact to export. Copy and paste that format into the new file before you transfer multiple contacts and it should resolve any formatting issues.
      • To keep the "phone" field from showing up under the notes, try renaming the field to "mobile" in the CSV before you import it.
      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      Warnings

      • If you created your own CSV file, it is a good idea to double check that the information imported to the correct fields. For example, make sure names and emails appear in the correct space and are associated with the correct contacts.
        Thanks
        Helpful 0 Not Helpful 0
      Advertisement

      You Might Also Like

      Easily Switch from Yahoo Mail to Gmail: Transfer Mail & Contacts
      How to
      Switch from AOL to Gmail
      How to
      Find and Access Your Contacts List in Gmail
      How to
      Add Approved Senders to Gmail
      5 Easy Ways to Add New Contacts to Gmail
      How to
      Restore Google Contacts
      How to
      Edit, Delete, and Sync Your Gmail Contacts
      How to
      Create Additional Email Addresses in Gmail and Yahoo
      3 Quick Ways to Remove Added Contacts from Gmail
      7 Simple Steps to Export Your Contacts in Gmail
      How to
      Sync Contacts to Gmail
      How to
      Download Google Contacts on Android
      Advertisement

      Expert Interview

      Thanks for reading our article! If you’d like to learn more about online communication, check out our in-depth interview with Tyrone Showers .

      References

      1. ↑ https://support.google.com/contacts/answer/7199294?hl=en&co=GENIE.Platform%3DDesktop
      2. ↑ https://www.freecodecamp.org/news/what-is-a-csv-file-and-how-to-open-the-csv-file-format/
      3. ↑ https://support.google.com/contacts/answer/7199294?hl=en&co=GENIE.Platform%3DDesktop
      4. ↑ https://support.google.com/contacts/answer/1069522?hl=en&co=GENIE.Platform%3DDesktop#zippy=%2Cfrom-a-file
      5. ↑ https://support.google.com/contacts/answer/1069522?hl=en&co=GENIE.Platform%3DDesktop#zippy=%2Cfrom-a-file
      6. ↑ https://support.google.com/contacts/answer/1069522?hl=en&co=GENIE.Platform%3DDesktop#zippy=%2Cfrom-a-file

      About This Article

      Article Summary X

      1. Add addresses to your CSV file.
      2. Sign in to https://contacts.google.com .
      3. Click Import .
      4. Click Chose File .
      5. Select the .CSV file and click Open .
      6. Click Import .

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 939,938 times.

      Reader Success Stories

      • Dean Luedtke

        Aug 24, 2018

        "Besides covering the overall process very well, it answered my question about how all the categories have to be ..." more
      More reader stories Hide reader stories
      Share your story

      Is this article up to date?

      Advertisement