Beantin webbkommunikation

Beantin Beta Blog

Experiments, investigations, and tests of web things
June 8, 2011

How to import into Google Contacts: CSV template

I’ve just migrated all my contact from my old Sony Ericsson C905 into my shiny and new Samsung Galaxy Ace. It took a bit of time, but I’ve just managed to do it pretty much perfectly. Here’s how…

  1. Use MyPhoneExplorer to Export contact from C905 to a CSV file
  2. Fill in one contact completely (with all the fields you expect to use) in Google Contacts
  3. Export that contact as a comma separated file (CSV format). This gives you a template with the current columns being used by Google Contacts (they vary reasonably often as i’ve understood)
  4. Copy your data column by column to the correct column in your 1-contact template file. It’s essential that you keep leave the names of the column headers untouched as well as the order of the columns.
  5. Fill in the correct type in the corresponding type column for each value column. This applies to telephone numbers, email addresses and each set of address fields. Values are: home, work, other (plus numerous others for telephone)
  6. Save your completed “template” CSV and then use the import function in Google Contacts.
  7. Hey presto, you should now have lots of nicely formatted contacts, with all the right data in the right fields.

At the time of writing, the columns and the column order for your CSV to import into Google Contacts is as follows:

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	
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	
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	
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	
Website 1 - Type	
Website 1 - Value
Related Posts Plugin for WordPress, Blogger...

Tags

Filed under Uncategorized.

Tags: , , , ,

  • Mike

    Thanks – very helpful especially the need to preserve order of columns.  I think that was what made the difference for me.  Mike

  • Richard Keeves

    Thanks, that is a clever tip to create a google contacts export file first to check the latest fields. Google’s instructions suck!  Thanks. 

  • Pingback: Export Facebook friends e-mail to Gmail | nls.pct Blog()

  • Me

    love it. made my life easier!

    cheers

  • Anonymous

    Thanks for doing this; it put me on the right track. Some of the fields worked for me and others did not. In case anyone else runs into similar problems, I have documented what worked for me including the column header value translations determined thru trial and error (I found the exported col header values are not necessarily the expected imported col header values – usually because spaces needed to be eliminated). It seems unlikely that Google would be sloppy with their naming convention, but, that’s what I determined. It could be a browser related issue as well (I use FireFox). Anyway, here’s my analysis in case it helps anyone:

    https://docs.google.com/spreadsheet/ccc?key=0ApBatN5rZtzidGIwOGNUQ21CTUFIZGNhZGFGWUlrWnc#gid=2

    • Excellent! It’s been 2 years since I last did this, and my research back then implied that the columns do vary quite often – which is kind of surprising… so in that sense, I’m not at all surprised that you had to tweak the solution to make it work! Thanks for sharing.

  • Thomas Kane

    Providing the csv would have been cool, But this is the best answer on the first page of Google so thank you for taking the time to do this.

  • really helpfull, it saved me a lot of time. why is it so often necessary to tweak software solutions !?
    Thanks for sharing!

Theme Beantin created by James Royal-Lawson. Privacy Policy