TheONbutton works extensively with Google Apps for our business and individual clients. One of the great features of Google Apps is the ability to import contacts in bulk using a CSV comma delimited file. This type of file can be created by using Microsoft Excel to structure and format the table as needed and then saving the file in CSV comma delimited format.
One piece of the puzzle which can be a little unclear is the field structure. So here is an example field structure that we use which covers most bases. I've set out the field names first followed by an example below with sample data.
I hope this helps, if you find it useful please let us know in the comments!
Google Contacts CSV example fields
- Given Name
- Family Name
- Name Prefix
- Phone 1 - Type
- Phone 1 - Value
- Phone 2 - Type
- Phone 2 - Value
- Phone 3 - Type
- Phone 3 - Value
- E-mail 1 - Type
- E-mail 1 - Value
- Address 1 - Type
- Address 1 - Street
- Address 1 - City
- Address 1 - Region
- Address 1 - Postal Code
- Notes
- Group Membership
Google Contacts import fields with sample data
- Given Name Neil
- Family Name Berman
- Name Prefix Mr
- Phone 1 - Type Work
- Phone 1 - Value 555-555-5555
- Phone 2 - Type Mobile
- Phone 2 - Value 555-555-5555
- Phone 3 - Type Home
- Phone 3 - Value 555-555-5555
- E-mail 1 - Type * Work
- E-mail 1 - Value Work email address
- Address 1 - Type Home
- Address 1 - Street 1001 TheONbutton St
- Address 1 - City TheONbutton City
- Address 1 - Region NC
- Address 1 - Postal Code 99999
- Notes Neil is into technology
- Group Membership * My Contacts ::: Name Of Contacts Group
Happy importing!
Neil Berman, Helper-in-Chief, TheONbutton
