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
$1,290
10 working days. Signed off by a RevOps specialist, approved by you.
What we doBefore you merge anything
- Export a backup of contacts and companies with all properties. A merge is final.
- 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.
- 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.
- 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.
- Go to CRM, then Contacts (or Companies). If you see More in the menu, click it first.
- Click the three-dot icon in the upper right and select Manage duplicates.
- Select the rule you want to review.
- Click Review next to a pair.
- Choose the record to keep and the property values to keep, then click Merge and review next.
- 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)
- Open the record you want to keep.
- In the left panel, click Actions and select Merge.
- Search for the duplicate and select it.
- Click the values you want to keep. The primary record’s values are selected by default.
- 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:
- Create a view of contacts created in the last 30 days and add the Record source and Record source detail columns.
- Open ten recent duplicates. The same source every time points to one cause.
- Import: without an email or Record ID column, every row becomes a new contact. Open the past import to see what it created.
- Form: a non-HubSpot form, or a page without the HubSpot tracking code, can create a new contact instead of updating one.
- Integration: check what the app matches on. Contacts should match by email and companies by domain.
- 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 includedWho does what
Work only moves right when the lane before it is done.
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
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
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.
Sources
HubSpot changes menus often: if a step looks different, tell us and we will update it.
More on HubSpot data hygiene
How-to guide
HubSpot audit checklist: audit your portal yourself
A HubSpot audit checks eight areas: properties, data quality, pipelines, lifecycle stages, workflows, forms and tracking, integrations, and users.
Free checklist
HubSpot portal health checklist (printable)
This free HubSpot portal health checklist has 40 checks in eight areas, from duplicates and owners to workflows, consent and your email sending domain.
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
$790
If the Growth Assessment finds fewer than 3 real gaps, you get a full refund.
Next step
In writing
Describe your problem
Tell us what is not working. You get what we would do first and its fixed price, in writing.
$1,290
CRM Clean-up
One record per person and company, key fields your reports can group by, and duplicates that stop coming back.