Others

How to Fix Missing User Fields in Microsoft 365 Admin Center Export

Maira Mehtab Sep 22, 2026 869 views

Question details

Users need to export a comprehensive list of active users from the Microsoft 365 Admin Center, but find that crucial data fields are missing from the exported file.

Product: Microsoft 365 Admin Center
Device & OS: not provided
Scenario: Exporting active user data and license details for administrative reporting, auditing, or billing purposes.
Observed behavior: The default Active Users export omits specific details such as billing country, account type, license details, licenses, and user principal name.

Before you start

Ensure you have Microsoft 365 global admin or user management permissions and that the Microsoft 365 PowerShell module is installed on your computer.

Solution 1Recommended

Use Microsoft 365 PowerShell to Export Custom User Fields

Since the Admin Center does not support custom export columns, running PowerShell cmdlets is the recommended method to retrieve complete user data including licenses and billing country.

The built-in Export Users feature in the Microsoft 365 Admin Center is limited to a pre-defined set of columns. To extract specific data attributes like license details and account types, administrators must utilize PowerShell to generate a custom CSV file.

Open PowerShell as Administrator

Click the Windows Start menu, type 'PowerShell', right-click the Windows PowerShell application, and select 'Run as administrator'.

Connect to Microsoft 365

Type the command `Connect-MsolService` or `Connect-MgGraph` depending on your installed module, and press Enter. Log in with your administrator credentials.

Run the Export Command

Execute a cmdlet to retrieve the users and select the exact properties you need. For example: `Get-MsolUser -All | Select-Object UserPrincipalName, UsageLocation, Licenses | Export-Csv -Path C:\UsersExport.csv -NoTypeInformation`.

Verify the Exported File

Navigate to the C:\ drive on your computer and open the 'UsersExport.csv' file to ensure the previously missing fields are now populated correctly.

Submit a Feature Request: You can request Microsoft to add these custom columns to the Admin Center UI by submitting feedback through the admin center's Feedback option or the Microsoft feedback portal.

Free Microsoft Office alternative

View and Analyze Your Admin Exports Seamlessly with WPS Office

After exporting your customized Microsoft 365 user data via PowerShell, you will need a robust spreadsheet application to view and manage the CSV files. WPS Office provides a lightweight, free alternative to Microsoft Office that handles large data exports with ease.

1. Download and Install: Get WPS Office for free from the official website and install it on your computer.
2. Open the Exported CSV: Launch WPS Spreadsheet, click on 'Menu' > 'Open', and select the CSV file you generated via PowerShell.
3. Analyze the Data: Use built-in tools like Filters and PivotTables under the 'Data' tab to easily manage and sort your Microsoft 365 user records.

Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formats without data loss.Lightweight installation ensures fast loading of large administrative CSV exports.Familiar user interface requires no learning curve for easy migration.Completely free to use for viewing, filtering, and analyzing tabular data.

microsoft office alternative - wps office

Frequently Asked Questions

Why are fields like billing country and licenses missing from my Microsoft 365 export?

The Microsoft 365 Admin Center's standard 'Export Users' feature uses a default template that does not support customized column selection. It intentionally omits certain fields to keep the default export simplified, requiring PowerShell for detailed attributes.

Can I customize the active user export columns directly in the Admin Center interface?

No, it is currently not possible to customize or add specific columns to the export directly through the Microsoft 365 Admin Center user interface. You must use PowerShell commands as a workaround.

How do I ask Microsoft to include these missing fields in future updates?

You can request this feature by clicking the 'Feedback' option located in the lower right corner of the Microsoft 365 Admin Center, or by submitting your suggestion on the official Microsoft feedback portal.

Office Quick Solutions