# How to clean a spreadsheet before importing into HubSpot

> HubSpot matches imported contacts on email and companies on domain, and misses the rest. How to clean a spreadsheet so the import doesn't add duplicates.

- URL: https://dedupe.ly/blog/guides/clean-spreadsheet-before-hubspot-import
- Section: blog
- Published: 2026-11-15
- Site index: https://dedupe.ly/llms.txt
- Any page: append `.md` to its URL for this plain-text form

---

Skip to content
[New Dedupely Intelligence Now on every paid plan, monthly or yearly.](https://dedupe.ly/ai-deduplication)
[Blog](https://dedupe.ly/blog)
[Guides](https://dedupe.ly/blog/guides)

## How to clean a spreadsheet before importing into HubSpot

By
[Gaby Salinas](https://www.linkedin.com/in/gbyslns)
Updated November 15, 2026
#
min read
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.
Example
Say a partner sends 900 leads with a "Company" and a "Website" column. 120 rows have no website, and 60 use the company's country site. Imported as is, HubSpot creates 120 companies without a domain, and 60 new companies next to ones the portal already has under the main domain.

### 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.
Pro tip
Run a 50-row test import and open five of the contacts it touched. Check the email, the associated company and the activity history. If an existing contact got a second record, fix the file before importing the rest.

### 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](https://v2.app.dedupe.ly/signup)

### 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.
Behind the article

### Gaby Salinas

Marketing Assistant at Dedupely
Gaby Salinas came to CRM data from marketing and advertising, so she looks at duplicates from two sides: the match and merge logic behind them, and what they do to the people using the CRM, like the rep who calls a customer twice, the admin who gets blamed and the cleanup nobody wants to start.
As Marketing Assistant at Dedupely, she follows how RevOps teams, end users, consultants and technical teams actually work with their data: the records they stop trusting, the workarounds they build and the moment they finally decide to clean up. What she finds shapes most of what Dedupely publishes.
[Connect with Gaby on LinkedIn](https://www.linkedin.com/in/gbyslns)

### Contact us

We’d be happy to help you get this set up.

#### Write us a message

We probably know the answer to your question already
help@dedupe.ly
Email copied to your clipboard!
[Book a Zoom Whether you’re getting started or getting intense. Get in touch! Book a zoom](https://meetings.dedupe.ly/meetings/gaby-salinas/dedupely-zoom-scheduler)

### Discover Related Blog Posts

Stay updated with our latest articles and insights.
- [Productivity Best tools to clean a CSV before a CRM import Spreadsheet apps, scripts and data-prep apps can clean a CSV before a CRM import. See what each one finds, what it deletes and where it stops. Gaby Salinas October 28, 2026](https://dedupe.ly/blog/productivity/tools-to-clean-csv-before-crm-import)
- [CRM Organization Should You Clean Spreadsheets Before Uploading or Clean Your CRM After? Cleaning the file first stops duplicate rows and triggered workflows. Cleaning the CRM after links new records to the accounts you already have. Gaby Salinas September 10, 2026](https://dedupe.ly/blog/crm-organization/clean-spreadsheets-before-uploading-or-clean-your-crm-after)
- [CRM Organization How event and purchased lists create CRM duplicates Event and purchased lists bring people already in your CRM, messy formats and overlapping sources. Clean each list first, then check your CRM after. Gaby Salinas October 28, 2026](https://dedupe.ly/blog/crm-organization/event-and-purchased-list-duplicates)

### Get started for free

20 free trial merges and as much free support as you need to get your duplicates under control.
[Try for free](https://v2.app.dedupe.ly/signup) [Talk to sales](https://meetings.dedupe.ly/meetings/gaby-salinas/talk-to-sales)
[Or sign up with Google](https://v2.app.dedupe.ly/signup/google)
Running CRM cleanup for clients? [See the Partner Program](https://dedupe.ly/become-a-partner)
