Overview:
This guide explains how to export a list of all users from the Microsoft 365 Admin Center, including details such as names, email addresses, licenses, and roles.
—————
Step 1: Sign in
1. Go to https://admin.microsoft.com
2. Sign in using your Global Administrator or User Administrator credentials.
—————
Step 2: Open the Active Users page
1. In the left-hand menu, click Users → Active users.
2. You will see a list of all licensed and unlicensed users in your organization.
—————
Step 3: Filter or customize your view (optional)
- You can use the Filters or Columns buttons at the top of the list to adjust which details are shown.
- Common columns include:
- Display Name
- Username (email address)
- Licenses Assigned
- Roles
- Sign-in Status
—————
Step 4: Export the list
1. At the top-right of the Active Users list, look for the three dots (•••) menu if you do not immediately see the Export Users option.
2. Click the three dots, and then select Export Users from the dropdown.
3. Choose whether you want to download:
- All users
- Only the filtered view (if you applied filters)
4. The export will download as a CSV file (typically named ActiveUsers.csv).
—————
Step 5: Open and save the file
- Open the downloaded CSV file using Microsoft Excel or another spreadsheet tool.
- Review, edit, or save the file as needed for reporting, license management, or audit purposes.
—————
Tip:
For more advanced exports that include additional data (for example, Department, Job Title, or Last Sign-in), you can use PowerShell:
Connect-MgGraph -Scopes "User.Read.All"
Get-MgUser -All | Select DisplayName, UserPrincipalName, Department, JobTitle | Export-Csv -Path "C:\UserList.csv" -NoTypeInformation