Forum Discussion
Solved
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 License...
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/
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.