Intercom
HubSpot Contacts9 fieldsHow to import Intercom data into HubSpot
Intercom uses a single 'Name' field instead of separate first and last names. This template splits it into FirstName and LastName, then maps email, phone, company, title, and location to HubSpot properties. The Created at and Last seen timestamps are combined into the Notes property as 'Intercom created: <date> | Last seen: <date>' so reps see activity context anchored to each label.
Field-by-field mapping
This is the complete column mapping from Intercom to HubSpot. The left column is the header in your CSV export. The right column is the HubSpot field it should map to.
| Intercom column | HubSpot field | |
|---|---|---|
| Name | First Namefirstname First word extracted as first name. TransformSplit on first space | |
| Name | Last Namelastname Remaining words used as last name. Single-word names fall through to lastname. TransformSplit on first space | |
| Emailemail TransformLowercased and trimmed | ||
| Phone | Phone Numberphone TransformStandardized to international format (+1, +44, etc.) | |
| Company name | Company Namecompany | |
| Job title | Job Titlejobtitle | |
| City | Citycity | |
| Country | Country/Regioncountry Intercom exports a 2-letter country code (e.g. 'US'). HubSpot accepts the code but reports look cleaner with full country names. | |
| Created at, Last seen | Notesnotes Each value is prefixed with its label ('Intercom created: <date>', 'Last seen: <date>') and joined with ' | ', so reps see the source context in HubSpot's Notes property. TransformCombined with ' | ' separator and label prefixes |
Formatting and cleanup
Intercom exports rarely match the format HubSpot expects. Fix these before you import.
- 1.Splits the Name field into FirstName and LastName (first word becomes FirstName, the rest becomes LastName)
- 2.Lowercases and trims email addresses
- 3.Standardizes phone numbers to international format (+1, +44, etc.)
- 4.Combines Created at and Last seen into the Notes property as 'Intercom created: <date> | Last seen: <date>'
Or skip the manual work
Operelio runs this cleanup and mapping for you. Upload your Intercom export and download a clean, import-ready file for HubSpot.
Intercom to HubSpot FAQ
How do I export contacts from Intercom?
Go to Contacts in Intercom, apply any filters you need (e.g. by segment or tag), then click Export to CSV.
How does the name splitting work?
Intercom exports a single Name field. The template takes the first word as FirstName and everything after as LastName. For example, 'Jane Smith' becomes 'Jane' + 'Smith'.
Where do Created at and Last seen end up in HubSpot?
Both timestamps land in HubSpot's Notes property combined as 'Intercom created: <date> | Last seen: <date>', so reps see the activity context anchored to each label. HubSpot's createdate field is set by HubSpot on import.
What about conversation history and messages?
This template maps contact data only. Chat transcripts, conversation history, and message data don't export in the contacts CSV and won't transfer to HubSpot.
Are Intercom tags and segments preserved?
Tags and segment membership don't appear in the standard contact export. This template maps contact fields only. Recreate tags as HubSpot lists after import.
Will this create duplicates in HubSpot?
HubSpot uses email as the unique identifier. Contacts with matching emails update the existing record. New emails create new contacts.
