prospectDuplicate records create repeated research and conflicting follow-up. Removing them carelessly creates a different problem: useful branches, contacts, and notes disappear with the extra rows.
Define whether your list contains companies or locations, flag possible duplicates, and compare the sources. Merge useful notes and restrictions before deleting an extra row. Keep an untouched copy of the original list.
Choose the matching rule before opening Excel’s removal controls; a shared domain can represent several valid branches.
Make a working copy before cleanup
Save the original list and record its row count. Perform the cleanup in a separate working copy so you can recover a source value or explain why a record was removed.
Add stable IDs if the list does not have them. When two records are merged, retain one ID and record the other as a retired reference. This is especially useful when another file or activity log still refers to the older entry.
Define a duplicate for this list
For a company-level list, a confirmed matching business identity and domain may be sufficient. For a branch-level list, the address and location source matter too. For a contact list, two people at the same company are not duplicate contacts.
| Candidate match | What to check |
|---|---|
| Same name and domain | Same company and intended record type |
| Same domain, different addresses | Separate branches or headquarters |
| Different names, same address | Rebrand, shared premises, or separate businesses |
| Same business, old and new addresses | Relocation or two active locations |
Write the rule above the working table or in its field guide. Two people cleaning the same list should reach the same decision from the same evidence.
Normalize comparison fields without destroying sources
Keep the original URL and create a separate comparison domain. A homepage with a tracking parameter and the same homepage without it may refer to one company. However, location paths and some subdomains can carry meaningful differences.
Do not run a blanket cleanup that removes every URL path from your only source column. You would lose the page that explains the branch or contact detail.
Similarly, trim accidental spaces and review capitalization differences in names, but preserve legal or trading names when they identify separate entities. The goal is easier comparison, not forced uniformity.
Flag likely matches in Excel
On a working copy, select the comparison column and choose Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values in supported Excel versions. Highlighting identifies repeated values; it does not decide which company or branch to retain.
After reviewing and merging useful information, select the complete record range and use Data > Remove Duplicates only when the chosen columns express your matching rule. Selecting several columns tests their combination. A unique record-ID column would prevent otherwise matching rows from being recognized as duplicates, so do not include it in that comparison.
Microsoft's duplicate-removal guide explains the controls. Inspect the retained record afterward; removing duplicates does not merge notes from the discarded rows.
Merge the information that matters
Suppose two fictional records describe Example Supply's north branch. One has a phone number and the other has a verified service-area note. Keep both useful facts in the retained record after checking their sources.
If the records disagree, do not choose the fullest row automatically. Compare source relevance and checked dates. A recent headquarters address can still be less relevant than an older but accurate branch page.
Preserve contact restrictions and meaningful activity history. A merged record should not become contactable merely because the duplicate without a suppression note was retained.
Reconcile the result
Count the records before and after cleanup and keep a short merge log. If 120 rows become 113, you should be able to identify the seven retired records and their destinations or exclusion reasons.
Review a few retained rows against the original file. Confirm that emails, phone numbers, ownership, and next actions remain attached to the correct business. A clean count is not enough if sorting or deletion has shifted the data.
Use the same matching rule for the next import. Preventing a repeat is easier when the collection has stable IDs, source links, and an explicit definition of one record.
Related Questions
Can I use the website domain as the only duplicate key?
Only if your list truly represents one record per company and you have reviewed shared-domain exceptions. Branches, franchises, and other distinct records may share a website while requiring separate rows.
Should I keep the newest duplicate?
Choose by source relevance and verification, not age alone. Merge useful notes and preserve contact restrictions before removing an extra row. A newly captured record can still point to the wrong branch or department.
For shared domains, read keeping multiple locations. For broader cleanup, use the Excel contact-data checklist.
Published by Stephen Modliszewski, publisher of Prospect — Sales Bookmarks. ProspectClip is the extension’s website. Fictional examples and illustrative calculations are teaching aids, not customer results.