Google Contacts
Copper People11 fieldsHow to import Google Contacts data into Copper
Google Contacts exports use verbose column names like 'E-mail 1 - Value' and 'Organization 1 - Name'. This template renames them, combines Given Name and Family Name into Copper's single name field, maps the full address block to Copper's address_* fields, and lands the per-contact Notes column in Copper's Details. Copper calls contacts People.
Field-by-field mapping
This is the complete column mapping from Google Contacts to Copper. The left column is the header in your CSV export. The right column is the Copper field it should map to.
| Google Contacts column | Copper field | |
|---|---|---|
| Given Name + Family Name | Name*name Copper uses a single name field on the People record, so we combine the two Google columns into one. TransformGiven Name and Family Name combined with a space | |
| E-mail 1 - Value | Emailemail TransformLowercased and trimmed | |
| Phone 1 - Value | Phone Numberphone_number TransformStandardized to international format (+1, +44, etc.) | |
| Organization 1 - Name | Company Namecompany_name | |
| Organization 1 - Title | Titletitle | |
| Address 1 - Street | Streetaddress_street | |
| Address 1 - City | Cityaddress_city | |
| Address 1 - Region | Stateaddress_state | |
| Address 1 - Postal Code | Postal Codeaddress_postal_code | |
| Address 1 - Country | Countryaddress_country | |
| Notes | Detailsdetails Google's per-contact notes land in Copper's native Details field on the Person. The free text is preserved verbatim. |
Required by Copper.
Columns we don't use
Your Google Contacts export includes 5 columns this template doesn't map. Each one below explains why, plus the workaround if you want the data in Copper.
- E-mail 2 - Value, Phone 2 - Value
Copper People records have single primary email and phone_number fields. The first email and phone map to them; the second pair doesn't have a default home.
If you need it. Add custom fields on the Copper Person called Secondary Email and Mobile, then re-run this template to map them.
- Website 1 - Value
Copper doesn't have a Website field on People. Websites sit on the Company record in Copper's data model.
If you need it. Update the matching Company record's website after import, or add a custom URL field on the Copper Person.
- Group Membership
Google contact labels and groups don't translate one-to-one with Copper. Copper uses Tags instead of labels.
If you need it. After import, apply Copper Tags matching your Google labels using Copper's bulk-edit tools.
- Birthday
Copper People records don't have a default Birthday field on the standard layout.
If you need it. Add a custom date field on the Copper Person called Birthday, then re-run this template to map it.
Formatting and cleanup
Google Contacts exports rarely match the format Copper expects. Fix these before you import.
- 1.Combines Given Name and Family Name into Copper's single name field
- 2.Lowercases and trims email addresses
- 3.Standardizes phone numbers to international format (+1, +44, etc.)
- 4.Renames verbose Google column headers to Copper's snake_case field names
- 5.Maps Google's Address 1 block to Copper's address_street, address_city, address_state, address_postal_code, address_country fields
Or skip the manual work
Operelio runs this cleanup and mapping for you. Upload your Google Contacts export and download a clean, import-ready file for Copper.
Google Contacts to Copper FAQ
How do I export contacts from Google?
Go to contacts.google.com, click 'Export' in the left sidebar, choose 'Google CSV' format, and download the file. Select Google CSV, not Outlook CSV.
Why do you combine Given Name and Family Name?
Copper People records use a single name field. The template combines the two Google columns with a space so each Person displays correctly.
What's a 'Person' in Copper?
Copper calls contacts People. The data model has People (individuals), Companies, Leads, and Opportunities. This template creates People records.
Will this create duplicate People in Copper?
Copper deduplicates People on email by default. People with matching emails update the existing record. New emails create new People.
What if a contact has multiple phone numbers or emails?
Google exports each phone and email in numbered columns. This template maps the first phone and first email. See 'Columns we don't use' below for the second pair.
