Connect to 385M+ businesses worldwide with our real-time company data API. Try the company lookup API, 150 calls free.

How-to guide · CRM

CRM Data Cleansing: How to Clean CRM Data (2026)

Every CRM gets dirty. Reps add the same customer twice, imports bring their own spellings, companies move, merge and close while their records sit untouched. After a few years nobody trusts the numbers, and the CRM turns into a place where sales does not look. CRM data cleansing is how you get it back. This guide walks through it in eight steps, with the settings and tools in HubSpot, Salesforce, Pipedrive and Zoho, and the one step most guides leave out: checking your companies against the outside world.

1. What CRM data cleansing is, and why CRMs decay

CRM data cleansing, also called CRM data cleaning or CRM data hygiene, is the work of finding and fixing bad records in your CRM. It is different from CRM enrichment, which adds what is missing: cleansing fixes what is there. In practice you do both, cleansing first.

CRMs decay for two reasons. The first is internal: people. Every form, import and sales rep adds records in its own way, and nobody checks whether the company already exists. The second is external: the world moves on. Companies relocate, change their name, merge into a group or stop trading, and nothing in your CRM tells you.

Where dirty CRM data comes from
ProblemTypical causeVisible from inside the CRM?
Duplicate companiesForms, imports and reps creating the same accountPartly, with duplicate tools
Inconsistent formatsFree-text fields, no picklistsYes
Empty fieldsShort forms, quick manual entriesYes
Closed or merged companiesBankruptcy, dissolution, acquisitionNo
Moved companiesNew office, new registered addressNo

The last two rows are why cleaning only with the tools inside your CRM always leaves something behind.

2. Measure before you clean

Pull five numbers before you touch anything. They tell you where to start and, later, whether it worked.

  1. Duplicate rate: the share of companies that exist more than once. Your CRM's duplicate tool gives a first estimate.
  2. Complete records: the share of companies with every required field filled (country, industry, size, owner).
  3. Stale records: companies with no activity, deal or update in two years.
  4. Bounce rate: from your email tool, as a proxy for contact decay.
  5. Unmatched companies: the share you cannot link to a registered company. You only know this after step 5, so note it then.

3. Back up and agree the rules

Export a full backup of companies, contacts and deals with their IDs. Then write down, with sales and marketing, three rules that every cleaning decision follows:

  • Which record survives a merge: usually the one with the most activity or the oldest deal, so reporting does not break.
  • What counts as the same company: the same registration number. Two subsidiaries of one group are two companies.
  • What happens to dead records: archive rather than delete, so history and attribution survive.

4. Standardise formats

Formats first, because every later step matches on them. Fix these once and lock them with picklists and validation rules:

Formats to standardise
FieldStandard
CountryISO 3166 code or a fixed picklist, never free text
Company nameLegal name in one field, trading name in another
Legal formOne spelling per form (B.V., GmbH, Ltd), or a separate field
PhoneInternational format with country code (+31 20 ...)
WebsiteDomain only, lowercase, no https:// or www.
IndustryOne code system (SIC or NACE) from a picklist

5. Find and merge duplicates on the registration number

Duplicate tools compare names and domains. That catches "Heineken" and "HEINEKEN N.V.", but it also merges two different companies with similar names, and it misses the duplicate that was entered under a trading name. The reliable key is the number the register gave the company.

  1. Match every company to the register

    Send name plus country, or the website domain, and store the registration number that comes back. Our docs on matching a list of companies show what to send per country.
  2. Group records with the same number

    Every group of two or more is a set of duplicates. No fuzzy threshold to tune, no false merges between namesakes.
  3. Merge by your survivor rule

    Keep the surviving record from step 3 and merge the rest into it, with contacts, deals and activities.
  4. Link groups, do not merge them

    Subsidiaries keep their own record and get a parent association. Merging a group into one account breaks territories and invoicing.

6. Remove closed, merged and moved companies

With every company matched, the register tells you what your CRM cannot: whether the company still exists, and where.

  • Dissolved or bankrupt: archive the company and its open deals, and stop sequences to its contacts.
  • Merged into another company: move the history to the surviving entity, often already in your CRM as a separate account.
  • Moved: update the registered address and check whether the territory owner changes.
  • Renamed: update the legal name, keep the old name as an alias so search still finds it.

Our register data covers 377M+ companies in 190+ countries, with the status of each, so one check covers a CRM spread across many markets.

7. Cleaning in HubSpot, Salesforce, Pipedrive and Zoho

Every CRM has built-in help for formats and obvious duplicates. Use it for steps 4 and 5, and add the register check for step 6.

Built-in cleaning tools per CRM
CRMBuilt inAdd for the rest
HubSpotDuplicate management for companies and contacts; property validation; data quality tools in Operations HubThe CompanyData Enrichment app to match companies to the register
SalesforceDuplicate and matching rules; validation rules; Data Loader for bulk updatesAn export cleaned against the register, loaded back on the Salesforce ID
PipedriveMerge duplicates for organisations and people; required fieldsAn export cleaned against the register, or the API through Zapier or Make
Zoho CRMDeduplication on chosen fields; validation rulesAn export cleaned against the register, or the API through Zoho Flow

Salesforce data hygiene deserves one extra note: matching rules run on records as they are saved, so a fuzzy rule set too loose blocks reps from creating real new accounts. Matching on a registration number field avoids that.

8. Keep it clean: CRM data hygiene rules

A cleaned CRM stays clean for months, not years, unless you change how records get in. Five rules do most of the work:

  1. A matching key on every company: the registration number, so every import and integration can check for an existing record.
  2. Enrich on creation: new companies are matched and filled the moment they are created. See CRM enrichment.
  3. Required fields with picklists: country, industry and owner cannot be skipped or typed freely.
  4. A re-check two to four times a year: the whole base against the register, for status and address changes.
  5. One owner: someone who decides on fields and rules, and reads the five numbers from step 2 every month.

Data cleansing services

We run all eight steps on your export and send back the cleaned records with a change report.

Get a free cleansing audit

HubSpot data enrichment

Match HubSpot companies to the register from the record itself.

See the HubSpot app

Company Enrichment API

Check and complete every new record as it is created, in any CRM.

See the API

Frequently Asked Questions

Common questions about cleaning a CRM that is already in use.

CRM data cleansing is finding and fixing bad records in a CRM: merging duplicates, removing or archiving companies that closed, updating companies that moved, and standardising formats. It is also called CRM data cleaning or CRM data hygiene.
Measure first, back up, agree the merge rules, standardise formats, match every company to the official register and merge duplicates on the registration number, archive closed companies, update moved ones, and set rules so it stays clean.
Run a full cleanse once, then re-check the whole base against the register two to four times a year. New records should be checked as they are created, so the big clean-up does not need repeating.
Cleansing fixes what is in the CRM: duplicates, outdated and wrong records. Enrichment adds what is missing, such as industry, size and revenue. Do cleansing first, because enriching a duplicate only gives you two enriched duplicates.
Archive rather than delete, so deal history and attribution survive. Delete when you no longer have a reason to keep the data, which GDPR expects for personal data, for example contacts at companies that closed long ago.
Both have built-in duplicate tools based on names, domains and emails. For companies, a registration number field is more reliable: match every account to the register once, store the number, and records with the same number are duplicates.
Yes. Data cleansing services take an export of your CRM, clean it and return it with your IDs so you can update in place. We do this against the official register, starting with a free audit of a sample.

Rolling out a new CRM instead? Read CRM onboarding. Filling the gaps after cleaning? Read CRM enrichment.

Clean your CRM against the register

Duplicates, closed companies and moved addresses fixed with one reference for every country. Done for you, or through the API.

+31 20 705 2360