Use Excel to visualize data from the web UI

This article shows you how to view your query in Excel, by exporting directly from the web UI or importing into Excel.

Prerequisites

• A Microsoft account or a Microsoft Entra user identity to sign in to the help cluster.

View data in Excel

You can use the following options to query data in Excel:

Start from the web UI

Export the query directly from the web UI.

1. In Azure Data Explorer web UI, run the query and check the results.

2. Select the Export tab and select Open in Excel.

   

   The query is saved as an Excel workbook in the Downloads folder.

3. Open the downloaded workbook to view your data. Enable editing and enable content if requested in the top ribbon.

Start from Excel

Get data from Azure Data Explorer datasource into Excel.

1. Open Microsoft Excel.

2. In the Data tab, select Get Data > From Azure > From Azure Data Explorer.

   

3. In the Azure Data Explorer (Kusto) window, complete the following fields and select OK.

   

   Field	Description
   Cluster	Name of cluster, for example Help (mandatory)
   Database	Name of database, for example Samples
   Table name or Azure Data Explorer query	Name of table or Azure Data Explorer query, for example table name StormEvents

   Advanced Options:

   Field	Description
   Limit query result record number	Limit the number of records loaded into excel
   Limit query result data size (bytes)	Limit the data size
   Disable result-set truncation
   Additional Set statements (separated by semicolons)	Add set statements to apply to data source

   Repeat the previous steps to add more queries. You can rename the queries to more meaningful names.

4. If sign-in is required, a pop-up box appears. Select Organizational account and Sign in. Complete the sign-in process and then select Connect.

   

5. In the Navigator pane, navigate to the correct table. In the table preview pane, select Transform Data to open the Power Query Editor and make changes to your data, or select Load to load it straight to Excel.

   

   Tip

   If Database and/or Table name or Azure Data Explorer query are already specified, the correct table preview pane will open automatically.

6. If you select Transform Data, the Power Query Editor window opens. In the window, select Advanced Editor.

   

   In the Advanced Editor window, you can edit the query and select Done to keep your changes.

   

7. Select the Close & Load button to get your data into Excel.

   

8. Select the Refresh button under the Table Design tab to refresh the query.

   

Analyze and visualize data in Excel

Once the data loads to excel and is available in your Excel sheet, you can analyze, summarize, and visualize the data by creating relationships and visuals.

1. In the Table Design tab, select Summarize with PivotTable. In the Create PivotTable window, select the relevant table, and select OK.

   

2. In the PivotTable Fields pane, select the relevant table columns to create summary tables. In the following example, EventId and State are selected.

   

3. In the PivotTable Analyze tab, select PivotChart to create visuals based on the table.

   

4. In the following example, use Event Id, StartTime, and EventType to view additional information about the weather events.

   

5. Create full dashboards to monitor your data.

Related content

To learn about other ways to visualize your data, see Visualization integrations overview.