Import & export layout
HubSpot contact import columns
HubSpot contact import using default property labels.
The HubSpot contacts layout has 14 columns; the required column is Email.
HubSpot imports contacts from CSV or Excel files through its import tool (Data Management → Data Integration → Import data). Column headers are matched to contact properties by name, so a file that already uses HubSpot's default property labels (First name, Last name, Email, Phone number, Company name, Job title, City, State/Region, Postal code, Country/Region) maps without manual work. The file needs a header row and a single sheet.
Email is the unique identifier for contacts. With “Create and update” selected, a row whose email matches an existing contact updates that contact instead of creating a new one, which makes repeat imports safe. Rows without an email can't be matched to existing contacts, so check the import summary for them.
Import rules to know
- Lifecycle stage accepts HubSpot's stage values (subscriber, lead, customer…), not free text.
- Companies can be created and associated automatically from the contact's email domain.
- Custom properties must exist in HubSpot before the import to be mapped.
Columns
| Column | Required | Example | Notes |
|---|---|---|---|
| First name | |||
| Last name | |||
| Yes | |||
| Phone number | |||
| Mobile phone number | |||
| Company name | |||
| Job title | |||
| Street address | |||
| City | |||
| State/Region | |||
| Postal code | |||
| Country/Region | |||
| Website URL | |||
| Lifecycle stage |