Export to an Excel static worksheet
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: Export to an Excel static worksheet
When you want to present Customer Engagement (on-premises) information to an individual who doesn't have access to Dynamics 365 Customer Engagement (on-premises), or you have data that doesn't change often, consider exporting your Customer Engagement (on-premises) data to a Office Excel static worksheet.
You can export up to 100,000 records at a time. And by default, Dynamics 365 Customer Engagement (on-premises) lists up to 50 records per page. select the Page arrows at the bottom of the list to view any additional pages.Export data to an Excel static worksheet
You may have the option to export data to an Excel static worksheet in all record types however, in some cases the format may be legacy, or the data may not be filtered by what you see in Dynamics 365 Customer Engagement (on-premises) view.
Open a list of records.
On the command bar select, Export to Excel > Static worksheet (Page only).
By default, an exported worksheet includes the fields that are displayed in the list, using the same field order, sorting, and field widths. To make changes to the columns in an Advanced Find View, select Edit Columns. More information: Create, edit, or save an Advanced Find search
Select Save and then save the . xlsm file. Make note of the location where you saved the file.
Note
If you're going to edit the data file later, it's recommended that you save the file before you open it. Otherwise, you may get this error message: Excel cannot open or save any more documents because there is not enough available memory or disk space.
To fix the issue do this:
Open Excel and go to File > Options > Trust Center Settings Center Settings… > Protected View.
2. In Protected View, uncheck all three items.
3. Then select OK > OK.We still strongly recommend that you save and then open the data file, rather than disabling protected view, which may put your computer at risk.
Open Office Excel and then open the . xlsm file you saved in the previous step.
By default, an exported worksheet includes the fields that are displayed in the list, using the same field order, sorting, and field widths.
Tips
You can email a static exported worksheet to anyone, or store it in a shared file. Anyone who opens the file will see all the data in the file, whether or not they are a Dynamics 365 Customer Engagement (on-premises) user or have privileges to view the data in Dynamics 365 Customer Engagement (on-premises).
You can't change the columns for a system view, such as All Active Accounts. You must either customize the view, which requires the System Administrator or System Customizer security role, or use Advanced Find to create your own view based on the current view.
In Dynamics 365 Customer Engagement (on-premises), money values are exported to Excel as numbers. After you have completed the export, to format the data as currency, see the Office Excel Help topic titled "Display numbers as currency."
The data and time values that you see in Dynamics 365 Customer Engagement (on-premises) show up as Date only when you export the file to Office Excel but the cell actually shows both the date and time.
If you're going to make changes and import the data file back in to Dynamics 365 Customer Engagement (on-premises), remember that secured, calculated, and composite fields (e.g. Full Name) are read-only and can't be imported in to Dynamics 365 Customer Engagement (on-premises). You'll be able to edit these fields in Excel but when you import the data back in to Dynamics 365 Customer Engagement (on-premises) these fields will not be updated. If you want to update these fields such as a contact's name then it's recommend that you use that view to export your data, update them in Excel, and import them back to Dynamics 365 Customer Engagement (on-premises) for changes.
Community tools
Export to Excel is a tool provided by the XrmToolbox community developed for Dynamics 365 Customer Engagement (on-premises) Customer Engagement. See the Developer tools topic for community developed tools.
Note
The community tools are not a product of Microsoft Dynamics and does not extend support to the community tools. If you have questions pertaining to the tool, please contact the publisher. More Information: XrmToolBox.
Privacy notice
If you use Microsoft Dynamics 365 (online), exporting data to a static worksheet creates a local copy of the exported data and stores it on your computer. The data is transferred from Dynamics 365 (online) to your computer by using a secure connection, and no connection is maintained between this local copy and Dynamics 365 (online).
When you export to a dynamic worksheet or PivotTable, a link is maintained between the Excel worksheet and Dynamics 365 (online). Every time a dynamic worksheet or PivotTable is refreshed, you’ll be authenticated with Dynamics 365 (online) using your credentials. You’ll be able to see the data that you have permissions to view.
An administrator determines whether or not an organization’s users are permitted to export data to Excel by using security roles.
See also
Edit the default filter of a report
Create, edit, or save an Advanced Find search
This topic applies to Dynamics 365 Customer Engagement (on-premises). For the Power Apps version of this topic, see: Export to an Excel static worksheet
When you want to present Customer Engagement (on-premises) information to an individual who doesn't have access to Dynamics 365 Customer Engagement (on-premises), or you have data that doesn't change often, consider exporting your Customer Engagement (on-premises) data to a Office Excel static worksheet.
You can export up to 100,000 records at a time. And by default, Dynamics 365 Customer Engagement (on-premises) lists up to 50 records per page. select the Page arrows at the bottom of the list to view any additional pages.Export data to an Excel static worksheet
You may have the option to export data to an Excel static worksheet in all record types however, in some cases the format may be legacy, or the data may not be filtered by what you see in Dynamics 365 Customer Engagement (on-premises) view.
Open a list of records.
On the command bar select, Export to Excel > Static worksheet (Page only).
By default, an exported worksheet includes the fields that are displayed in the list, using the same field order, sorting, and field widths. To make changes to the columns in an Advanced Find View, select Edit Columns. More information: Create, edit, or save an Advanced Find search
Select Save and then save the . xlsm file. Make note of the location where you saved the file.
Note
If you're going to edit the data file later, it's recommended that you save the file before you open it. Otherwise, you may get this error message: Excel cannot open or save any more documents because there is not enough available memory or disk space.
To fix the issue do this:
Open Excel and go to File > Options > Trust Center Settings Center Settings… > Protected View.
2. In Protected View, uncheck all three items.
3. Then select OK > OK.We still strongly recommend that you save and then open the data file, rather than disabling protected view, which may put your computer at risk.
Open Office Excel and then open the . xlsm file you saved in the previous step.
By default, an exported worksheet includes the fields that are displayed in the list, using the same field order, sorting, and field widths.
Tips
You can email a static exported worksheet to anyone, or store it in a shared file. Anyone who opens the file will see all the data in the file, whether or not they are a Dynamics 365 Customer Engagement (on-premises) user or have privileges to view the data in Dynamics 365 Customer Engagement (on-premises).
You can't change the columns for a system view, such as All Active Accounts. You must either customize the view, which requires the System Administrator or System Customizer security role, or use Advanced Find to create your own view based on the current view.
In Dynamics 365 Customer Engagement (on-premises), money values are exported to Excel as numbers. After you have completed the export, to format the data as currency, see the Office Excel Help topic titled "Display numbers as currency."
The data and time values that you see in Dynamics 365 Customer Engagement (on-premises) show up as Date only when you export the file to Office Excel but the cell actually shows both the date and time.
If you're going to make changes and import the data file back in to Dynamics 365 Customer Engagement (on-premises), remember that secured, calculated, and composite fields (e.g. Full Name) are read-only and can't be imported in to Dynamics 365 Customer Engagement (on-premises). You'll be able to edit these fields in Excel but when you import the data back in to Dynamics 365 Customer Engagement (on-premises) these fields will not be updated. If you want to update these fields such as a contact's name then it's recommend that you use that view to export your data, update them in Excel, and import them back to Dynamics 365 Customer Engagement (on-premises) for changes.
Community tools
Export to Excel is a tool provided by the XrmToolbox community developed for Dynamics 365 Customer Engagement (on-premises) Customer Engagement. See the Developer tools topic for community developed tools.
Note
The community tools are not a product of Microsoft Dynamics and does not extend support to the community tools. If you have questions pertaining to the tool, please contact the publisher. More Information: XrmToolBox.
Privacy notice
If you use Microsoft Dynamics 365 (online), exporting data to a static worksheet creates a local copy of the exported data and stores it on your computer. The data is transferred from Dynamics 365 (online) to your computer by using a secure connection, and no connection is maintained between this local copy and Dynamics 365 (online).
When you export to a dynamic worksheet or PivotTable, a link is maintained between the Excel worksheet and Dynamics 365 (online). Every time a dynamic worksheet or PivotTable is refreshed, you’ll be authenticated with Dynamics 365 (online) using your credentials. You’ll be able to see the data that you have permissions to view.
An administrator determines whether or not an organization’s users are permitted to export data to Excel by using security roles.
See also
Edit the default filter of a report
Create, edit, or save an Advanced Find search
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for