How-to guide · HubSpot data hygiene

HubSpot duplicate cleanup: find, merge and stop duplicates

To clean up HubSpot duplicates, export a backup, then open Manage duplicates from the Contacts or Companies list and review each pair HubSpot suggests. Pick the record to keep and merge. Merges cannot be undone, so go in small batches. Then find what creates the duplicates, such as imports or integrations, and fix that source.

Or let us do it

CRM Clean-up

$1,290

10 working days. Signed off by a RevOps specialist, approved by you.

What we do

Before you merge anything

  1. Export a backup of contacts and companies with all properties. A merge is final.
  2. Agree what counts as a duplicate. Same email for contacts and same domain for companies is the safe start. Same name and company is a maybe, so review those by hand.
  3. Decide which record wins. Usually the one with the most activity or the right owner. HubSpot keeps the primary record’s values and only fills gaps from the other one.
  4. Tell the team. A merge keeps one owner and unenrolls the second record from its workflows.

Merge duplicates with the Manage duplicates tool

Needs a Professional or Enterprise subscription. HubSpot shows up to 10,000 pairs.

  1. Go to CRM, then Contacts (or Companies). If you see More in the menu, click it first.
  2. Click the three-dot icon in the upper right and select Manage duplicates.
  3. Select the rule you want to review.
  4. Click Review next to a pair.
  5. Choose the record to keep and the property values to keep, then click Merge and review next.
  6. If the pair is not a duplicate, click Reject and review next. You can undo a rejection within 14 days from View history.

With Data Hub Professional or Enterprise you can select many pairs, click Review, pick a Merge criteria such as Most recent engagement or Created first, and click Merge all. Do a small batch first and check it.

Merge two records by hand (any plan)

  1. Open the record you want to keep.
  2. In the left panel, click Actions and select Merge.
  3. Search for the duplicate and select it.
  4. Click the values you want to keep. The primary record’s values are selected by default.
  5. Click Merge. Activities can take up to 30 minutes to appear on the merged record.

What a merge keeps

Field After the merge
Record ID A new ID. The old ones are listed in the Merged IDs property
Property values The primary record’s, with gaps filled from the other record
Create date The oldest one
Lifecycle stage The one furthest down the funnel
Email or domain The primary one, plus the other as an additional email or domain
Activities and associations Both records’ combined
Workflows The primary stays enrolled, the other is unenrolled

How HubSpot spots duplicates

By default HubSpot compares contacts on first name, last name, email, IP country, phone, zip code and company name. It compares companies on domain, name, country, phone and industry. With Data Hub Professional or Enterprise you can add up to two custom rules per object.

Stop duplicates coming back

Merging without fixing the source means the count climbs again. Find the source first:

  1. Create a view of contacts created in the last 30 days and add the Record source and Record source detail columns.
  2. Open ten recent duplicates. The same source every time points to one cause.
  3. Import: without an email or Record ID column, every row becomes a new contact. Open the past import to see what it created.
  4. Form: a non-HubSpot form, or a page without the HubSpot tracking code, can create a new contact instead of updating one.
  5. Integration: check what the app matches on. Contacts should match by email and companies by domain.
  6. Workflow: look for a create record action with no check for an existing record.

Fix the source, then merge, then check the same view a week later.

Or let us do it

Fixed prices. AI prepares the work, a RevOps specialist signs it off, and nothing goes live until you approve it.

Fixed price, 10 working days

CRM Clean-up

$1,290

Up to 50,000 contact and company records

One record per person and company, key fields your reports can group by, and duplicates that stop coming back.

See what is included

Who does what

Work only moves right when the lane before it is done.

  1. AI

    AI agents audit and draft

    • Exports a backup and finds duplicate groups using the agreed rules
    • Drafts the merge list and the field clean-up mappings
  2. Specialist

    A RevOps specialist signs off every change

    • A RevOps specialist reviews every merge group and mapping before it runs
    • Runs the merges in small batches and checks the results after each one
  3. You

    You approve before anything goes live

    • Approve the merge rules and field mappings before anything changes
    • Spot-check a sample of merges and sign off on the final list

FAQ

Can I undo a merge in HubSpot?

No. HubSpot says it is not possible to unmerge records. To get an email address or domain back, you delete it from the merged record and create a new record with it. That is why you export a backup and merge in small batches.

Which plan do I need for the Manage duplicates tool?

Reviewing duplicate pairs one by one needs a Professional or Enterprise subscription. Bulk merging and custom duplicate rules need Data Hub Professional or Enterprise. On any plan, you can merge two records by hand from a record's Actions menu.

What does HubSpot keep when it merges two contacts?

The primary record's property values, unless a value is empty there. The oldest create date, the lifecycle stage furthest down the funnel, and all activities and associations from both. The second email address is kept as an additional email.

Why do duplicates come back after a clean-up?

Because the source is still running. Common sources are imports without an email or Record ID column and forms that are not HubSpot forms. Integrations that match on name and workflows that create records add more.

Will cleaning duplicates lower my HubSpot bill?

It can. HubSpot bills marketing contacts, so merged duplicates no longer count twice. Check which contacts are set as marketing contacts after the clean-up.

Everything in HubSpot data hygiene

Sound familiar?

Leads wait, and nobody trusts the pipeline.

  • New leads sit for hours before anyone replies
  • Duplicates come back after every import
  • Sales and marketing count different numbers for the same month

How we’re different

  • Fixed prices, published on every page
  • A written scope before you pay
  • You approve every change before it goes live

If the Growth Assessment finds fewer than 3 real gaps, you get a full refund.

Next step