Forum Discussion
M365 User export CSV format changed
Has anyone else noticed that the format for the "Export Users" feature in the Microsoft 365 admin center changed? It's missing some columns (fields) and no longer has a delimiter between the Licenses. This makes using this file for license reviews impossible.
You can always get the same info via PowerShell, and format it per your preference. And there are plenty ready-to-use script samples available online, if you don't feel like creating your own. Here's one of Tony's: https://practical365.com/create-licensing-report-microsoft365-tenant/
9 Replies
I opened a case with Microsoft. The engineer was aware of the change, but had no documentation about it, so we closed the case. I also recently noticed that they changed the columns in the export again. I had to rework one of my automated processes again because of this. However, one good point is that the Licenses field now contains a "+" delimiter like it did in the old report. The only thing I think is an outstanding bug is in the UserStatus field. It shows guests as "Guest", but it shows "Unlicensed" for unlicensed members and a list of non-delimited licenses for licensed members. I feel it should just show "Member" for member accounts. I can work around this issue, so it's not a problem for me.
Yes, I have reworked all Power Automate, Power BI and Power Query.
Just pray hard and no more changes again.
GaelBT, Interesting. I didn't know what the back end of the Export user feature was. I'm curious, do you remember where you heard that? The timing of the change sounds reasonable. I just saw another notification about the retirement and that there will be brief outages in the coming months while they prepare for the retirement.
Thanks for pointing that out. We also have some of our own PowerShell scripts. it's just surprising that Microsoft would change this output format, especially the lack of delimiter in the license field, without any warning or Microsoft specified alternative. I've already had to update several of our processes because of this.
I’ve noticed that too! The new format is definitely a hassle, especially with missing columns and no delimiter for licenses. It really complicates license reviews. 😕 Have you tried contacting Microsoft support? Fingers crossed they can provide some clarity or offer a workaround.
You can always get the same info via PowerShell, and format it per your preference. And there are plenty ready-to-use script samples available online, if you don't feel like creating your own. Here's one of Tony's: https://practical365.com/create-licensing-report-microsoft365-tenant/
I have same issue.
I have same issue. I thought it is the preparation of Microsof MSOnline module's retirement. The "Export Users" feature is based on cmdlet Get-Msoluser which is retired soon on March 2025 and Microsoft now uses Get-Mguser for feature "Export User".
It changed again with more columns.
This make all automation and power query falls a part.
