Learn how to efficiently import your data into Dynamics 365 using the built-in Data Import Wizard. This guide will walk you through preparing your file, mapping fields, and monitoring the import process.
Ensure your data is in a supported format like CSV, XML, or TXT. Make sure your column headers match the field names in Dynamics 365 for easier mapping. Clean your data to remove errors or inconsistencies.
Log in to Dynamics 365. Go to Settings (the gear icon) > Advanced Settings. Then navigate to Settings > Data Management > Imports.
On the Imports page, click the Import Data button in the command bar. This will open the Data Import Wizard.
Click Choose File to select your prepared data file from your computer. The wizard will automatically detect the delimiter. Click Next to proceed.
The wizard will attempt to automatically map the columns from your file to the corresponding fields in Dynamics 365. Review the mappings carefully and manually select any unmapped fields. Click Next.
Review the import summary and configure duplicate detection settings. Click Submit to start the import. You can monitor the progress, successes, and failures from the Imports page.
Tips for a Successful Dynamics 365 Data Import
Download a data import template from Dynamics 365 (Settings > Data Management > Templates for Data Import) to ensure your columns are correctly formatted.
Before importing, check for duplicates, missing values, and incorrect formatting in your source file. Clean data prevents import errors and saves time.
Always import a small sample of your data (e.g., 5-10 records) first to ensure your mappings are correct and the data appears as expected.
Use the duplicate detection settings in the wizard to decide whether to allow duplicates or prevent them from being created, which is crucial for data integrity.
Explore other Dynamics 365 guides and shortcuts