HubSpot
Zoho Contacts11 fieldsHow to import HubSpot data into Zoho Contacts
Moving from HubSpot to Zoho? This template maps name, email, phone, company, title, and the full address to Zoho's underscored API names. Zoho requires Last Name on every contact, and HubSpot doesn't require it, so some rows may have blanks. The Before you start section below explains how to handle it.
Field-by-field mapping
This is the complete column mapping from HubSpot 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.
Before you start
This template's destination has a required field that needs attention before upload. You can still use this template. The steps below tell you what to add and where.
- Last NameLast_Name
Zoho requires Last Name on every contact. HubSpot doesn't require it, so contacts often have blanks, especially older records or those imported from forms.
What to do. Before upload, fill any blank Last Name cells with a placeholder like 'Unknown' so every row passes Zoho's import validation.
| HubSpot column | Zoho Contacts field | |
|---|---|---|
| First Name | First NameFirst_Name | |
| Last Name | Last Name*Last_Name | |
| Email TransformLowercased and trimmed | ||
| Phone Number | Phone TransformStandardized to international format (+1, +44, etc.) | |
| Company Name | Account NameAccount_Name | |
| Job Title | Title | |
| Street Address | Mailing StreetMailing_Street | |
| City | Mailing CityMailing_City | |
| State/Region | Mailing StateMailing_State | |
| Postal Code | Mailing ZipMailing_Zip | |
| Country/Region | Mailing CountryMailing_Country |
Required by Zoho Contacts.
Columns we don't use
Your HubSpot export includes 3 columns this template doesn't map. Each one below explains why, plus the workaround if you want the data in Zoho Contacts.
- Website URL
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. Update the matching Zoho Account's website after import, or add a custom URL field on the Zoho Contact called Website.
- Lifecycle Stage, Lead Status
Zoho Contacts doesn't have Lifecycle Stage or Lead Status fields by default. These concepts typically live on Zoho Leads, not Contacts.
If you need it. Add custom single-select fields on the Zoho Contact with values matching your HubSpot data, or consider HubSpot Contacts to Zoho Leads if you want the lifecycle data on a Lead record.
Formatting and cleanup
HubSpot 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 HubSpot columns to Zoho's underscored API names (First_Name, Last_Name, Account_Name, Mailing_*)
- 4.Maps HubSpot's Company Name to Zoho's Account_Name, which links contacts to a company record
- 5.Maps HubSpot's address block to Zoho's Mailing address fields
Or skip the manual work
Operelio runs this cleanup and mapping for you. Upload your HubSpot export and download a clean, import-ready file for Zoho Contacts.
HubSpot to Zoho Contacts FAQ
How do I export contacts from HubSpot?
In HubSpot, go to Contacts, click the Actions menu, choose Export, select 'All properties' and CSV format, then download. HubSpot will email you the file when it's ready.
Zoho requires Last Name. What if my HubSpot contacts have blanks?
The 'Before you start' banner above explains the workaround: fill blank Last Name cells with 'Unknown' before upload so every row passes Zoho's import validation.
Why does Company 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.
Should I use this template or HubSpot Contacts to Zoho Leads?
Use this template if your HubSpot contacts are existing relationships (customers, prospects you've engaged). Use Zoho Leads if you're treating the HubSpot data as net-new leads that need qualification before becoming Contacts.
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. You can change this in Setup, Data Administration, Deduplication.
