Import data into Microsoft Dynamics 365 (online)


Applies To: Dynamics 365 (online), Dynamics CRM Online

If you’ve completed a Microsoft Dynamics 365 (online) free trial and are converting to a Dynamics 365 (online) paid subscription, you can easily remove the sample data and then import or enter your own data.

If your business data is currently located in other systems, you should import it into Dynamics 365 (online). Depending on the amount and complexity of the data in other systems, there are several options for importing it.


You can also import bulk data using the Data Loader cloud service (preview feature). More information: Preview feature: Import bulk data with the Data Loader.

In This Topic

Delete sample data

Import Outlook contacts into Microsoft Dynamics 365 (online)

Import other types of data into Microsoft Dynamics 365 (online)

Delete sample data

If you’ve been using the sample data in a free trial of Dynamics 365 (online), you can easily delete it before adding your business data.

  1. Go to Settings > Data Management.

  2. In the Data Management area, click or tap Sample Data.

  3. In the Sample Data dialog box, click or tap Remove Sample Data.

Import Outlook contacts into Microsoft Dynamics 365 (online)

In Dynamics 365 (online), contacts are people you do business with and accounts are the companies they work for. If your current Outlook contacts are the names of people that you do business with, importing the Outlook contacts is a streamlined process because the field names are the same in both systems.

After you install Dynamics 365 for Outlook, you can use the Add Contacts Wizard to add contacts directly from Outlook into Dynamics 365 (online). More information: Help & Training: Import contacts.

Import other types of data into Microsoft Dynamics 365 (online)

Using the Dynamics 365 (online) Import Data Wizard, you can import many types of customer data stored in comma-separated value (.csv) format. Many spreadsheet programs that you use to store data, such as Microsoft Office Excel, provide an option to convert the data into .csv format when you save it. Many browser-based email programs enable you to save your contacts information to a file in (.csv) format.

After the data is in a supported format, you can use the Import Data Wizard to import contact information that is stored in .csv, .txt, .xml, or .zip files.

More information: Help & Training: Import data.


When you have verified that your imported data is correct, consider running a duplicate detection job on the imported data to identify and delete duplicated data. More information: Detect duplicate data [admin guide].

See Also

Import data (all record types) [Conceptual]
Customizations for Microsoft Dynamics 365 (online)
Get started administering Microsoft Dynamics 365 (online)

© 2016 Microsoft. All rights reserved. Copyright