web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / List of duplicate cont...
Microsoft Dynamics CRM (Archived)

List of duplicate contacts

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

Is there a way to export a list of duplicate contacts to excel?

I've run the duplicate detect but it only shows 12 records per page and doesn't seem to show a total or have a way to view the list as a whole.

Is there a way this could be done? We know we have a few duplicates across departments and want to pull the list to give to a user to review more easily than in the duplicate detect. 

Thank you,

Brianna

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Thomas David Dayman Profile Picture
    Thomas David Dayman 11,323 on at
    RE: List of duplicate contacts

    You could just export all of your contacts to an excel sheet. Then in excel go to Conditional Formatting > Highlight cell rules > Duplicate Values. Then you can find all the duplicates.

  • Community Member Profile Picture
    Community Member on at
    RE: List of duplicate contacts

    Can you think of a way to view directly in CRM in a list like format? When I try to export it gets hung, even when the list is narrowed down to under 5,000.

  • Verified answer
    Thomas David Dayman Profile Picture
    Thomas David Dayman 11,323 on at
    RE: List of duplicate contacts

    Hi Brianna,

    Unfortunately there isn't a simple way of running this report straight out of CRM.

    Are you familiar with XRMToolBox? http://www.xrmtoolbox.com/

    There is a Plugin you can download called 'Duplicate Detection Report for Bulk Merge' I think that might do the trick for you.

    Let me know if you need more help.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#1
UllrSki Profile Picture

UllrSki 2

#3
ED-30091530-0 Profile Picture

ED-30091530-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans