Import and export data

This article applies to Dynamics 365 Customer Engagement (on-premises) version 9.1 using the legacy web client. If you’re using Unified Interface, your apps work the same as Unified Interface for model-driven Power Apps. For the Power Apps version of this article, see: How to import data

To keep track of all your customer data in one place, you may want to import contacts, leads, or other record types into Dynamics 365 Customer Engagement (on-premises) from other sources, such as from an email program, a spreadsheet, or your phone.

Note

Depending on how much data you want to import and other factors, importing data may take some planning. You may want to check with your system administrator for guidance.

Contacts typically come from an email program or a spreadsheet. Read how to do this: Import contacts.

Accounts, leads and other data can come from different sources. Read how to do this: Import accounts, leads, or other data.

After the import, you may need to check for duplicates. Read how to do this: Merge duplicate records for accounts, contacts, or leads

Export

If you want to do additional calculations or run your own reports, you can export your data to Excel. Create a static Excel spreadsheet if you want to capture all of the data at a single point in time. Or, you can create a dynamic PivotTable or worksheet, and then select the columns or fields you want to include. These articles will lead you through the process:

This topic applies to Dynamics 365 Customer Engagement (on-premises). For the Power Apps version of this topic, see: How to import data

To keep track of all your customer data in one place, you may want to import contacts, leads, or other record types into Dynamics 365 Customer Engagement (on-premises) from other sources, such as from an email program, a spreadsheet, or your phone.

Note

Depending on how much data you want to import and other factors, importing data may take some planning. You may want to check with your system administrator for guidance.

Contacts typically come from an email program or a spreadsheet. Read how to do this: Import contacts.

Accounts, leads and other data can come from different sources. Read how to do this: Import accounts, leads, or other data.

After the import, you may need to check for duplicates. Read how to do this: Merge duplicate records for accounts, contacts, or leads

Export

If you want to do additional calculations or run your own reports, you can export your data to Excel. Create a static Excel spreadsheet if you want to capture all of the data at a single point in time. Or, you can create a dynamic PivotTable or worksheet, and then select the columns or fields you want to include. These articles will lead you through the process: