Duplicate contacts can creep into your CRM through imports, manual entry variations, or when team members add the same person separately. SalesSheet.ai helps you find and merge duplicates to maintain a clean, accurate database.
How Duplicate Detection Works
SalesSheet uses AI to identify potential duplicates automatically and alerts you when they're found.
What triggers duplicate detection:
- When you add a new contact manually
- During CSV imports
- When enrichment discovers matching records
- During scheduled automatic duplicate scans (weekly)
How duplicates are identified:
- Email match: Exact email address match is the strongest indicator
- Name + company match: Same first/last name at the same company
- Phone match: Identical phone numbers
- Fuzzy name match: Similar names with typos (e.g., "Jon Smith" vs "John Smith")
The AI assigns a confidence score to each potential duplicate. High-confidence matches (95%+) are clear duplicates. Medium-confidence matches (70-94%) need your review.
Finding Duplicate Contacts
Access the duplicate detection system to see potential matches across your database.
Using the Duplicates dashboard:
- Navigate to Contacts
- Click "Find Duplicates" in the top toolbar
- The system scans your database and shows potential duplicate pairs
- Duplicates are sorted by confidence score (highest first)
- Each pair shows key matching fields highlighted
Duplicate alerts:
- When adding a contact, you'll see a warning if a potential duplicate exists
- "This contact may already exist. View potential match."
- Click to compare the new contact with the existing one
- Choose to merge, continue creating anyway, or cancel
Manual search for duplicates:
- Open any contact detail page
- Click the three-dot menu → "Find duplicates of this contact"
- The system searches for matches and displays results
Reviewing Duplicate Pairs
Before merging, carefully review the duplicate pair to ensure they're actually the same person.
Compare view features:
- Side-by-side comparison of all contact fields
- Matching fields highlighted in green
- Conflicting data highlighted in yellow
- Timeline preview showing activities from both records
Questions to verify true duplicates:
- Do the email addresses match or belong to the same person?
- Are they at the same company (or did one person change jobs)?
- Do phone numbers match or could they be different people?
- Does the job title and location make sense for one person?
Not a duplicate? Here's why:
- Same name, different companies (very common with names like "John Smith")
- Same name at same company but different people (Sr. and Jr., for example)
- Person changed jobs - create two records or update the company on one
- Personal vs work email for the same person (this IS a duplicate)
Merging Contacts
Once you've confirmed duplicates, merge them to consolidate all data into a single record.
How to merge:
- From the duplicate comparison view, click "Merge These Contacts"
- Choose which contact should be the primary (master) record
- Review the merge preview showing which data will be kept
- For conflicting fields, select which value to keep
- Click "Confirm Merge" to complete the process
What happens during a merge:
- Contact data: Primary record is kept; fields from secondary fill in any blanks
- Activities: All emails, calls, meetings, and notes from both records are combined into one timeline
- Deals: Any deals linked to the secondary contact are moved to the primary
- Tags: Tags from both contacts are combined (no duplicates)
- Custom fields: Values are merged; conflicts use the value you selected
- Files: All files from both records are preserved
- Secondary record: Archived and marked as merged (not deleted)
Choosing the Primary Record
The primary record becomes the final merged contact, so choose wisely.
Factors to consider:
- More complete data: Choose the record with more fields filled in
- Better enrichment: If one has a LinkedIn profile and company data, prefer that one
- More recent: The newer record may have more up-to-date information
- Correct company: If one has the current company and one has an old employer, choose current
- Linked deals: If one has active deals, making it primary keeps deal links cleaner
Don't worry too much - data from both records is preserved, and you can manually adjust fields after merging if needed.
Preventing Future Duplicates
Good practices help minimize duplicate creation in the first place.
Prevention tips:
- Always include email: Email is the best unique identifier - always capture it
- Search before adding: Do a quick search for the person before creating a contact
- Use AI chat: "Add John from Acme" - the AI searches for existing contacts first
- Standardize imports: Clean your CSV data before importing (remove duplicates in Excel first)
- Train your team: Make sure everyone knows to check for existing contacts
- Review duplicate alerts: Don't ignore warnings when adding contacts
Consejo Pro
Schedule a monthly "CRM cleanup" session where you review and merge duplicates. Go to Find Duplicates, sort by confidence score, and work through the high-confidence matches first. Even spending 15 minutes a month keeps your database clean. You can also delegate this to a team member as part of CRM maintenance duties.
Qué Esperar
After merging duplicate contacts, you should see:
- One consolidated contact record with all data from both originals
- A unified timeline showing all activities chronologically
- All deals, files, and notes accessible from the single merged record
- The secondary record marked as "Merged" in the archived contacts view
- Future searches returning only the merged contact, not the duplicate
- A merge activity note in the timeline documenting what was merged and when
Solución de Problemas
I accidentally merged two contacts who aren't the same person. Can I undo it?
Yes, you can unmerge contacts within 30 days of merging. Go to the merged contact, click the three-dot menu, and select "View merge history." Click "Undo merge" to split them back into two separate records. All data will be restored to the original contacts. After 30 days, unmerge is no longer available, but you can manually create a new contact with the separated data.
The duplicate detector isn't finding duplicates I can clearly see. Why?
The AI looks for exact or very similar matches. If names are spelled completely differently (like "Bob" vs "Robert") or if email addresses are different, it won't auto-detect them. You can manually merge any two contacts even if they're not flagged as duplicates. Open one contact, click the three-dot menu, select "Merge with another contact," then search for and select the other record.
What happens to email threads after merging? Will I lose conversation history?
No, all email history is preserved. Both contacts' email timelines are merged chronologically. If you had email threads with both contact records, they'll all appear in the merged contact's timeline. External email threads remain intact - replies continue to work normally because the actual email addresses haven't changed.