With 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