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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

CRM Cleanup

(2) ShareShare
ReportReport
Posted on by 8

Is there a way to make a duplicate copy of our environment prior to performing "clean-up"? Or is it best practice to export to excel, cleanup, remove duplicates then import back into the system?

Categories:
  • Verified answer
    Travis South Profile Picture
    393 on at

    Yes, you can make a copy of your Dynamics 365 environment before cleanup. I would recommend this over exporting everything to Excel.

     

    In the Power Platform Admin Center, select your production environment and use Copy > Everything to copy the data and customizations into a sandbox environment. Before making production changes, also create a manual backup. Test your cleanup in the sandbox first, especially if you are merging duplicate accounts or contacts with related records, activities, or opportunities.

     

    Dataverse has built-in duplicate detection and merge capabilities, so Excel is not always necessary. Exporting and reimporting can introduce issues with relationships and record IDs.

     

    Microsoft Documentation: Copy an Environment

  • Verified answer
    11manish Profile Picture
    1,833 Super User 2026 Season 2 on at

    For a major Dynamics 365 / Dataverse cleanup, use a sandbox copy to test, a production backup for recovery, and a controlled deduplication process rather than an export-delete-reimport cycle.
    One question that would help me recommend the safest exact approach: Which tables are you cleaning up — Accounts and Contacts, or custom Dataverse tables as well?

  • Suggested answer
    Subra Profile Picture
    2,686 Super User 2026 Season 2 on at

    Yes, you can make a copy of your Dynamics 365 environment before cleanup. 

  • Suggested answer
    rajeshjamrodh Profile Picture
    159 on at

    Hi @MF-16041922-0 ,

    Create a copy of your Dynamics 365 / Dataverse environment first, then clean up the duplicate data in the copy. I would not use Excel export, delete, and re-import as the primary cleanup strategy for an environment with complex CRM relationships.

     Create a duplicate environment

    Microsoft supports copying an environment to a sandbox or preview environment using the Power Platform admin center. You can copy all data and customizations or copy customizations and schemas only. For cleanup validation, choose Everything.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
11manish Profile Picture

11manish 42 Super User 2026 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 39 Super User 2026 Season 2

#3
Travis South Profile Picture

Travis South 27

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans