Importing into Google Contacts from a CSV
I’ve spent far too much time trying to import my phonebook into Google Contacts from a .csv file, for my new G1. Google have done an uncharacteristically poor job of their import function (at least as far as plain CSV files go, I haven’t tried the other options). I eventually worked out the format by creating a dummy contact and exporting it to CSV. I’m posting it here because I couldn’t find a decent description from searching the web.
Here are the columns from my exported contact:
- Section 1 – Description
- Section 1 – Email
- Section 1 – IM
- Section 1 – Phone
- Section 1 – Mobile
- Section 1 – Pager
- Section 1 – Fax
- Section 1 – Company
- Section 1 – Title
- Section 1 – Other
- Section 1 – Address
And similar fields for Section 2. The thing I didn’t immediately realise is that each section corresponds to different types of contacts. Section 1 is Work, Section 2 is Home/Personal. I presume section 3 would be Other but I didn’t have any data in there. More importantly, the name of the section has to be in the description field, so Section 1 – Description has to contain the string “Work”, Section 2 – Description “Personal” (not “Home”!), etc. Once you know that it’s all quite easy, but it’s not obvious at all.
So an example line would be:
<name>,<primary email>,,Work,,,<work #>,,,,,,,,Personal,,,<home #>,<mobile #>,,,,,,
Surely Google can get an intern or someone to improve the usability of this, or at least improve the documentation!