Importing contact information from an exported csv file into Google gmail contacts

google-gmail-contact-import column headersWith windows 8 coming out I have a lot of clients that are having problems with the new outlook 2013. For some of them the simplest way to improve their email and contacts is to move them to Gmail and gmail contacts.

One problem that I ran into was exporting their old outlook contacts in a .csv file and importing it into google contacts and trying to figure out how to get the columns to match up. That process took a moment and a little more effort than I would have liked. So to help you out should you be dealing with this issue I have created a list of title heads that google uses when you export your contacts from them. Google-Gmail-CONTACTS import headers for columns. I had great success importing CSV contact files once I started using this list and placing the right headers on the columns of information.

I hope it helps you out.

** NOTE:  there is a limit to the amount of contacts you can add at one time.  In my research I found a couple of numbers 2500 to 1500.  I make the contact lists under 1500 and have multiple imports.
Google (from the notes I found) does not go over 10,000 contacts in your database.

Google-Gmail-CONTACTS import headers for columns.

Name

Given Name

Additional Name

Family Name

Yomi Name

Given Name Yomi

Additional Name Yomi

Family Name Yomi

Name Prefix

Name Suffix

Initials

Nickname

Short Name

Maiden Name

 

Birthday

Gender

Location

Billing Information

Directory Server

Mileage

Occupation

Hobby

Sensitivity

Priority

Subject

Notes

Group Membership

 

E-mail 1 – Type

E-mail 1 – Value

E-mail 2 – Type

E-mail 2 – Value

E-mail 3 – Type

E-mail 3 – Value

E-mail 4 – Type

E-mail 4 – Value

 

IM 1 – Type

IM 1 – Service

IM 1 – Value

 

Phone 1 – Type

Phone 1 – Value

Phone 2 – Type

Phone 2 – Value

Phone 3 – Type

Phone 3 – Value

Phone 4 – Type

Phone 4 – Value

Phone 5 – Type

Phone 5 – Value

 

Address 1 – Type

Address 1 – Formatted

Address 1 – Street

Address 1 – City

Address 1 – PO Box

Address 1 – Region

Address 1 – Postal Code

Address 1 – Country

Address 1 – Extended Address

Address 2 – Type

Address 2 – Formatted

Address 2 – Street

Address 2 – City

Address 2 – PO Box

Address 2 – Region

Address 2 – Postal Code

Address 2 – Country

Address 2 – Extended Address

Address 3 – Type

Address 3 – Formatted

Address 3 – Street

Address 3 – City

Address 3 – PO Box

Address 3 – Region

Address 3 – Postal Code

Address 3 – Country

Address 3 – Extended Address

 

Organization 1 – Type

Organization 1 – Name

Organization 1 – Yomi Name

Organization 1 – Title

Organization 1 – Department

Organization 1 – Symbol

Organization 1 – Location

Organization 1 – Job Description

 

Relation 1 – Type

Relation 1 – Value

Relation 2 – Type

Relation 2 – Value

 

Website 1 – Type

Website 1 – Value

Website 2 – Type

Website 2 – Value

 

Event 1 – Type

Event 1 – Value

Leave a Reply

Your email address will not be published. Required fields are marked *

For security, use of Google's reCAPTCHA service is required which is subject to the Google Privacy Policy and Terms of Use.

I agree to these terms.