How to Merge and Clean Up Company Records in HubSpot

Duplicate company records are one of the most persistent data quality problems in HubSpot. They fragment your account data, confuse your sales team, and produce unreliable reports. A rep looks up a company and sees two records — one with the recent deal activity, another with the older history. Which one is right? Usually both, partially.

The problem grows over time. Every form submission, CSV import, integration sync, and manual record creation is an opportunity for a duplicate to sneak in. And because HubSpot's automatic company creation (from contact email domains) doesn't always catch existing records, the duplicates accumulate.

This guide covers how to find duplicates, merge them properly, and put safeguards in place to prevent them from coming back.

How duplicate companies are created in HubSpot

Understanding the source of duplicates helps you prevent them. The most common causes:

Automatic company creation

HubSpot automatically creates company records when contacts are added (via form submission, import, or API) if the "Automatically create and associate companies with contacts" setting is enabled (Settings > Objects > Companies). The system uses the contact's email domain to create a company record.

The problem: this feature creates a new company if it doesn't find an exact domain match. If you already have a company record for "Acme Corp" with domain "acme.com," and someone submits a form with an @acme.co.uk email, HubSpot creates a second company record for the .co.uk domain. Now you have two Acme Corp records.

CSV imports

Imports are the biggest source of duplicate companies in most portals. If your import file has company names with slight variations — "Acme Corp", "Acme Corporation", "Acme Corp.", "Acme" — HubSpot treats each as a separate company unless you explicitly map to existing records using Record ID.

Integration syncs

Salesforce, NetSuite, and other connected systems may have their own duplicate problems. When data syncs to HubSpot, the duplicates come along for the ride.

Manual creation

Sales reps create company records manually during prospecting. If they don't check whether the company already exists first, duplicates are created. This is especially common when company names aren't standardized — a rep searches for "Microsoft" but the existing record is "Microsoft Corporation."

Finding duplicate companies

HubSpot offers a built-in duplicate management tool, plus there are manual approaches for cases the automated tool misses.

HubSpot's duplicate management tool

Navigate to Contacts > Companies, then click "Actions" > "Manage duplicates." HubSpot uses a combination of company name similarity and domain matching to suggest potential duplicates.

The tool presents pairs of potentially duplicate records side by side, with a confidence score. You can review each pair and either merge them or dismiss the suggestion.

Limitations of the built-in tool:

• It only surfaces pairs, not groups. If you have five duplicate records for the same company, you'll see them as multiple pairs, and you'll need to merge them sequentially.
• The matching algorithm is imperfect. It catches obvious duplicates (exact or near-exact name matches) but misses companies with significantly different names that represent the same entity. "International Business Machines" and "IBM" won't be flagged.
• It doesn't catch duplicates that differ only in non-name properties. Two records both named "Acme Corp" but with different domains won't be flagged if the names match exactly — because HubSpot correctly considers exact matches as the same record, not duplicates. But two records with different names that share a domain might not be flagged.

Manual duplicate hunting

For a more thorough search, use these approaches:

Sort by company name. Go to the Companies index page and sort alphabetically by company name. Scroll through looking for similar consecutive entries. This catches variants like "Acme Corp" and "Acme Corporation" that appear near each other.

Filter by domain. If you know which domains should have unique company records, filter by "Company domain name" and look for multiple records with the same domain.

Search for name variations. Use a search tool to find all companies where the name contains a particular string. For example, searching for "Acme" across company names might reveal "Acme Corp," "Acme Inc.," "Acme Holdings," and "The Acme Company" — some of which might be the same entity.

Check record counts. Companies with unusually low activity (zero contacts, zero deals) are often duplicate records where all the real activity ended up on the other copy.

Pre-merge preparation

Before merging any records, do these things:

1. Decide which record to keep

When you merge two company records in HubSpot, you choose a "primary" record — the one that survives. The other record is deleted, and its data is folded into the primary. Choose the record with:

• More complete property data
• More associated contacts and deals
• The correct company domain
• The longer activity history

2. Reconcile conflicting property values

If both records have different values for the same property, the primary record's value wins by default. Review the property values before merging and decide which values should be kept. You can manually update the primary record's properties before merging to ensure the best data survives.

3. Export a backup

Before any merge operation, export both records and their associated data. HubSpot merges are permanent — there's no undo button. Having a backup lets you restore data if something goes wrong.

4. Notify the team

If sales reps are actively working accounts that are about to be merged, let them know. Merging changes Record IDs and can temporarily confuse reps who had the old record bookmarked or noted in their workflow.

Merging company records

One at a time

For individual merges, navigate to the company record you want to keep. In the left sidebar, click "Actions" > "Merge." Search for the duplicate record, select it, and HubSpot shows you a side-by-side comparison of both records' property values. Choose which values to keep, then confirm the merge.

What happens during a merge:

• The secondary record is deleted
• All contacts, deals, tickets, and other associations from the secondary record are moved to the primary
• Activities (notes, calls, emails, meetings) from both records are combined on the primary
• The secondary record's ID becomes invalid — any bookmarks or external references to it will break

In bulk

HubSpot doesn't offer a bulk merge feature. If you have 50 pairs of duplicates to merge, you need to do them one at a time. This is where pre-merge data cleanup can save significant time.

The alternative approach: Instead of merging, clean up the data that makes records look like duplicates. If you have "Acme Corp" and "Acme Corporation" as separate, legitimate companies, no merge is needed — you just need to standardize the names. A bulk search-and-replace operation to change "Acme Corporation" to "Acme Corp" (or vice versa) resolves the apparent duplication without the complexity of merging.

This approach works when the "duplicates" are actually caused by inconsistent naming rather than genuinely redundant records. Standardizing company names, suffixes (Corp vs. Corporation vs. Inc.), and domain variations often reduces your duplicate count significantly before you start merging.

Preventing future duplicates

Cleaning up existing duplicates is necessary, but prevention is the real goal.

Standardize company name formats

Pick a standard for how company names are formatted and enforce it:

• With or without suffixes (Inc., Corp., LLC)?
• Capitalization style (Title Case, ALL CAPS, lowercase)?
• Abbreviations (International vs. Intl, Company vs. Co)?

Document your standard and communicate it to everyone who creates or imports records. Then use bulk search-and-replace to standardize existing records against this format.

Configure auto-association carefully

Review your company auto-creation settings (Settings > Objects > Companies). Consider:

• Disabling automatic company creation if your team is disciplined about manually associating contacts with the correct company
• Keeping it enabled but doing regular duplicate checks to catch the duplicates it creates
• Using HubSpot's "Target accounts" feature to lock down important company records from being duplicated

Import with Record IDs

When importing CSV data to update existing companies, always include the HubSpot Record ID column and select "Update existing records" during import. This ensures HubSpot matches to existing records instead of creating new ones. Never import companies by name alone — name-based matching is unreliable for reasons described above.

Train your team

Sales reps should search for an existing company record before creating a new one. This seems obvious, but in practice, reps who are focused on speed often skip the search. Include this in your CRM onboarding process and reinforce it periodically.

Use deduplication workflows

On HubSpot Data Hub (formerly Operations Hub) Professional and Enterprise, you can use "Data Quality Automation" to automatically format and standardize property values as they're entered. This reduces the name variations that cause duplicate detection to fail.

The cleanup sequence

For a portal with significant duplicate problems, here's the recommended order of operations:

1. Standardize company names first. Use bulk search-and-replace to normalize suffixes, abbreviations, and formatting. This reduces false duplicates.
2. Standardize domains. Ensure every company record has a properly formatted domain value. Fill in missing domains where possible.
3. Run HubSpot's duplicate detection. With cleaner names and domains, the built-in tool will produce more accurate suggestions.
4. Review and merge. Work through the duplicate suggestions, prioritizing high-value accounts.
5. Set up prevention. Configure auto-association settings, document naming standards, and train your team.
6. Schedule recurring checks. Add a monthly or quarterly calendar reminder to run duplicate detection and address any new duplicates.

Duplicate company records are inevitable in any active CRM. The goal isn't to eliminate them entirely — it's to catch and resolve them before they cause real problems for your team.

---

Before merging, try standardizing company names in bulk. SearchReplace finds name variations across your portal and lets you fix them with preview and rollback.