Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Important
This feature is for public preview customers only. Features in preview might not be complete and could undergo changes before becoming available in the broader release.
You can download de-identified user-level, weekly Microsoft 365 Copilot metrics spanning the past six months using the Copilot Dashboard's data export feature. Personal identifiers are removed and replaced with anonymized IDs.
With this feature, you can create custom reports, communications, and insightful analyses to support your organization.
This capability helps you:
Understand Microsoft 365 Copilot adoption across applications and plan adoption strategies.
Track Copilot Chat adoption, including activity and usage from users without Copilot licenses.
Measure and evaluate the impact of Copilot usage across employees.
Gain deeper visibility into Copilot usage trends and patterns.
Prerequisites
License requirement – Your tenant must have at least 50 Copilot or Viva Insights licenses assigned.
Access requirement – You must have global access to the Copilot Dashboard. This includes:
Senior leaders automatically identified through Entra ID data. Learn more about how automatic access is determined.
Users manually assigned global access by admins
Delegates assigned by users with global access. Learn more about how to delegate access to Copilot Dashboard and Copilot Insights.
Viva Insights Analysts with global access
Microsoft 365 Global Administrators
Note
Users with non-global access, such as managers with team-level views, can not access this feature to export data.
Admin management
The feature is on by default for eligible tenants and users. Global admins can disable or re-enable the feature for the tenant or specific groups through Viva Feature Access Management (VFAM) in the Microsoft 365 admin center. Learn more. Changes can take up to 24 hours to appear in the web app.
How to export data
Eligible tenants and users can export directly from the Copilot Dashboard by selecting Export data.
After you select Export data, the download starts automatically in your browser.
Example export
Note
Each export contains six months of weekly aggregated Copilot metrics at the user level (with identifiers removed) across the adoption and impact pages. You can't customize the exports.
Metrics included in the exported data
| Type | Metric | Definition |
|---|---|---|
| Microsoft 365 Copilot metrics | Add content to presentation actions taken | The number of times users added a slide or image to a presentation using Copilot. |
| Chat (Copilot in Excel) prompts submitted | The number of times users submitted a prompt to Copilot Chat in Excel. Includes any prompts that don't map to one of the established Excel Copilot skills such as "Analysis," "Formatting," or "Formula" actions taken in Excel. | |
| Chat (Copilot in PowerPoint) prompts submitted | The number of times users submitted a prompt to Copilot Chat in PowerPoint. Includes any prompts that don't map to one of the established PowerPoint Copilot skills such as "Summarize," "Add content," or "Organize presentation" actions taken in PowerPoint. | |
| Chat (Copilot in Word) prompts submitted | The number of times users submitted a prompt to Copilot Chat in Word. Includes any prompts that don't map to one of the established Word Copilot skills such as "Summarize," "Draft," or "Rewrite" actions taken in Word. | |
| Compose chat message actions taken using Copilot in Teams | The number of chats and channel message drafts created in Teams using Copilot. | |
| Copilot actions taken in Copilot Chat (work) | The number of Copilot actions completed by active Copilot users in Copilot Chat (work), formerly called Business Chat. Includes prompts submitted through Teams, Outlook, Edge, and the Microsoft 365 app. | |
| Copilot actions taken in Excel | The number of Copilot actions completed by active Copilot users in Excel. | |
| Copilot actions taken in Outlook | The number of Copilot actions completed by active Copilot users in Outlook. | |
| Copilot actions taken in PowerPoint | The number of Copilot actions completed by active Copilot users in PowerPoint. | |
| Copilot actions taken in Teams | The number of Copilot actions completed by active Copilot users in Teams. This number includes the number of times users reviewed Intelligent recaps in Teams. | |
| Copilot actions taken in Word | The number of Copilot actions completed by active Copilot users in Word. | |
| Copilot Chat (web) prompts submitted | The number of queries submitted by users in the web tab of Copilot Chat, also known as "Copilot with Enterprise Data Protection." Includes prompts submitted through Edge and the Microsoft 365 app. | |
| Copilot Chat (web) prompts submitted in Teams | The number of prompts submitted to Web Chat Copilot in Teams. | |
| Copilot Chat (web) prompts submitted in Outlook | The number of prompts submitted to Web Chat Copilot in Outlook. | |
| Copilot Chat (web) prompts submitted in Word | The number of prompts submitted to Web Chat Copilot in Word. | |
| Copilot Chat (web) prompts submitted in PowerPoint | The number of prompts submitted to Web Chat Copilot in PowerPoint. | |
| Copilot Chat (web) prompts submitted in Excel | The number of prompts submitted to Web Chat Copilot in Excel. | |
| Copilot Chat (work) enabled days | The number of days the user had Copilot Chat (work), formerly called Business Chat, enabled. | |
| Copilot Chat (work) prompts submitted | The number of prompts submitted by users in Copilot Chat (work), formerly called Business Chat. Includes prompts submitted through Teams, Outlook, Edge, and the Microsoft 365 app. | |
| Copilot Chat (work) prompts submitted in Outlook | The number of Copilot Chat (work) queries submitted by users through Outlook, formerly called Business Chat. | |
| Copilot Chat (work) prompts submitted in Teams | The number of Copilot Chat (work) queries submitted by users through Teams, formerly called Business Chat. | |
| Copilot Chat (work) prompts submitted in Word | The number of prompts submitted to Work Chat Copilot in Word. | |
| Copilot Chat (work) prompts submitted in PowerPoint | The number of prompts submitted to Work Chat Copilot in PowerPoint. | |
| Copilot Chat (work) prompts submitted in Excel | The number of prompts submitted to Work Chat Copilot in Excel. | |
| Copilot enabled days for Intelligent Search | The number of days the user had Intelligent Search capabilities within Microsoft 365 Copilot enabled. | |
| Copilot enabled days for Power Platform connectors | The number of days the user had Power Platform Connectors in Microsoft 365 Copilot enabled. | |
| Copilot enabled days for Productivity App | The number of days the user had Microsoft 365 Copilot enabled in the following productivity apps: Word, PowerPoint, Excel, Outlook, Loop, OneNote, and Whiteboard. | |
| Copilot enabled days for Teams | The number of days the user had Microsoft 365 Copilot enabled within Microsoft Teams. | |
| Create Excel formula actions taken using Copilot | The number of times users generated new columns with formulas based on Excel data using Copilot. | |
| Create presentation actions taken using Copilot | The number of times users created PowerPoint presentations using Copilot. | |
| Days of active Copilot Chat (web) usage | The number of days the user was actively using the web tab of Copilot Chat (formerly Copilot with Enterprise Data Protection). | |
| Days of active Copilot Chat (work) usage | The number of days the user was actively using Copilot Chat (work), formerly called Business Chat. | |
| Days of active Copilot usage in Excel | The number of days the user was actively using Copilot in Excel. | |
| Days of active Copilot usage in Loop | The number of days the user was actively using Copilot in Loop. | |
| Days of active Copilot usage in OneNote | The number of days the user was actively using Copilot in OneNote. | |
| Days of active Copilot usage in Outlook | The number of days the user was actively using Copilot in Outlook. | |
| Days of active Copilot usage in PowerPoint | The number of days the user was actively using Copilot in PowerPoint. | |
| Days of active Copilot usage in Teams | The number of days the user was actively using Copilot in Microsoft Teams. | |
| Days of active Copilot usage in Word | The number of days the user was actively using Copilot in Word. | |
| Draft Word document actions taken using Copilot | The number of times users drafted Word documents using Copilot. | |
| Email coaching actions taken using Copilot | The number of times users selected coaching by Copilot in Outlook. | |
| Excel analysis actions taken using Copilot | The number of times users analyzed data to show insights as charts, PivotTable objects, summaries, trends, or outliers in Excel using Copilot. | |
| Excel formatting actions taken using Copilot | The number of times users highlighted, sorted, and filtered tables in Excel using Copilot. | |
| Generate email draft actions taken using Copilot in Outlook | The number of times users generated email drafts using Copilot. | |
| Intelligent recap actions taken | The number of times users accessed a meeting recap in Teams using Copilot. An action is only counted if the user selected Recap and viewed the meeting notes under the AI summary tab. | |
| Meeting hours recapped by Copilot | The number of meeting hours recapped by Copilot in Teams. Each meeting recapped represents a meeting in which the user accessed summaries through Intelligent Recap. This value is calculated on the full duration of the meeting. | |
| Meeting hours summarized by Copilot in Teams | Meeting hours summarized are calculated based on actual hours summarized, not a per action estimate. For example, if a user summarizes after a 1-hour meeting, they'll count 1 hour toward the total. If another user summarizes 15 minutes into the meeting, they'll count 15 minutes toward the total, resulting in an overall total of 1 hour, 15 minutes. This metric does not include meeting summaries accessed through Intelligent Recap. | |
| Meetings recapped by Copilot | The number of meetings recapped by Copilot in Teams. Each meeting recapped represents a meeting in which the user accessed summaries through Intelligent Recap. | |
| Organize presentation actions taken | The number of times users prompted Copilot in PowerPoint to help organize a presentation. | |
| Rewrite text actions taken using Copilot in Word | The number of times users modified text in Word documents using Copilot. | |
| Summarize chat actions taken using Copilot in Teams | The number of times users summarized chats and channel conversations in Teams using Copilot. | |
| Summarize email thread actions taken using Copilot in Outlook | The number of times users summarized email conversations with Copilot. | |
| Summarize meeting actions taken using Copilot in Teams | The number of times users summarized meetings using Copilot. Each action represents a user sending a prompt in the meeting Copilot dialog (including suggested prompts and user-generated prompts). This metric does not include meeting summaries accessed through Intelligent Recap. | |
| Summarize presentation actions taken using Copilot in PowerPoint | The number of times users summarized PowerPoint presentations with Copilot. | |
| Summarize Word document actions taken using Copilot in Word | The number of times users summarized Word documents using Copilot. | |
| Total chat conversations summarized by Copilot in Teams | The number of chats and channel conversations summarized by Copilot. | |
| Total Copilot actions taken | The total number of actions completed with Copilot by users with Copilot Chat or other in-app Copilot features. With automatically-generated Copilot insights such as Intelligent Recap or auto-summarizations in Word, an action is only counted if the user viewed the results from Copilot, such as expanding the document summary. This metric might also include Copilot actions taken using Copilot features that are not available in the Copilot Dashboard or analyst workbench as standalone metrics. (Viva Insights' individual Copilot metrics don't provide a comprehensive view of all Copilot features and total actions taken.) | |
| Total Copilot active days | The number of days the user was actively using Copilot in any of the apps. | |
| Total Copilot enabled days | The number of days the user had at least one service plan for Copilot enabled. | |
| Total emails sent using Copilot in Outlook | The number of emails sent with assistance from Copilot. | |
| Total meetings summarized by Copilot in Teams | The number of meetings summarized by Copilot. Each meeting summarized represents a meeting where the user sent a prompt in the meeting Copilot dialog (including suggested prompts and user-generated prompts). This metric does not include meeting summaries accessed through Intelligent Recap. | |
| Visualize as table actions taken using Copilot in Word | The number of times users converted text to a table with Copilot in Word. | |
| Total meetings summarized or recapped by Copilot | The number of meetings recapped by Copilot in Teams. Each meeting recapped represents a meeting in which the user accessed summaries through Intelligent Recap. | |
| Total meeting hours summarized or recapped by Copilot | The number of meetings summarized or recapped by Copilot in Teams. Each meeting summarized represents a meeting in which the user sent a prompt in the meeting Copilot dialog (including suggested prompts and user-generated prompts). Recapped meetings represent summaries accessed through Intelligent Recap. | |
| Copilot Chat metrics (without Copilot license) | Days of active Copilot Chat usage (without Copilot license) | The number of days the user was actively using Copilot chat (without Copilot license). |
| Days of active Copilot Chat usage in Edge (without Copilot license) | The number of days the user was actively using Copilot Chat in Edge (without Copilot license). | |
| Days of active Copilot Chat usage in Copilot app (without Copilot license) | The number of days the user was actively using Copilot Chat in Copilot app (without Copilot license). | |
| Days of active Copilot Chat usage in Teams (without Copilot license) | The number of days the user was actively using Copilot Chat in Teams (without Copilot license). | |
| Days of active Copilot Chat usage in Outlook (without Copilot license) | The number of days the user was actively using Copilot Chat in Outlook (without Copilot license). | |
| Days of active Copilot Chat usage in Word (without Copilot license) | The number of days the user was actively using Copilot Chat in Word (without Copilot license). | |
| Days of active Copilot Chat usage in Excel (without Copilot license) | The number of days the user was actively using Copilot Chat in Excel (without Copilot license). | |
| Days of active Copilot Chat usage in PowerPoint (without Copilot license) | The number of days the user was actively using Copilot Chat in PowerPoint (without Copilot license). | |
| Copilot Chat prompts submitted (without Copilot license) | The number of prompts submitted to Copilot Chat (without Copilot license). | |
| Copilot Chat prompts submitted in Edge (without Copilot license) | The number of prompts submitted to Copilot Chat in Edge (without Copilot license). | |
| Copilot Chat prompts submitted in Copilot app (without Copilot license) | The number of prompts submitted to Copilot Chat in Copilot app (without Copilot license). | |
| Copilot Chat prompts submitted in Teams (without Copilot license) | The number of prompts submitted to Copilot Chat in Teams (without Copilot license). | |
| Copilot Chat prompts submitted in Outlook (without Copilot license) | The number of prompts submitted to Copilot Chat in Outlook (without Copilot license). | |
| Copilot Chat prompts submitted in Word (without Copilot license) | The number of prompts submitted to Copilot Chat in Word (without Copilot license). | |
| Copilot Chat prompts submitted in Excel (without Copilot license) | The number of prompts submitted to Copilot Chat in Excel (without Copilot license). | |
| Copilot Chat prompts submitted in PowerPoint (without Copilot license) | The number of prompts submitted to Copilot Chat in PowerPoint (without Copilot license). | |
| Usage intensity and returning users metrics | Returning Copilot Chat user (most recent and prior 28 days) | Whether user performed any intentional Copilot Chat unlicensed action during the most recent 28-day period and in the prior 28-day period. |
| Returning Copilot Chat user (most recent and prior 7 days) | Whether user performed an intentional Copilot Chat unlicensed action during the most recent 7-day period and in the prior 7-day period. | |
| Returning Microsoft 365 Copilot user (most recent and prior 28 days) | Whether user performed any intentional Copilot activity during the most recent 28-day period and in the prior 28-day period. | |
| Returning Microsoft 365 Copilot user (most recent and prior 7 days) | Whether user performed any intentional Copilot activity during the most recent 7-day period and in the prior 7-day period. | |
| Number of weeks active in Microsoft 365 Copilot (most recent 28 days) | The number of weeks the user had any activity in any Microsoft 365 Copilot app (Word, Excel, PowerPoint, Teams, Outlook, Loop, OneNote, Business Chat (work), or Business Chat (web)) in the given 28-day period. | |
| Number of weeks active in Copilot Chat (most recent 28 days) | The number of weeks the user had any Copilot Chat unlicensed action in the given 28-day period. |
HR attributes included in the exported data
| Attribute name | Description |
|---|---|
| Organization | Determined by Entra ID or through an organizational data file uploaded by admins. |
| FunctionType (Job function) | Determined by the organizational data file uploaded by admins. If the file doesn't include this field, the column appears blank in the export. |
Learn more about the attributes used in the Copilot Dashboard.
FAQs
Q1: My organization only wants certain users to access the data export feature. Can I configure that?
The data export feature is available by default to users with global access to the Copilot Dashboard. Global admins can disable or re-enable access for specific tenants or groups through VFAM in the Microsoft 365 admin center at any time. Allow up to 24 hours for changes to appear in the web app.
Q2: I'm a senior leader with access to the data export feature. If I delegate my access to my chief of staff, will they automatically have access too?
Yes. Delegates of users with global access automatically inherit data export access, unless your organization's admin policy disables it. Admins can adjust these settings at any time through VFAM in the Microsoft 365 admin center.
Q3: I have access to the Copilot Dashboard, but I don't see the data export option. Why?
Data export is available only to users with global access to the Copilot Dashboard. Managers or their delegates with team-level views don't have access. If you do have global access and still can't see the feature, your admins might have disabled it. Contact them for details.
Q4: How often is the export data updated?
The export includes the past six months of weekly Copilot metrics at the user level (anonymized IDs), up to the most recent complete week (Sunday–Saturday) for which metrics are available.
For example, if metrics are available through October 22 (Wednesday), a partial week, the export includes data through the week of October 12–18.
The dataset refreshes weekly.
Q5: How should I interpret the usage intensity and returning user metrics?
These metrics show whether users are engaging with Microsoft 365 Copilot or Copilot Chat over consecutive 7- or 28-day periods.
For example:
Returning Microsoft 365 Copilot user (28 days): This metric shows whether a user performed any Copilot activity during two consecutive 28-day periods. For example, if a user was active between Aug. 31 and Sept. 27 and again between Sept. 28 and Oct. 25, they would be counted as a returning user. This helps identify users who are maintaining ongoing engagement with Copilot.
Number of weeks active in Copilot Chat (28 days): This metric shows how many weeks within the past four weeks a user was active in Copilot Chat. For example, if a person used Copilot Chat for three out of the past four weeks, the metric value would be 3. This helps assess how consistently users interact with Copilot Chat.
Q6: How do these metric values compare with metrics in advanced analysis for Viva Insights Analysts?
Metric definitions remain consistent across both experiences, as long as the same time period and filters are used.
Exported data, however, includes additional metrics – such as Copilot Chat (without license) and usage intensity metrics – that can help deepen your understanding of Copilot adoption and support AI transformation across your organization.
Q7: We're a large organization, and the export file is sometimes very large. What's the best way to open it?
For smaller datasets, you can open the export file directly in supported applications such as Microsoft Excel.
However, for larger files, use business intelligence (BI) tools such as Power BI to import and analyze the data. These tools are better suited for handling large datasets efficiently and provide more flexibility for analysis, filtering, and visualization.
Q8: We don't see the "Copilot assisted hours" metric in this export. Will it be available in the future?
The data export feature is focused on Copilot actions and usage metrics. Additional metrics will be included over time.
Q9: I don't see the download, or the download seems stuck. What should I do?
Large files might take additional time to process and download. If the browser download doesn't start right away, stay on the page and avoid closing it until the download begins. If you see an error message, wait a little bit, then select Export data again later.
If the download still appears to be stuck, check for any network connectivity issues.