How to Retrieve Microsoft 365 Apps Usage and Version Data
Question details
Administrators need to retrieve and integrate Microsoft 365 Apps usage and version data into a web application.

- Product
- Microsoft 365 Admin Center
- Device & OS
- not provided
- Scenario
- Integrating user activity data for applications like Word, Excel, and PowerPoint, along with version details, into a custom web application via APIs.
- Observed behavior
- Standard Microsoft Graph usage reports do not consistently include detailed desktop application usage and specific software version information.
Ensure you have Global Administrator or Reports Reader permissions in your Microsoft 365 tenant to access and export usage data.
Export Data via Microsoft 365 Admin Center
Use the built-in reporting tools in the Microsoft 365 admin center to view and export general user activity data.
The Microsoft 365 admin center provides native dashboard reports for tracking active usage across services like Word, Excel, and PowerPoint.
Navigate to the Microsoft 365 admin center and log in with your administrator credentials.
In the left-hand navigation pane, click on 'Reports' and then select 'Usage'.
Scroll to the 'Microsoft 365 Apps' section to view detailed activity metrics for specific Office applications.
Click the 'Export' link or button on the dashboard to download the current usage data as a CSV file for manual analysis or integration preparation.

Query Microsoft Graph and Entra ID Logs
Utilize Microsoft Graph reporting APIs and Microsoft Entra ID for programmable access to sign-in logs and app usage.
Looking for a simpler, cost-effective office suite?
While Microsoft 365 offers extensive enterprise reporting APIs, managing and extracting complex usage data can be incredibly time-consuming. WPS Office provides a free, lightweight, and highly compatible alternative that simplifies software deployment across your organization without the overhead of complex administration.
- 1. Download the installer: Visit the official WPS Office website and click the Free Download button.
- 2. Install the application: Run the downloaded setup file and follow the straightforward on-screen instructions.
- 3. Start working immediately: Open WPS Office to instantly begin creating or editing Word, Excel, and PowerPoint documents with no complex setup.

Frequently Asked Questions
Can I get detailed desktop app versions using standard Graph API usage reports?
Standard Microsoft Graph usage APIs typically do not provide granular version details for desktop installations of Word, Excel, or PowerPoint. Administrators often need to rely on Microsoft Endpoint Configuration Manager (SCCM) or Intune for detailed hardware and software inventory.
What permissions are required to access Microsoft 365 usage reports?
To view and export usage data, your account must be assigned the Global Administrator, Exchange Administrator, SharePoint Administrator, or Reports Reader role within your Microsoft Entra ID tenant.
Where can I find development help for Microsoft Graph API integration?
For integrating usage data into a custom web application, it is highly recommended to consult the official Microsoft Graph documentation, participate in the Microsoft Q&A developer forums, or check relevant community repositories on GitHub.




