Cleaning duplicate contacts out of a CRM export
Every CRM grows duplicates: a lead fills in a form twice, a colleague adds someone from a business card, an import brings in the same people again. Sales then calls the same person twice, or two reps work the same account.
Many dedup tools want access to your CRM or ask you to upload the customer list. If that's a problem for your company's data rules, you can do the matching on your own computer instead.
Step by step
- Export the people
In most CRMs, open the list of contacts or people, filter if needed, and choose Export to CSV or Excel. Include name, email, phone and organization.
- Find the duplicates
Open the export in Contact Dedup. It groups records that belong to the same person and shows why: same email, same phone in a different format, nickname, and so on.
- Decide what to merge
Confident groups are pre-selected. Uncertain ones, like the same name at two different companies, are left for you. Use the list of line numbers to find the records in your CRM.
- Merge in the CRM
Most CRMs have a merge function that keeps activities and deals together. Use the groups as your to-do list, or import the cleaned file if you're rebuilding the list.
Things to watch out for
- Merging inside the CRM keeps the history (calls, emails, deals) attached. Re-importing a cleaned file doesn't, so prefer the CRM's merge for live records.
- Two contacts with different work emails at the same company are usually two people. They are flagged for review instead of merged.
Questions
Do you connect to my CRM?
No. You export the file yourself and it's processed in your browser. Nothing about your customers reaches our server.
Why not merge everything automatically?
Because merging two different customers is worse than missing a duplicate. Only pairs with a shared personal email or phone and matching names are pre-selected.
More guides
- What Contact Dedup understands, with examplesWhich pairs are the same person, and which are kept apart.
- How to remove duplicate contacts in Excel, including the ones Excel missesRemove Duplicates only catches identical rows. How to find the rest.
- How to find and merge duplicate contacts in a CSV fileWhat to compare, and how not to merge two different people.
- How to clean up duplicate contacts from your phone (vCard / .vcf)Export, merge without losing photos or notes, import back.
- How to dedupe a Google Contacts exportWhen Google's Merge & fix isn't enough.
- How to remove duplicates from a mailing list before you import itFewer double sends, cleaner stats, lower bills.
- How to find duplicate companies in a CRM or spreadsheetLegal forms, websites and branches in different cities.