Useful CSV template for importing into Google Contacts

I found the instructions provided by Google on how to create a custom CSV file for importing your contacts into Google Contacts to be lacking to say the least! To figure out what column headings Google Contacts accepts for import, I created a test group and added an example contact with all available fields filled in. Since Google Contacts doesn't let you export individual contacts, I then selected the test group containing the example contact for export in Google CSV format.

When I opened the exported Google CSV file, I discovered many new column headings that map to custom fields. I deleted all of these columns since what I want to know is what column headings map to actual fields not custom fields. I also discovered how Google formates types like Home, Work, Other, etc.

Column headings for the street, city, region, postal code, country did't work. At least I couldn't figure out how to import any text entered in those columns. I could only get the Formatted heading to import address data.

To get started, download the Google Contacts CSV import template.