Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

List of duplicate contacts

Posted on by Microsoft Employee

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

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

  • Community Member Profile Picture
    Community Member Microsoft Employee 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.

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

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans