How to solve problems of importing to Google Contacts

Importing contacts into Google Contacts should be pretty straight forward. In theory, all you need do is import your .CSV file containing your contact list into Google Contacts.

However, sometimes the import fails and it’s hard to know why.

The issue is often that the .CSV you are uploading is formatted incorrectly and Google rejects the data in the file.

One way to solve the problems of importing files into Google Contacts is to make sure that you are using the correct CSV file format that Google Contacts will accept.

Getting access to this format is as easy as downloading a Google Contact “template” CSV file. Then all you need do is copy/paste your data into the correct columns and upload the updated CSV back into Google Contacts.

Follow these steps:

  1. Download a correctly formatted Google Contact CSV file. You can download one here or create your own (see bottom of this post).
  2. Copy / paste your Name and Email contact data into the correct columns (B, D and AC)
  3. Save the updates to the Google.csv file.
  4. Upload the Google.csv file to your Google Contacts (See Importing Google Contacts)

google csv


We have created a Google.CSV file for you or you can create your own like this:

export contact

Phil Hill - Founder & CEO

Phil is a successful serial internet entrepreneur with a passion to fix problems.

  • jbal

    What a hassle, you telling us that mailchimp, send grid and others can smartly import contats and gmail still cant?

  • FranE

    Thanks for this great explanation! Impossible to find the answer in any of Google’s support sites.