The Scenario
Your CRM admin has a nagging suspicion. After three separate CSV imports over the past year — one from a conference list, one from a partner handoff, one from a form tool migration — Nutshell probably has several hundred duplicate contacts. Nobody has ever checked. The problem surfaces in customer success when two reps call the same person from different records. Today is the day someone finally digs in.
The bad version:
- You export all Nutshell contacts as a CSV, open it in Excel, and start looking for duplicate emails by eye.
- You write a COUNTIF formula to flag emails that appear more than once. It works on 200 rows and then something breaks because two email values have invisible trailing spaces.
- You spend 30 minutes debugging the formula and are not confident the results are complete.
The duplicate problem is real. The detection method shouldn't be this fragile.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook and, through its built-in Nutshell integration, can pull the full contact list and flag duplicates in a single operation.
Open SheetXAI in the sidebar and ask:
Fetch all Nutshell contacts, dump them into my Excel dedup sheet with ID, name, and email, then add a Duplicate flag column that marks TRUE for any email that appears on more than one row
What You Get
- One row per Nutshell contact with ID, name, and email.
- A Duplicate flag column marking TRUE for any email that appears on more than one record.
- Contacts with no email address listed clearly rather than hidden or excluded.
- A count of duplicate groups written below the data so you know the scope before you start merging.
What If the Data Is Not Quite Ready
Some emails differ only by case or trailing whitespace
Fetch all Nutshell contacts and write ID, name, and email into this workbook — normalize emails to lowercase and trim whitespace before dedup comparison, then flag any email that appears on more than one row after normalization
You want to see only the duplicates, not the full list
Fetch all Nutshell contacts, identify any email that appears on more than one record, and write only those rows into this workbook — showing all records that share a duplicated email so you can decide which to keep
You want to sort duplicates adjacent to each other for easier review
Fetch all Nutshell contacts, normalize emails, flag duplicates, and sort the workbook by email ascending so all duplicate pairs appear next to each other — add a summary count at the bottom showing total duplicate groups found
Full dedup audit in one shot
Fetch all Nutshell contacts, normalize emails to lowercase and trim whitespace, flag rows where the normalized email appears on more than one record with TRUE in a Duplicate column, sort by email ascending so duplicates appear adjacent, and write a summary count below the data showing the total number of duplicate groups found
When the CRM audit has been deferred long enough, describe the full dedup detection in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open a blank workbook for your next CRM cleanup session — then ask it to pull the full Nutshell contact list and surface every duplicate email. You can also bulk-import new contacts with automatic dedup checking, provision custom fields for standardization, or bulk-tag leads after an ICP scoring exercise.