---
title: "HubSpot import template: sample files for every object"
description: "Where to get a HubSpot import template: official sample files for contacts, companies and deals, generating one in the import tool, and the columns it needs."
url: "https://jetstack.ai/answers/hubspot-import-template/"
---

# 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.

![](https://jetstack.ai/images/authors/aditya-kumar.webp)

By [Aditya Kumar](https://jetstack.ai/authors/aditya-kumar/) Founder, Jetstack AI

Updated October 29, 2026

On this page

## What HubSpot supports natively

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

| Group                              | Templates                                                                                                                                                                    |
| ---------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **One object** (XLSX or CSV)       | Contacts, Companies, Deals, Tickets, Products, Tasks, Calls                                                                                                                  |
| **Several objects in one file**    | Contacts 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 files**   | Companies 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:**

| Object    | Required                                                                    |
| --------- | --------------------------------------------------------------------------- |
| Contacts  | Email                                                                       |
| Companies | Name or Company domain name                                                 |
| Deals     | Deal 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](https://jetstack.ai/answers/bulk-create-hubspot-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](https://jetstack.ai/answers/import-contacts-companies-together-hubspot).

## Where Jetstack AI fits

Jetstack AI doesn’t import records; in [Projects](https://jetstack.ai/build), 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](https://jetstack.ai/docs/projects/capabilities).

## Sources

- [Sample import files (HubSpot Knowledge Base)](https://knowledge.hubspot.com/import-and-export/sample-import-files)
- [Set up your import file (HubSpot Knowledge Base)](https://knowledge.hubspot.com/import-and-export/set-up-your-import-file)
- [Projects capabilities (Jetstack AI documentation)](https://jetstack.ai/docs/projects/capabilities)

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

![Aditya Kumar](https://jetstack.ai/images/authors/aditya-kumar.webp)

About the author

[Aditya Kumar](https://jetstack.ai/authors/aditya-kumar/)

Founder, Jetstack AI

Aditya Kumar is the founder of Jetstack AI, the AI platform HubSpot partners and RevOps teams use to audit portals, build implementations and reuse their best setups across portals. He writes about HubSpot architecture, automation and AI from the work of building it.

[More from Aditya](https://jetstack.ai/authors/aditya-kumar/) [LinkedIn](https://www.linkedin.com/in/aditya-ambrstack/)

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](https://jetstack.ai/build)

On this page

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.
