Fix Unable to Export Active Users from Microsoft 365 Admin Center
Question details
The user is trying to export the Active Users list from the Microsoft 365 admin center, but the export process fails to complete.

- Product
- Microsoft 365 Admin Center
- Device & OS
- not provided
- Scenario
- Attempting to download a CSV report of active users for administration or auditing purposes.
- Observed behavior
- The export process gets stuck or fails to finish, even when the user is signed in with correct Global Administrator credentials.
Ensure that you are signed in with an account that has Global Administrator or User Administrator privileges, and check the Microsoft 365 Service Health dashboard to verify there are no ongoing outages affecting admin portal reporting.
Troubleshoot Browser and Network Issues
Clear local browser data and test alternative connections to bypass cache conflicts or network restrictions blocking the export script.
Often, admin center scripts fail to execute properly because of corrupted cookies, stale cache, or browser extensions interfering with the export popup.
Open a Private or Incognito browsing window (e.g., press Ctrl+Shift+N in Chrome or Edge) and log into the Microsoft 365 admin center to attempt the export again.
If the private window works, return to your normal browser window, navigate to your browser's Privacy settings, and clear the cache and cookies.
Check your browser's settings to ensure it is updated to the latest version, as outdated versions may struggle with modern admin portal scripts.
If you are on a restricted corporate network or mobile data, switch to an alternative Wi-Fi network to rule out firewall or connection drops interrupting the download.

Use PowerShell (Microsoft Graph) as an Alternative
If the web interface continues to fail, you can bypass the admin center entirely and export user lists using PowerShell.
Manage and Analyze Your Exported User Data with WPS Office
Once you successfully export your Active Users list from Microsoft 365, you will need a reliable spreadsheet tool to open and analyze the resulting CSV file. WPS Office is a free, lightweight, and powerful alternative to Microsoft Office that seamlessly handles large administrative datasets.
- 1. Download the Software: Visit the official WPS website to download and install the free WPS Office suite on your device.
- 2. Open the CSV File: Launch WPS Spreadsheet, click 'File' > 'Open', and select the Active Users CSV file you exported from Microsoft 365.
- 3. Organize Your Data: Use the 'Data' tab to apply filters, sort by user roles, and format the columns for easier administrative reviewing.

Frequently Asked Questions
Why does the Active User export fail in the Microsoft 365 Admin Center?
This issue is typically caused by corrupted browser cache, outdated browser versions, network instability, or temporary service degradation on Microsoft's end preventing the background export script from finishing.
How long should a Microsoft 365 active user export take?
For most small to medium organizations, the CSV export should complete within a few seconds to a minute. If it takes longer than 10-15 minutes and appears stuck, the session has likely timed out and you should restart the process.
Do I need Global Admin rights to export users?
No, while Global Admin credentials work, you can also successfully export the active user list if your account is assigned the User Administrator role or equivalent reporting permissions.




