Google Contacts’ CSV syntax

Google gives only sparse information about Google contacts’ syntax (I need it for converting various Outlook files). And I did not find any reliable information on the web about its syntax. So, I braced myself and “reversed-engineered” it. Below is the result. Since Blogger doesn’t allow inline overflow, you suggest you take a look at the spreadsheet version.

Name                 ,Given Name,Additional Name,Family Name   ,Yomi Name,Given Name Yomi,Additional Name Yomi,Family Name Yomi,Name Prefix   ,Name Suffix   ,Initiales,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,Phone 1 - Type ,Phone 1 - Value,Phone 2 - Type    ,Phone 2 - Value                   ,Phone 3 - Type    ,Phone 3 - Value   ,Phone 4 - Type         ,Phone 4 - 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  ,Custom Field 1 - Type,Custom Field 1 - Value
Sir Wile E. Coyote Sr,Wile      ,Ethelbert      ,Coyote        ,         ,               ,                    ,                ,Sir           ,Sr            ,W.E.C.   ,The Coyote,Coyote    ,           ,1949-09-16,M     ,          ,                 ,                ,       ,          ,     ,           ,        ,       ,Notes,* My Contacts ::: Other group,Home           ,mail@perso.org         ,* Work         ,mail@pro.com    ,Home           ,01 22 22 22 22 ,Mobile            ,06 55 55 55 55                    ,Work              ,01 55 55 55 55    ,Work Fax               ,01 55 55 55 56     ,Work            ,Route 66 - Sonoran Desert - Arizona,Route 66          ,Sonoran Desert  ,                  ,Arizona           ,                  ,U.S.A                   ,Shout “BEEP-BEEP” to find him,                     ,ACME inc.            ,                          ,Honorary member       ,User experience            ,                       ,Delaware                 ,Involuntary beta-tester         ,Work            ,http://www.acme.com
And voilà!

(please note the lack of picture is voluntary: a CSV cannot embed a picture of if it can, I don’t know how to do it. Also, the Etherlbert middle name does not appear on the vCard, but it is here—I checked) Please share and correct. Update: a useful hint is to discard the Name and whatever Formatted columns. Not just to leave them blank, but to delete them. Why so? Because if you plan these composite entries to be just the sum of the child "columns" ("Name" as just a combination of Given Name, Additional Name Family Name and "Address Formatted" to be just combination Street, Zip Code and so on), then it is better to remove them. Upon importation, they will be dynamically created anyway. Beware: if you just leave them blank, they won't be dynamically filed in, they will just remain blank and so you will have empty Names and Formatted Addresses. In my Will E. Coyote, I intentionally gave a different Name than the combination of Given, Additional and Family (Name has E. where Additional is Ethelbert). This is for education only; in real life, 99% of time, you'll just want Names and Formatted to be a simple addition of their respective "subcolumns".

flattr this!