Company deduplication means finding company records that refer to the same organization, then reviewing whether to merge them or remove repeated entries.
Start with a reliable account identifier or verified company domain. Use normalized names to find candidates when those identifiers are missing. A similar name is evidence to review, not proof of company identity.
Choose what one company record represents
Decide whether your list tracks a corporate group, a legal entity, or a branch. Two branches can share a website and still need separate CRM records. Parent companies and subsidiaries may also need separate accounts.
The Yellow Pages plumbing-business example uses listing URLs and addresses to keep separate branches while reviewing repeated results from nearby searches.
For an illustrative list, Acme Tools, Acme Tools Ltd, and ACME TOOLS could be name variants. A fourth row called Acme Tools France could be a subsidiary or a separate business. Do not merge it solely because the names share words.
If a cell contains several comma-separated vendor or product names, separate them into the intended records before comparing companies. Product names and company names need different matching rules.
Best fields for company deduplication
Use identifiers that match your chosen record level:
- CRM account ID: useful within the same CRM; IDs from unrelated systems are not interchangeable.
- Verified company domain: useful for account lists, with review for shared group websites and hosted pages.
- LinkedIn company page: useful when both rows refer to the same company page rather than a person.
- Company name plus country or city: useful for candidate matching when stronger identifiers are missing.
Keep the original name next to the normalized company name. Normalization improves comparison but does not establish that two legal entities are the same.
When domains are missing, use the free Domain Finder to look up a small batch of company names. Check that each website belongs to the intended organization before using the domain for matching; a shared group website can still represent several distinct records.
Example matching decisions
| Illustrative records | Review decision |
|---|---|
| Acme Tools Ltd and ACME TOOLS, both using acme.example | Candidate duplicate; verify they represent the same account before merging. |
| Acme Tools and Acme Software, with different verified domains | Keep separate unless other evidence establishes the same organization. |
| Two branches with one corporate website and different branch IDs | Keep separate when the list tracks branches. |
| Two blank websites and similar names | Missing websites do not confirm a match; review other identifiers. |
Company deduplication in Datablist
Import the list with a source record ID, original company name, website, country, and any account identifier you already trust. Use Company Name Cleaner to create a cleaned name while preserving the original column. Review uncertain results before using that cleaned column as a match key.
Run the Duplicates Finder with the matching rules that fit your data. Exact matching works for trusted identifiers. Smart company-name matching helps find spelling and legal-suffix variants. For website URLs, choose deliberately whether path and subdomain differences should matter; hosted company pages can share a domain without sharing an owner.
Use multiple columns when one field is ambiguous, and check the multi-column matching rules. Configure how missing values are handled instead of treating two empty identifiers as confirmation.
Review the proposed groups before merging. Decide which record to keep and how to handle conflicting websites, account IDs, and company names. Preserve useful values and source references; deleting every extra row without reviewing conflicts can discard information you need.
Export the reviewed list with its source IDs so you can reconcile the changes with the original CRM or spreadsheet. For the full workflow, read the company deduplication guide and company name normalization guide.
If Website values include contact or product paths, choose URL deduplication settings that fit one company per row. Do not collapse different hosted businesses merely because they share a parent domain.