Skip to content
Book a build

Where do I get a HubSpot import template for contacts and companies?

HubSpot publishes a sample import file for each standard object, including contacts, companies, deals and tickets, in XLSX or CSV, plus multi-object templates such as contacts and companies in one file. You can also generate an example import template from inside the import tool, which includes the required properties for the objects you select. Contacts need Email, companies need Name or Company domain name.

On this page

What HubSpot supports natively

HubSpot’s sample import files article offers templates in three groups:

GroupTemplates
One object (XLSX or CSV)Contacts, Companies, Deals, Tickets, Products, Tasks, Calls
Several objects in one fileContacts and companies; contacts and companies with association labels; contacts and tickets; companies and deals; companies and notes; companies, deals and notes; and more
Several objects in two filesCompanies and contacts linked by company name; deals and companies with association labels; deals and line items; calls and contacts
Same-object associations (CSV)Contact-to-contact, company-to-company, deal-to-deal, ticket-to-ticket

For anything not listed, the import tool can generate an example file for the objects you choose, with their required properties.

Required columns to create records:

ObjectRequired
ContactsEmail
CompaniesName or Company domain name
DealsDeal name, Pipeline and Deal stage (the stage must belong to that pipeline)

Identifiers to update existing records: Record ID for any object, Email for contacts, Company domain name for companies, or a custom property that requires unique values.

How to build a HubSpot import template that works first time

  1. Start from the official sample for your objects, or generate one in the import tool.
  2. Match headers to property labels or internal names so columns map automatically.
  3. Add an identifier column (Record ID, Email or domain) if any row updates an existing record. Without it, you get duplicates.
  4. Create missing properties first. You can create one per unmapped column during the import, but a long list is quicker done beforehand; see bulk creating properties.
  5. Check option values against each dropdown’s internal values.
  6. Use a consistent date format such as year-month-day. HubSpot accepts several orders and separators.
  7. Test with ten rows, check the records, then import the rest.

Common mistakes

  • Two companies, one domain. Custom unique properties don’t enforce uniqueness for company domains, so duplicate domains can be imported.
  • Wrong pipeline stage. A deal stage from another pipeline fails the row.
  • Associations without identifiers. To link records in one file, each row needs an identifier for both. See importing contacts and companies together.

Where Jetstack AI fits

Jetstack AI doesn’t import records; in Projects, importing or migrating data is listed as a step you do yourself. What it can do is build the structure an import depends on, such as properties with their options, custom objects and association labels, before you load the file. See what Projects can build.

Sources

Checked October 29, 2026. HubSpot changes its products often; tell us at team@jetstack.ai if something here is out of date.

HubSpot admin

Turn the brief into approved HubSpot assets.

Projects plans the build against the client portal, generates the assets and deploys them only after you approve.

Explore Projects

HubSpot admin

Related questions.

Where do I get a HubSpot import template for contacts and companies?

HubSpot publishes a sample import file for each standard object, including contacts, companies, deals and tickets, in XLSX or CSV, plus multi-object templates such as contacts and companies in one file. You can also generate an example import template from inside the import tool, which includes the required properties for the objects you select. Contacts need Email, companies need Name or Company domain name.

What file types can I import into HubSpot?

CSV, XLSX or XLS, with one sheet, a header row and fewer than 1,000 columns. Use UTF-8 encoding for non-English characters.

How big can an import file be?

On paid subscriptions, up to 512 MB and 1,048,576 rows per file, with up to 500 imports and 10,000,000 rows a day. Free tools allow 20 MB files, 50 imports and 500,000 rows a day.

Do dropdown values have to match exactly?

They must match either the label or the internal value of an existing option. For multiple checkboxes, separate values with semicolons and no spaces.