View as Markdown

TL;DR

  • HubSpot updates contacts that match on email and companies that match on domain.
  • Rows without an email or domain are created as new records.
  • Clean the email and domain columns first, then merge rows for the same person.
  • Check the file against a HubSpot export and import a sample first.
  • Dedupely cleans the list against your HubSpot export and gives you a clean CSV.

Before you import a spreadsheet into HubSpot, make sure every contact row has a clean email and every company row has a clean domain, merge the rows that belong to the same person or company, and compare the file with an export of your portal. HubSpot uses email and domain to decide whether a row updates an existing record, so those two columns do most of the work. A tool like Dedupely can clean the list and compare it with your HubSpot export before you import.

This guide is organized around those two columns: what HubSpot does with them, how to prepare them and what to do with the rows that have neither.

What HubSpot does with each row

The row has HubSpot
An email that's already in the portal Updates that contact with the mapped columns
A new email Creates a contact
No email Creates a contact, every time
A domain that's already in the portal Updates that company
No domain Creates a company, every time
A value that matches more than one record Shows an import error and skips the row

Deals, tickets and other objects match on Record ID or on a property you've set to require unique values. Without one, each row becomes a new record.

Prepare the email column

The email column decides whether a contact is new. Before the import:

  • Lowercase every address and remove spaces before and after it.
  • Find people listed twice with two addresses, like a work and a personal email. Keep one row, with the work address in the email column.
  • Separate shared inboxes like info@ or sales@. Several people at one company can't share one contact.
  • Decide what to do with rows that have no email. Each one becomes a new contact.

Prepare the domain column

The domain column decides whether a company is new:

  • Use the bare domain, like acme.com, without https://, www. or a page path.
  • Pick one domain per company when the list has several, like a country site and the main site.
  • Fill in missing domains from the contacts' work emails where you can.
  • Watch for personal email domains: gmail.com or outlook.com isn't a company.

Keep contacts and companies together

If the file has contacts and their companies in the same row, HubSpot can create both and associate them during the import. That only works if the company columns are clean too: a contact row pointing at "Acme Inc" with no domain gets a new company instead of the one already in your portal. Clean the company columns in the same pass as the contact columns.

Compare the file with your portal

Export your HubSpot contacts and companies, and check the new file against them on first name, last name and company. This finds the people who are already in HubSpot under a different email, which the import can't see. For those rows, either change the email to the one in HubSpot or take the row out and update the contact by hand.

How Dedupely prepares the email and domain columns for HubSpot

In Dedupely, you can upload the new list and your HubSpot export to the same spreadsheet, and the rows in both files are matched against each other, so you see which people and companies HubSpot already has. Company rows can be matched on website with Domain Root, which compares the core domain and ignores www and country variants, so a country site pairs with the main domain. Contacts can be matched on email, or on first and last name with company to catch a second address. Merge Rules decide which value wins in each column, and you export the result as a CSV for the HubSpot import. Spreadsheet rows don't count toward your record limit.

Clean your list before it reaches HubSpot

Email and domain decide the import

HubSpot keeps an import clean when every contact row has the right email and every company row has the right domain. Most of the work before an import is making those two columns reliable, then checking the file against what the portal already holds. A short test import tells you whether it worked before the whole list goes in.

Frequently asked questions

How do I clean a spreadsheet before importing it into HubSpot?

Clean the email and domain columns, merge rows for the same person or company, and compare the file with a HubSpot export. Then run a small test import.

Does HubSpot remove duplicates when you import?

It updates contacts that match on email and companies that match on domain. Rows without those values are created as new records.

What happens to rows without an email?

HubSpot creates a new contact for each one, even if the person is already in your portal.

Why did my import create duplicate companies?

The rows usually had no domain, or a different domain from the company already in HubSpot, like a country site.

Can one import create contacts and their companies?

Yes. If each row has the contact and company columns, HubSpot can create and associate both. Clean the domain column first so contacts land on existing companies.