Google Contacts
Zoho Contacts13 fieldsHow to import Google Contacts data into Zoho Contacts
Google Contacts exports use verbose column names like 'E-mail 1 - Value' and 'Organization 1 - Name'. This template renames every one of them to the matching Zoho field and lands the per-contact Notes column in Zoho's Description. Google also exports a second email, a second phone, and a Group Membership column for contact labels. Those don't have a default Zoho home, so the section below shows you what to do with each one if you need it.
Field-by-field mapping
This is the complete column mapping from Google Contacts to Zoho Contacts. The left column is the header in your CSV export. The right column is the Zoho Contacts field it should map to.
| Google Contacts column | Zoho Contacts field | |
|---|---|---|
| Given Name | First NameFirst_Name | |
| Family Name | Last Name*Last_Name | |
| E-mail 1 - Value | Email TransformLowercased and trimmed | |
| Phone 1 - Value | Phone TransformStandardized to international format (+1, +44, etc.) | |
| Phone 2 - Value | Mobile Google's second phone column is treated as mobile. If your second phone is consistently a different type, remap after upload. TransformStandardized to international format (+1, +44, etc.) | |
| Organization 1 - Name | Account NameAccount_Name | |
| Organization 1 - Title | Title | |
| Address 1 - Street | Mailing StreetMailing_Street | |
| Address 1 - City | Mailing CityMailing_City | |
| Address 1 - Region | Mailing StateMailing_State | |
| Address 1 - Postal Code | Mailing ZipMailing_Zip | |
| Address 1 - Country | Mailing CountryMailing_Country | |
| Notes | Description Google's per-contact notes land in Zoho's native Description field on the contact. The free text is preserved verbatim. |
Required by Zoho Contacts.
Columns we don't use
Your Google Contacts export includes 4 columns this template doesn't map. Each one below explains why, plus the workaround if you want the data in Zoho Contacts.
- E-mail 2 - Value
Zoho contacts have a single primary Email field on the standard layout. The first email maps to it; the second one doesn't have a default home.
If you need it. Add a custom email field on the Zoho Contact called Secondary Email, then re-run this template to map it.
- Website 1 - Value
Zoho Contacts doesn't have a Website field on the standard layout. The Website field lives on Accounts in Zoho's data model.
If you need it. Add a custom URL field on the Zoho Contact called Website, or move the website to the Account record after import.
- Group Membership
Google contact labels and groups (e.g. 'Friends ::: Clients') don't translate one-to-one with Zoho. Zoho uses tags and views instead of labels.
If you need it. After import, apply Zoho tags matching your Google labels using a bulk-edit on the imported contacts.
- Birthday
Zoho Contacts doesn't have a built-in birthday field on the standard layout.
If you need it. Add a custom date field on the Zoho Contact called Birthday, then re-run this template to map it.
Formatting and cleanup
Google Contacts exports rarely match the format Zoho Contacts expects. Fix these before you import.
- 1.Lowercases and trims email addresses
- 2.Standardizes phone numbers to international format (+1, +44, etc.)
- 3.Renames verbose Google column headers (e.g. 'E-mail 1 - Value', 'Organization 1 - Name') to Zoho's underscored field names
- 4.Maps Phone 1 to the standard Phone field and Phone 2 to Mobile
- 5.Maps Organization 1 - Name to Zoho's Account_Name, which links contacts to a company record
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 Zoho Contacts.
Google Contacts to Zoho Contacts 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.
What if a contact has multiple phone numbers or emails?
Google exports each phone and email in separate numbered columns. This template maps Phone 1 to Zoho's Phone field and Phone 2 to Mobile, and maps E-mail 1 to Email. See 'Columns we don't use' below for the second email.
What happens if Family Name is blank?
Zoho requires a Last Name on every contact. Personal contacts in Google sometimes have only a Given Name. Add a placeholder like 'Unknown' in any blank Family Name cells before upload so every row imports.
Why does Organization 1 - Name go to Account_Name?
Zoho uses Account_Name on the contact to link the contact to a company record (Account). If the account doesn't exist yet, Zoho creates one during import.
Will this create duplicates in Zoho?
Zoho uses email as the duplicate-check field on contacts by default. Contacts with matching emails update the existing record instead of creating a duplicate. You can change this in Setup, Data Administration, Deduplication.
