Analyze your Dynamics 365 for Customer Engagement apps data in Excel Online

No need to leave Dynamics 365 for Customer Engagement to analyze your data. Now you can do a quick ad-hoc analysis using Microsoft Excel Online in Dynamics 365 for Customer Engagement.

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 Customer Engagement. 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.

Prerequisites

Open Customer Engagement data in Excel Online

The option to open data in Excel Online isn’t available in all Customer Engagement record types. If you don’t see the option, it’s not available for that record.

Note

Updated data in Customer Engagement 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 Customer Engagement, click Export to Excel > Open in Excel Online.

Export Dynamics 365 for Customer Engagement appsdata to Excel Online

Note

By default, you can’t open your Customer Engagement 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 Customer Engagement

  1. On the top right, click Save Changes to Customer Engagement.

    Note

    • 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 Customer Engagement. If you need to make lots of changes to your data and import it back to Customer Engagement, 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 Customer Engagement, 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.

  2. 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 Customer Engagement, verify that the data has been imported back in to Customer Engagement.

  1. In the Data Submitted for Import dialog box, click Imports.

    -OR-

    Go to Settings > Data Management. Then click Imports.

  2. 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 Customer EngagementExcel integration.

What-if analysis using Excel

To see video captions, click the Closed Caption (CC) button YouTube Closed Caption button in the lower-right corner of the YouTube window.

Banner for Dynamics 365 for Customer Engagement appsYouTube channel

Community tools

Export to Excel is a tool provided by the XrmToolbox community developed for Dynamics 365 for Customer Engagement 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.

See also

Export data to Excel
Export to Excel PivotTable
Export to Excel static worksheet
Import accounts, leads, or other data