Article


How can I add contacts to my G Suite e-mail?

Need G Suite? Sign up here.

To import contacts to G Suite, specifically Gmail's Contacts tab, a bulk import needs a specifically formatted CSV file. Here is an example of how it appears with column headers:

Name E-mail 1 - Value Phone 1 - Value
Name Goes Here E-mail Goes Here Phone Goes Here

In a CSV format, with all of the options available, it appears like this:

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,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 Name Goes Here,,,,,,,,,,,,,,,,,,,,,,,,,,,,E-mail Goes Here,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

Here are all of the column heading options:

  • 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
  • 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

Category

E-mail

Difficulty

Easy

Updated

updated over 1 year ago

Was this helpful?
|
2017-10-04

Twitter   Facebook   Instagram