Use Excel to visualize data from the web UI

Article
2024-06-03

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
Start from Excel

Export the query directly from the web UI.

In Azure Data Explorer web UI, run the query and check the results.
Select the Export tab and select Open in Excel.

The query is saved as an Excel workbook in the Downloads folder.
Open the downloaded workbook to view your data. Enable editing and enable content if requested in the top ribbon.

Get data from Azure Data Explorer datasource into Excel.

Open Microsoft Excel.
In the Data tab, select Get Data > From Azure > From Azure Data Explorer.

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

Screenshot that shows the Azure Data Explorer (Kusto) window.

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.

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.
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.
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.
Select the Close & Load button to get your data into Excel.
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.

In the Table Design tab, select Summarize with PivotTable. In the Create PivotTable window, select the relevant table, and select OK.
In the PivotTable Fields pane, select the relevant table columns to create summary tables. In the following example, EventId and State are selected.
In the PivotTable Analyze tab, select PivotChart to create visuals based on the table.
In the following example, use Event Id, StartTime, and EventType to view additional information about the weather events.
Create full dashboards to monitor your data.

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

Use Excel to visualize data from the web UI

Prerequisites

View data in Excel

Analyze and visualize data in Excel

Related content

Additional resources