Google gives only sparse infor­ma­tion about Google contacts’ syn­tax (I need it for conver­ting various Out­look files). And I did not find any reliable infor­ma­tion on the web about its...

Google gives only sparse infor­ma­tion about Google contacts’ syn­tax (I need it for conver­ting various Out­look files). And I did not find any reliable infor­ma­tion on the web about its syn­tax. So, I bra­ced myself and “reversed-engineered” it. Below is the result. Since Blog­ger doesn’t allow inline over­flow, you sug­gest you take a look at the spread­sheet ver­sion.

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 pic­ture is volun­tary: a CSV can­not embed a pic­ture of if it can, I don’t know how to do it. Also, the Etherl­bert middle name does not appear on the vCard, but it is here—I che­cked) Please share and cor­rect. Update: a use­ful hint is to dis­card the Name and whatever For­mat­ted columns. Not just to leave them blank, but to delete them. Why so? Because if you plan these com­po­site entries to be just the sum of the child « columns » (« Name » as just a com­bi­na­tion of Given Name, Addi­tio­nal Name Family Name and « Address For­mat­ted » to be just com­bi­na­tion Street, Zip Code and so on), then it is bet­ter to remove them. Upon impor­ta­tion, they will be dyna­mi­cally crea­ted any­way. Beware: if you just leave them blank, they won’t be dyna­mi­cally filed in, they will just remain blank and so you will have empty Names and For­mat­ted Addresses. In my Will E. Coyote, I inten­tio­nally gave a dif­ferent Name than the com­bi­na­tion of Given, Addi­tio­nal and Family (Name has E. where Addi­tio­nal is Ethel­bert). This is for edu­ca­tion only; in real life, 99% of time, you’ll just want Names and For­mat­ted to be a simple addi­tion of their res­pec­tive « subcolumns ».