How to clean up a messy HubSpot CRM

Signs your HubSpot needs a cleanup

• Sales leadership exports pipeline data to a spreadsheet because the dashboards don't match reality.

• The same person or company appears more than once, sometimes with different owners.

• Lifecycle stages say a contact is a lead long after they became a customer.

• There are several properties for the same thing, such as Industry, Industry (old) and Vertical.

• Nobody knows what half the workflows do, or whether it's safe to turn them off.

• Reps keep notes outside HubSpot because finding things inside it takes too long.

If two or more of these sound familiar, a structured cleanup will pay for itself in trust alone.

Step 1: Audit before you change anything

Export your contacts, companies and deals before touching anything, so every change can be checked against the original. Then measure the problems so you can fix them in order of impact:

• Records with no owner, and records owned by people who have left.

• Contacts with no associated company, and companies with no domain.

• Likely duplicates: companies with the same name, contacts with the same name at the same company.

• Properties that are rarely filled in, or that duplicate another property.

• Deals that are still open with a close date in the past.

• Workflows that are on but haven't enrolled anything in months.

Write the findings down. The audit becomes the plan, and it shows what changed once you're done.

Step 2: Merge duplicates

HubSpot already deduplicates contacts by email address and companies by domain, so most duplicates come from records without one: contacts with no email, companies with no domain, imports with slightly different spellings, or integrations that create records on their own.

• On Professional and Enterprise subscriptions, HubSpot's duplicate management tool suggests pairs to review and merge.

• For large volumes or rules HubSpot doesn't apply, a dedicated deduplication app or an export, clean and re-import is faster.

• Decide in advance which record wins: usually the older one, or the one with the most activity.

Merges can't be undone, so start with the pairs you're certain about and leave borderline cases for a second pass.

Step 3: Fix the properties

Properties are where most HubSpot portals drift. For each object:

1. List every custom property with its type and how often it's filled in.

2. Group properties that hold the same information and choose one to keep.

3. Copy values from the duplicates into the one you keep, with a workflow or an import.

4. Archive the duplicates once nothing uses them. HubSpot shows which workflows, forms, lists and reports use a property, so check that first.

5. Change free-text fields that should be consistent, such as country, industry or lead source, into dropdowns.

6. Add a one-line description to every property you keep, so the next person knows what it's for.

Step 4: Reset lifecycle stages and lead status

Lifecycle stage tells you where someone is in the buying journey, and it's the basis of most funnel reporting. Write a one-sentence definition and an entry rule for each stage you use, for example "Sales qualified lead: a sales rep has confirmed budget, need and timing on a call."

Then correct records that sit in the wrong stage. By default HubSpot only moves lifecycle stages forward through automation, so moving a record back means clearing the stage first and then setting the right one.

Keep lead status for the sales team's working state (new, attempting to contact, connected, qualified, unqualified), and don't let the two properties do each other's job.

Step 5: Fix ownership and associations

• Reassign records owned by deactivated users, using the same rules you use for new leads.

• Give every company an owner, then make sure contacts at that company go to the same person.

• Associate contacts with their companies. HubSpot can create and associate companies automatically from email domains, which fixes most of this going forward.

Step 6: Clean up pipelines and deals

• Close out deals with no recent activity and a close date long past, as closed lost with a reason.

• Check every deal stage has a clear exit rule, such as "demo held" or "proposal sent", rather than a feeling.

• Make the properties that matter required when a deal enters a stage, such as amount at proposal or close reason at closed lost.

Step 7: Tidy workflows, lists and views

Turn off workflows that haven't enrolled anything in months, after checking nothing depends on them. Name the ones you keep consistently, such as "Routing – inbound demo requests". Delete lists and saved views nobody uses, so the useful ones are easy to find.

Keep it clean afterwards

A cleanup lasts as long as the rules that protect it:

• Use dropdowns instead of free text wherever values should match.

• Make key properties required on forms and deal stages.

• Give one person the job of approving new properties, workflows and integrations.

• Spend half an hour each month on a check: new duplicates, unowned records and stale deals.

Want a second pair of eyes on your portal? Our CRM & RevOps service starts with exactly this kind of audit, and our guide to lead routing in HubSpot covers the ownership rules in more detail.