Skip to main content Link Menu Expand (external link) Document Search Copy Copied
Copilot for M365

Task 1.3: Export the report data into an Excel file

  1. Scroll down to the Copilot usage details section and near the end of the table column headers, select Choose columns to add or remove columns from the table. You can customize the table to show only the columns that are relevant to you.

    a4.jpg

    This section shows the list of users who have Microsoft 365 Copilot licenses and their last activity date for each product. You can sort, filter, and search the table by any column.

  2. Select Export to download the table.

  3. Save the .csv file to your local drive or a cloud storage location.

    You can open the file to review the report data in a tabular format.

  4. Open the downloaded .csv file in Microsoft Excel. You can use the built-in features of Excel to further analyze, visualize, and share the report data.

    For example, you can create pivot tables, charts, or dashboards to highlight the key insights from the report data.