How to Merge Duplicate Records in Dynamics 365 (Step by Step)

Duplicate accounts, contacts and leads are the most common data-quality problem in Microsoft Dynamics 365. They split activity history across records, skew reporting, and make sellers look unprepared when two colleagues call the same customer. This guide walks through how to merge duplicate records in Dynamics 365, first with the built-in merge tool, then at scale when you have more than a handful.

Step 1: Find the duplicates

Before you can merge, you need to know what is duplicated. Out of the box, Dynamics 365 offers duplicate detection rules (Settings → Data Management → Duplicate Detection Rules) that warn you when a new record looks like an existing one. Their main limitation: they rely on exact matching. “Jon Smith” and “John Smith”, or “Contoso” and “Contoso Ltd”, sail straight past them. For sound-alike and fuzzy matches you need phonetic duplicate detection.

Step 2: Merge two records with the native tool

For accounts, contacts and leads, Dynamics 365 has a built-in merge:

1. Open a view that shows both records (for example “All Contacts”).
2. Select the two duplicate records.
3. Click Merge in the command bar.
4. Choose the master record and pick which field values to keep.
5. Confirm. The losing record is deactivated and its activities, notes and related records are re-parented to the master.

This works well, for exactly two records at a time that you already know about.

The problem: native merge doesn’t scale

The built-in tool has hard limits that show up quickly in a real CRM:

• Two records at a time. A customer that exists five times means four manual merges.
• Only accounts, contacts and leads. Custom tables and other entities are not supported.
• No detection beyond exact match. Misspellings, extra spaces and sound-alike names stay invisible.
• Nobody has time. With thousands of records, manual merging is a project no one finishes.

Step 3: Merge duplicates at scale, automatically

When you are past a handful of duplicates, the practical route is automation. Techdio’s Data Quality Appa Microsoft-certified app on Microsoft Marketplace, extends Dynamics 365 with:

• Advanced detectionincluding phonetic (“sounds-like”) matching that catches what exact-match rules miss.
• Bulk and automatic mergewith rules that decide which record wins and which field values survive.
• Preventionso new duplicates are caught at the point of entry rather than cleaned up later.
• Your data stays in your environmentnothing leaves your Dataverse.

The workflow becomes: define your matching rules once, review what the app finds, and let it prevent, identify and merge duplicates continuously, instead of a heroic one-off cleanup that is outdated a month later.

Frequently asked questions

Can Dynamics 365 merge more than two records at once?

Not natively. The built-in merge dialog handles exactly two records per operation. Merging in bulk requires an add-on such as the Data Quality App.

What happens to activities when records are merged?

Activities, notes and related records from the deactivated record are re-parented to the master record, so history is preserved in one place.

Does merging work for custom tables?

The native tool does not support custom tables. Automated tools can extend duplicate detection and merging to custom entities across Dynamics 365 and Power Apps.

Want to see your own duplicate situation? Start a free trial or read the complete guide to duplicate detection in Dynamics 365.

Frequently asked questions