Knowledge Center

14 Aug, 2020

How to migrate Closed (Won or Lost) Opportunities?

Posted on 14 Aug, 2020 by Admin, Posted in Dynamics 365 Dynamics-365 Sales

How to migrate Closed (Won or Lost) Opportunities? Blogs

How to migrate Closed (Won or Lost) Opportunities?


In this blog I have explained how to migrate historical Closed (Won or Lost) Opportunities.


We will use comma separated (CSV) file as import file. Here are some important things you need to consider:

  1. Get your import file ready: Make sure your data is as complete and accurate when you create the import file.
  2. Make sure that the import file has “Status” & “Status Reason” fields information.
  3. Format of your date and crm environment should be same: make sure that “Source” and “Target” date formats are same. Because if “Source” system format is different than “Target” then system will throw an error.
    1. To check it, go to Settings > Data Management > Imports.
    2. Click on Setting icon at top right side of the import page.
    3. Select Options.
    4. Check your date format and crm environment date format are same or not, if it is not change it select your date format.

Step by Step

  1. Go to Settings > Data Management > Imports.
  2. On the command bar select Import Data > Import Data.
  3. Browse and select the import file and click on Next.
  4. Now, it will show you file upload summary, click on Next.
  5. Select data map, here I am selecting the Default one.
  6. Now select record type as Opportunity, Click on Next.
  7. In step 5, we had selected Data Map to default, it will automatically map source fields to crm fields. Here we need to check its mapping and map or un-map according to our requirement. Click on Next. (Unmapped fields will be ignored.)
  8. Now it will show you Review Mapping Summary. If you want to change some mapping them click on “Edit“, if not then click on Next.
  9. This is the final step, here you can configure some setting such as “Allow Duplicates”, “Select owner of imported records” and “Data map name”, choose accordingly. After that click on Submit.
  10. Now import is submitted, to verify that the wizard was successful, select Imports, and then review the report. Otherwise, select Finish.


This is a Required Field


Recent Updates

07 Sep, 2023

Optimizing Storage with SubscriptionTrackingDeletedObject Cleanup

What is SubscriptionTrackingDeletedObject? The "SubscriptionTrackingDeletedObject" table is linked to the "DeletionService," which handles two types of cleanup: organization-wide and record-specific.…

05 Sep, 2023

How to create real-time customer journeys in Dynamics 365 Marketing

Introduction: This blog will show how to create real-time customer journeys in Dynamics 365 Marketing. Customer journeys can be either…

30 Aug, 2023


Introduction: In Dynamics 365 (D365) Customer Service, the 'Customer 360' Component provides a comprehensive view of information and enables users…