Skip to content
fileshape

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

ColumnRequiredExampleNotes
First name
Last name
EmailYes
Phone number
Mobile phone number
Company name
Job title
Street address
City
State/Region
Postal code
Country/Region
Website URL
Lifecycle stage

Guides