# Analyze Open in Excel telemetry
APPLIES TO: Business Central 2026 release wave 2 and later
Open in Excel telemetry gathers data about when users export data from Business Central to Excel using the Open in Excel action. See /across-work-with-excel#open-in-excel.
## Open in Excel
Occurs when a user successfully opens a page in Excel.
### General dimensions
Dimension|Description or value
message|Open in Excel: {pageName} where {pageName} is the name of the page that was opened in Excel.
user_Id|The user telemetry ID for the user. From the user card, you can use user_Id to identify the user who triggered this telemetry event. See telemetry-enable-application-insights#assign-a-telemetry-id-to-users.
### Custom dimensions
Dimension|Description or value
aadTenantId|Specifies the Microsoft Entra tenant ID used for Microsoft Entra authentication. For on-premises, if you aren't using Microsoft Entra authentication, this value is common.
alObjectId|Specifies the ID of the page that was opened in Excel.
alObjectName|Specifies the name of the page that was opened in Excel.
alObjectType|Specifies the type of the AL object. Value is Page.
alStackTrace|The stack trace in AL.
clientType|Specifies the type of client that opened the session, such as Background or Web. For a list of the client types, see ClientType Option Type<../developer/methods-auto/clienttype/clienttype-option>.
companyName|The current company name.
component|Dynamics 365 Business Central Server
componentVersion|Specifies the version number of the component that emits telemetry.
environmentName|Specifies the name of the tenant environment. See Managing Environments<tenant-admin-center-environments>.
environmentType|Specifies the environment type for the tenant, such as Production or Sandbox. See tenant-admin-center-environments#types-of-environments.
eventId|RT0056
extensionId|Specifies the GUID of the extension that defines the page.
extensionName|Specifies the name of the extension that defines the page.
extensionPublisher|Specifies the publisher of the extension that defines the page.
extensionVersion|Specifies the version of the extension that defines the page.
### Sample KQL code
```kql
traces
| where timestamp > ago(60d)
| where customDimensions.eventId == 'RT0056'
| project timestamp
, message
, aadTenantId = customDimensions.aadTenantId
, environmentName = customDimensions.environmentName
, environmentType = customDimensions.environmentType
, companyName = customDimensions.companyName
, clientType = customDimensions.clientType
, alObjectId = customDimensions.alObjectId
, alObjectName = customDimensions.alObjectName
, alStackTrace = customDimensions.alStackTrace
, extensionName = customDimensions.extensionName
, extensionPublisher = customDimensions.extensionPublisher
, extensionVersion = customDimensions.extensionVersion
```
To learn more about how to set up alerting on Business Central telemetry, see telemetry-alert.
## Related information
Monitoring and Analyzing Telemetry<telemetry-overview>
Enable Sending Telemetry to Application Insights<telemetry-enable-application-insights>

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/telemetry-open-in-excel-trace, MicrosoftDocs/dynamics365smb-devitpro-pb at 828b6ee (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/dev-itpro/administration/telemetry-open-in-excel-trace/
