Applies to Dynamics 365 (online), version 9.x
No need to leave Dynamics 365 to analyze your data. Now you can do a quick ad-hoc analysis using Microsoft Excel Online in Dynamics 365 (online).
For example, if you’re a sales manager, you might want to analyze the opportunities your team owns and review key performance indicators (KPIs) to see how you can assist your team members. If you’re a sales rep, you can open your opportunities in Excel and conduct what-if analysis for different incentive scenarios. Or, you may want to quickly open the data in Excel Online so that you can copy it somewhere else such as an email.
When you make changes to your data in Excel Online, you can save the updated information in Dynamics 365. Remember to keep the existing format of the Excel cells to prevent problems during import. Adding additional information to the spreadsheet, such as graphs, charts, or colors, will not be saved.
This feature requires that you have an Office 365 subscription or a subscription to an online service such as SharePoint Online or Exchange Online. For more information, see What is Office 365 and how does it relate to Dynamics 365 (online)?
You need a Microsoft account.
You need export to Excel privileges in Dynamics 365.
Open Dynamics 365 data in Excel Online
The option to open data in Excel Online isn’t available in all Dynamics 365 record types. If you don’t see the option, it’s not available for that record.
Updated data in Dynamics 365 won’t immediately be reflected in Excel Online if the same view was opened in the last two minutes in Excel Online. After that timeframe, any updated data should show in Excel Online.
To open a list of records in Dynamics 365 (online), click Export to Excel > Open in Excel Online.
By default, you can’t open your Dynamics 365 data in Excel Online in the Advanced Find view. However, you can save your advanced find as a personal view and then go to your personal view to do an ad-hoc analysis in Excel Online.
Save your data and import it back to Dynamics 365
On the top right, click Save Changes to Dynamics 365.
- The data for ad-hoc analysis with Excel Online is stored temporarily. Any additions, such as charts, calculations, and columns won’t be saved from the ad-hoc analysis that you do in Excel Online back to Dynamics 365. If you need to make lots of changes to your data and import it back to Dynamics 365, it’s recommended that you export the worksheet in Excel.
The file import might fail if you made a lot of changes or changed the format of the Excel file. If you need to make lots of changes to your data and import it back to Dynamics 365, it’s recommended that you export the worksheet in Excel.
By design, you can’t do a File > Save As in Excel Online. If you do, you’ll get a Can’t Save Workbook error message.
On the Data Submitted for Import dialog box, click Close.
Check the status of the data import
After you save your changes from Excel Online to Dynamics 365, verify that the data has been imported back in to Dynamics 365 (online).
In the Data Submitted for Import dialog box, click Imports.
Go to Settings > Data Management. Then click Imports.
In the list of imported files, look for your imported file and check the status.
Watch this video
Find out how to analyze your data and transform it into meaningful knowledge with Dynamics 365 (online)Excel integration.
To see video captions, click the Closed Caption (CC) button in the lower-right corner of the YouTube window.
Export to Excel is a tool provided by the XrmToolbox community developed for Dynamics 365 Customer Engagement. See the Developer tools topic for community developed tools.
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.