License & Subscription Issues

How to Export Microsoft Subscription and License Data to Excel or CSV

WPS Editor Oct 1, 2026 868 views

Question details

Administrators need a way to export comprehensive Microsoft subscription and license expiration data to Excel or CSV for automated renewal reminders and audits.

How to Export Microsoft Subscription and License Data to Excel or CSV

Product: Microsoft 365 Admin Center
Device & OS: not provided
Scenario: Generating comprehensive automated renewal reminders and administrative reports.
Observed behavior: The default Microsoft 365 Admin Center interface does not provide every necessary expiration and license field in a single combined export.

Before you start

Ensure you have Global Administrator or Billing Administrator privileges in your Microsoft 365 tenant, and verify that you have basic familiarity with REST APIs or Microsoft Power Automate.

Solution 1Recommended

Use Microsoft Graph API to Retrieve and Export Data

Programmatically fetch granular subscription and license details using the Microsoft Graph API to generate customized Excel or CSV files.

By utilizing the Microsoft Graph API, administrators can extract specific details about subscribed SKUs, users, and assigned licenses that aren't natively bundled in the standard Admin Center export feature.

Register an application in Microsoft Entra ID

Log in to the Azure Portal, navigate to Microsoft Entra ID, and register a new application. Grant it the 'Organization.Read.All' or 'Directory.Read.All' API permissions and grant admin consent.

Obtain an authentication token

Configure your application or script to authenticate using OAuth 2.0 and request an access token from the Microsoft identity platform.

Query the Graph API endpoint

Make a GET request to the 'https://graph.microsoft.com/v1.0/subscribedSkus' endpoint to retrieve detailed license usage and expiration data.

Parse and format the data

Parse the returned JSON response using your preferred scripting language (such as PowerShell or Python) and map the extracted data into CSV format or directly write it to an Excel workbook.

Automate the workflow

Schedule this script using Azure Functions or a local cron job, or use Power Automate to seamlessly push the parsed data into a designated Excel file on SharePoint.

Use Microsoft Graph API to Retrieve and Export Data

Community Support: For specialized workflow implementation and detailed setup in Power Automate, consider seeking assistance in the official Power Platform or Power Apps community forums.

Free Microsoft Office alternative

Analyze Your Exported CSV and Excel Reports with WPS Office

Once you have successfully exported your Microsoft subscription data via Graph API, you can seamlessly open, analyze, and format your CSV and Excel files using WPS Office. It provides a lightweight, fast, and feature-rich spreadsheet environment without the heavy subscription costs.

1. Download and install: Download WPS Office from the official website and follow the installation wizard.
2. Open WPS Spreadsheets: Launch the application and select 'Spreadsheets' from the main dashboard.
3. Import your CSV or Excel file: Click 'File', select 'Open', and choose your exported Microsoft subscription data file to begin your analysis.

Fully compatible with Microsoft Excel formats including .xlsx, .xls, and .csvIdeal for efficiently opening and formatting API-exported CSV admin reportsFree to use with a familiar spreadsheet interface for instant data analysisLightweight installation ensures smooth performance even with large datasets

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't the Microsoft 365 Admin Center include all expiration fields in its default export?

The default Admin Center interface provides simplified summaries tailored for general billing overviews. To retrieve granular, combined datasets—such as specific expiration dates linked directly to assigned users—custom queries via the Microsoft Graph API are required.

Can I use Power Automate to export Microsoft subscription data to Excel?

Yes. You can use the 'HTTP' action in Power Automate to call the Microsoft Graph API, parse the JSON response, and then use the 'Add a row into a table' action in Excel Online to automatically populate a spreadsheet.

How do I convert a Microsoft Graph API JSON response into a CSV file?

You can process the JSON output using scripting languages like PowerShell or Python. By mapping the required JSON keys (such as skuId, consumedUnits, and nextLifecycleDateTime) into custom objects or data frames, you can then export the array as a CSV file using native export commands.

What permissions are needed to read Microsoft license data via Graph API?

To read subscription and license data, your application generally requires 'Directory.Read.All', 'Organization.Read.All', or specific 'SubscribedSku.Read.All' delegated or application permissions. These must be granted and consented to by a Global Administrator in Microsoft Entra ID.

Login & Account Issues