M365 User Details

Export / Import (in bulk) your users’ Microsoft 365 Azure AD Details using CSV files. Also creates CSV reports that export existing details.

M365UserDetailsReport.ps1

Use the report tool to export your users’ telephone numbers, etc properties.
It will generate a file like this:

Then create a M365UserDetailsUpdate.csv (make a copy of the above) with the rows (users) and columns (properties) you want to update.

  • The first column must be Mail (the user to update)
  • Add additional columns for each property you want to change (use the export csv as a guide)
  • If you want to update a property, enter the new value in the CSV.
  • If you want to leave a property as-is, just leave it blank in the CSV.
  • If you want to clear a property, use the keyword in the CSV (include the angle brackets in the text).
ExcelUpdate

M365UserDetailsUpdate.ps1

UpdateRun

Full directions from GitHub here

Leave a Reply

Your email address will not be published. Required fields are marked *