Import & export layout
Google Contacts CSV format
Google Contacts CSV (import/export).
The Google Contacts layout has 16 columns.
Google Contacts exports a “Google CSV” in which repeating fields are numbered. Each contact can have several emails, phones and addresses, so the file contains column groups like E-mail 1 - Label and E-mail 1 - Value, E-mail 2 - Label and so on, plus name fields, organization fields, notes, birthday and a Labels column listing the contact's groups.
The same layout works for importing back into Google Contacts, which makes it a convenient exchange format between Google accounts. Most CRMs expect one email and one phone per contact instead, so converting usually means choosing which numbered value to keep, normally the first.
Import rules to know
- Export from More actions → Export; the Google CSV option is also the format for re-importing into another Google account.
- The number of columns grows with the contact that has the most values.
- Choose Google CSV, not vCard or Outlook CSV, when exporting for conversion.
Columns
| Column | Required | Example | Notes |
|---|---|---|---|
| First Name | |||
| Middle Name | |||
| Last Name | |||
| Nickname | |||
| Birthday | |||
| Notes | |||
| E-mail 1 - Label | |||
| E-mail 1 - Value | |||
| Phone 1 - Label | |||
| Phone 1 - Value | |||
| Address 1 - Formatted | |||
| Address 1 - City | |||
| Address 1 - Country | |||
| Organization Name | |||
| Organization Title | |||
| Labels |