Google Contacts
Close Contacts6 fieldsHow to import Google Contacts data into Close
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 Close's single Name field, and maps email, phone, company, title, and the per-contact Notes column. Close models prospects as Leads with associated Contacts; this template creates the Contact records.
Field-by-field mapping
This is the complete column mapping from Google Contacts to Close. The left column is the header in your CSV export. The right column is the Close field it should map to.
| Google Contacts column | Close field | |
|---|---|---|
| Given Name + Family Name | Name*name Close uses a single Name field on the Contact, 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 | Phonephone TransformStandardized to international format (+1, +44, etc.) | |
| Organization 1 - Name | Companycompany | |
| Organization 1 - Title | Titletitle | |
| Notes | Descriptiondescription Google's per-contact notes land in Close's native Description field on the contact. The free text is preserved verbatim. |
Required by Close.
Columns we don't use
Your Google Contacts export includes 10 columns this template doesn't map. Each one below explains why, plus the workaround if you want the data in Close.
- E-mail 2 - Value, Phone 2 - Value
Close contacts have single primary email and phone fields. The first email and phone map to them; the second pair doesn't have a default home.
If you need it. Add custom email and phone fields on the Close Contact called Secondary Email and Mobile, then re-run this template to map them.
- Address 1 - Street, City, Region, Postal Code, Country
Close contacts don't have a default address block. Addresses are typically captured on the Lead in Close's data model.
If you need it. Add custom address fields on the Close Lead, or update the matching Lead records' addresses after import.
- Website 1 - Value
Close contacts don't have a default website field. Websites are typically tracked on the Lead.
If you need it. Add a custom URL field on the Close Contact called Website, or update the Lead's website field after the Contacts are associated.
- Group Membership, Birthday
Close doesn't have default fields for groups or birthday.
If you need it. Add custom fields on the Close Contact for Group Membership and Birthday, then re-run this template to map them.
Formatting and cleanup
Google Contacts exports rarely match the format Close expects. Fix these before you import.
- 1.Combines Given Name and Family Name into Close'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 Close's lowercase API names
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 Close.
Google Contacts to Close 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.
Does this create Leads or Contacts in Close?
This template creates Contact records. Close models prospects as Leads with associated Contacts. After import, use Close's bulk-edit tools to associate the Contacts to Leads.
Why do you combine Given Name and Family Name?
Close Contacts use a single Name field, not separate first/last. The template combines the two Google columns with a space so each Contact record displays correctly.
What if a contact has multiple phone numbers or emails?
Google exports each phone and email in numbered columns. This template maps Phone 1 and E-mail 1. See 'Columns we don't use' below for the second pair.
Will this create duplicate contacts in Close?
Close groups contacts under their Lead (company) record. Within a Lead, Close dedupes contacts on email; across different Leads the same email can appear twice. If a Lead with the same Company name already exists, new contacts attach to it, otherwise a new Lead is created. Spot-check or use Close's bulk-merge tools if you re-import the same export.
