Pages

jeudi 31 mars 2011

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 tada!



(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.