Exporting Application Insights data to Excel – It’s just a single click !

By | December 4, 2015

While most of us are familiar with exporting telemetry from Application Insights using Continuous Export, I have seen many of us easily overlooked the export feature to an excel. Though it is a manual job for you; and export the data for that specific instance,  but sometime if you want to get some sample of data and have some your own calculation it could really help.  Export to Excel option is available in the Azure Portal and you can export events, metrics data etc. to an excel just by a single click.

Consider you have following set of data for Server Response.

image

Then click on the “Export” icon to export the data into an excel file.  Open the excel file and move around the different sheet to have a look in the data for the instance when the data was imported.

Related Post :  Get your Application Insights data in Power BI – Faster than ever 

 

Sample Excel Sheet with Application Insights Exported Data

Sample Excel Sheet with Application Insights Exported Data

Then you can easily convert those data to some pivot representation for better analysis.

image

The data for each chart is exported to a separate sheet in the Excel file. For a server response data metrics, you can find following list of excel sheet with different set of data. If you export a different set of data from the Application Portal, your data set and sheet would be different.

image

And again, this will export the data for the instance (Time frame) you are viewing and exporting; If you want data continuously exported so that you can process it externally, you have to go with continuous export option