Microsoft 365 Admin Centre - changing fields

Question

Me and my manager do a download from the Microsoft Admin Centre every Wednesday to update a dashboard. This is completed by going to Active Users and then "export users" we didn't change any columns or apply any filters. This produced a CSV file with the following fields..

Block credential
Billing Country
User / Non User Account
City
Country/Region
Department
DirSyncEnabled
Display name
Fax
First name
Last dirsync time
Last name
Last password change time stamp
License assignment details
Licenses
Mobile Phone
Oath token meta data
Object Id
Office
Password never expires
Phone number
Postal code
Preferred data location
Preferred language
Proxy addresses
Release track
Soft deletion time stamp
State
Street address
Strong password required
Title
Usage location
User principal name
When created

We have both changed nothing and when we now do this export it's missing the following fields

Billing Country
User / Non User Account
Country/Region
License assignment details
Oath token meta data
Release track
Strong password required
Title

The most important parts of information we need are "Billing Country" and "User/Non User" (not included in current export) and Licenses and User Principle Name (in current export).

I thought this could be fixed by going to "Active Users" then clicking "Choose Columns" but we only have the following options: Username, licenses, guest, sign-in status, sync status,city, country or region, department, first name, last name, title, office, state or province, usage location. How can this be fixed?

Answer 1

Hi Jemma_BSST

Good day! Thank you for posting to Microsoft Community. We are happy to assist you.

I am truly sorry for the inconvenience this issue has caused you. Based on the description, I understand that you would like to export user information in M365 with certain fields.

After doing lots of research and tests, I regret to inform you that the 'Export users' function in M365 admin center - Users - Active users page do not support customization. In order to export specific user information, I kindly suggest use the PowerShell cmdlets to accomplish this task. For details, please see: View Microsoft 365 user accounts with PowerShell - Microsoft 365 Enterprise | Microsoft Learn

We do understand your concern about this feature that how it helps you to improve your efficiency in such daily busy work schedule but as it is related with Microsoft 365 admin center product design, so it is strongly recommended to submit your valuable feedback directly to Microsoft product development team by either go to Give Feedback button at the bottom right corner of the page or by posting on Ideas · Community (microsoft.com) for feature requests. 

Please note that nobody here are the product developers/decision makers and has no control over the product. Everyone, including us as community moderator, can only assist you on the query for providing available solutions and feature's availability status within our scope and capability.

To check more details about how to submit feedback, kindly refer this article Learn about how to provide feedback to Microsoft - Microsoft 365 admin | Microsoft Learn.

Your understanding and cooperation are greatly appreciated.

Sincerely,

Roger Shen