Guides

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

  1. 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.

  2. 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.

  3. 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.

  4. 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

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