Subscribe to our blog!

Enter your email address:

Delivered by FeedBurner

Angie's List Super Service Awards!
The On Button was awarded Angie's List Super Service Awards for 2013 & 2014! Thank you to our wonderful clients, it has been a pleasure helping you!
Technology problems solved...

Computer virus: "...very quick response to my call regarding a virus on my computer... professional and very knowledgable... we will be recommending TheONbutton to my friends." Lynn, Hillsborough NC

Apple Mac computer training: "Neil's prompt service and vast knowledge of computers has been a godsend. At this point I can't imagine life without him!" Margaret, Chapel Hill NC

Computer issue troubleshooting: "Excellent response to issues dealing with the home computer. All problems were solved and his explanations were easily understood." Jane, Durham NC

Laptop memory upgrade: "Punctual and very effective service! Highly recommend." Mike, Chapel Hill, NC

Computer performance tune-up: "I had the good fortune of finding TheONbutton. Neil was prompt, friendly, knowledgeable, fast, efficient, and affordable. I give him my highest recommendation!" Sean, Durham NC

Read more reviews of TheONbutton...

Our Facebook & Twitter pages
More testimonials

Wireless Internet connection problem: "Neil got our wireless router and modem going again that Time Warner and TP Link help desks had struggled with. We will definitely use the TheONbutton again should problems arise." Jeff, Durham NC

Computer virus: "...very quick response to my call regarding a virus on my computer...professional and very knowledgable...we will be recommending TheONbutton to my friends." Lynn, Hillsborough NC

Read more reviews of TheONbutton...

« How to watch Netflix in surround sound | Main | 4 ways to improve your website's Search Engine Optimization, or SEO »
Friday
Mar092012

Google Contacts CSV format import fields guide

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 

PrintView Printer Friendly Version

EmailEmail Article to Friend

References (118)

References allow you to track sources for this article, as well as articles that were written in response to this article.
  • Response
    [...]Google Contacts CSV format import fields guide - TheONbutton tech blog - Remote IT Support and Computer & Technology Help in Durham, Chapel Hill and Raleigh NC[...]
  • Response
    Response: power seo service
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Remote IT Support and Computer
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Remote IT Support and Computer
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Response: navigate here
    Excellent Web-site, Maintain the good work. Thanks a lot!
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Response: canciones
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Response: medical hcg drops
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Response: Room Ventilation
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Response: SEO Sydney
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Response: green coffee 800
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Response: local seo services
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Response: GsceNSlI
    Google Contacts CSV format import fieldsĀ guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Response: judi bola online
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Response: use our plumbers
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Response: use our plumbers
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Response: Sereno Review
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Response: outdoor dog bed
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Response: portable shelters
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Response: Vivexin Reviews
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Response: Ayur Skin Review
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Response: Ayur Skin
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    Google Contacts CSV format import fields guide - TheONbutton tech blog - Computer & Technology Help in Durham, Chapel Hill and Raleigh NC at home & work. HIPAA EMR installation, HIPAA auditing.
  • Response
    HC water indust cheap timberland shoes ry network following the cheap timberland roll top "air ten" "atmospheric pollution prevention action plan", China is also a major pollution prevention plan -- "water pollution prevention action cheap timberland sale plan" began full implementation, and puts forward concrete
  • Response
    Réseau de masse et d'avertissement 1, les droits d'auteur du droit d'a Pas Cher Timberland Bottes uteur, tous les éléments de réseau de m nike tn asse sont l'auteur ou les pages dans la déclaration.Sans l'autorisation écrite de réseau nike tn
  • Response
    Theory of machines by rs khurmi pdf
  • Response
    Response: Claudine Cryar
    theONbutton Tech Blog
  • Response
    Response: Seema Bucheli
    theONbutton Tech Blog
  • Response
  • Response
    Response: CRM software
    Google Contacts CSV format import fields
  • Response
    Response: Check This Out
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Response: youtu.be
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Response: fix Credit fast
    Google Contacts CSV format import fields
  • Response
  • Response
    Response: Chris Quintela
    Google Contacts CSV format import fields
  • Response
    Response: wigs
    Google Contacts CSV format import fields
  • Response
    Response: internet marketer
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Response: cheap nfl jerseys
    Google Contacts CSV format import fields
  • Response
    Response: human hair wigs
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Response: free download game
    Google Contacts CSV format import fields
  • Response
    Response: cheap wigs
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Response: judi Poker
    Google Contacts CSV format import fields
  • Response
    Response: male sex toys
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Response: cheap nfl jerseys
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Response: human hair wigs
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Response: wigs for women
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Response: Lms.Sfvmeet.com
    Google Contacts CSV format import fields
  • Response
    Response: Full Statement
    Google Contacts CSV format import fields
  • Response
    Response: www.tur.ba
    Google Contacts CSV format import fields
  • Response
    Response: B2bportfolio.net
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Response: cheap jerseys
    Google Contacts CSV format import fields
  • Response
    Response: cheap air max
    Google Contacts CSV format import fields
  • Response
    Response: gps fish finder
    Google Contacts CSV format import fields
  • Response
    Response: cheap sex toys
    Google Contacts CSV format import fields
  • Response
    Response: cheap nfl jerseys
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Response: iPhone x case
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Response: cheap nfl jerseys
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Response: Full File
    Google Contacts CSV format import fields
  • Response
    Response: cheap nfl jerseys
    Google Contacts CSV format import fields
  • Response
    theONbutton Tech Blog
  • Response
    Response: my net speed
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Response: quality Email List
    Google Contacts CSV format import fields
  • Response
    Response: had me going
    Google Contacts CSV format import fields
  • Response
    Google Contacts CSV format import fields
  • Response
    Response: cheap vibrators
    Google Contacts CSV format import fields
  • Response
    Response: cheap nfl jerseys
    Google Contacts CSV format import fields
  • Response
    Response: cheap nfl jerseys
    Google Contacts CSV format import fields

Reader Comments (5)

This doesn't work! Not your fault. Google doesn't import correctly.

June 12, 2012 | Unregistered CommenterJay

Hi
I tried this as well as the option to follow another path - export, check fields, arrange and validate data, then import. Unfortunately it still did not work. Google only creates the contact name with all the fields inserted into notes.
I am not sure how to possibly correct this!
thanks
Felicia

June 18, 2012 | Unregistered CommenterFelicia

Hello Jay & Felicia,

Thanks for your responses. Can you list the field names that you have used in your CSV files to do the import please?

I can also email you a template that I've used successfully if that would be helpful, as I've always experienced successful uploads as long as the fields and values are correctly populated.

Best regards,

Neil Berman

June 18, 2012 | Registered CommenterTheONbutton

Thanks! That was wonderful! i've searched those fields for a week!
In google there's not a line on this technical aspect.
Thank a lot!

December 1, 2012 | Unregistered CommenterBig Jack

The format has changed once again. The syntax is this now:

Name Given Name Additional Name Family Name Yomi Name Given Name Yomi Additional Name Yomi Family Name Yomi Name Prefix Name Suffix Initials Nickname Short Name Maiden Name Birthday Gender Location Billing Information Directory Server Mileage Occupation Hobby Sensitivity Priority Subject Notes Group Membership Custom Field 1 - Type Custom Field 1 - Value Custom Field 2 - Type Custom Field 2 - Value Custom Field 3 - Type Custom Field 3 - Value Custom Field 4 - Type Custom Field 4 - Value

Peace,
Steve

September 11, 2013 | Unregistered CommenterSteve Guzman

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>