Import data in Dynamics 365 using Templates

Import data in Dynamics 365 using Templates

In dynamics 365, there is way to import data using entity templetes. We can download this template for any entity and import data into Dynamics 365. Here are the steps.

Step 1:

Login to your organisation and navigate to ‘Settings’ area and select ‘Data Management’.

Step 2:

Click on ‘Templates for Data Import’.

Step 3:

This is the popup window will be shown after completing step 2. From the dropdown we can download template for any entity. Choose entity and click download button.

Step 4:

Open the downloaded template add any number of records in it and save the excel file.

Step 5:

Now navigate to ‘Settings’ -> ‘Data Management’ and click on ‘Imports’.

Step 6:

Click on ‘Import Data’ button.

Step 7:

Now, click on ‘Choose file’ button and select your saved excel file from step 4.

Step 8:

Here you can allow or restrict duplicate records creation based on duplicate detection settings. You can also change the owner of the records by selecting from the user lookup. By default, login user is selected as the owner of importing records. Click ‘Submit’ button to start importing.

Step 9:

Initially importing status reason shows as ‘Submitted’. The total number of records processed will be shown under ‘Total Processed’ column.

Step 10:

Record count of successful import will be shown under ‘Successes’ column. If any error occurred during import, those record count will be shown under ‘Error’ column. We can double click on any record and see the import information such as success, failure reason etc. after the completion of import process the status reason will be changed as ‘Completed’.

Step 11:

Now navigate to ‘Sales’ area and select ‘Accounts’.

Step 12:

That’s it. Account data imported successfully. You can change the view and see the data as you wish.

Happy CRMing..!

This article was written by Monika Sri

Leave a Reply

Your email address will not be published. Required fields are marked *

4 × 3 =

Leave a Comment