Batch edit accounts username

曾銘康 TSANG MING HONG 21

Instead of changing it one by one, Are there any method, such as export and import, to edit many accounts' username at once?

https://learn.microsoft.com/zh-tw/microsoft-365/admin/add-users/change-a-user-name-and-email-address?view=o365-worldwide

Accepted answer

Vasil Michev 94,911 Reputation points MVP

2020-08-26T09:11:50.627+00:00

Yes, you can easily do this via PowerShell or the Graph API. If you want an example, you need to tell us which property specifically you are looking to change and sample values.

The M365 admin portal and the EAC allow you to perform batch operations:
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

1 additional answer

曾銘康 TSANG MING HONG 21 Reputation points

2020-08-26T10:13:16.603+00:00

Thanks for replying!!

Here is an example of my situation.
I need to change the surnames of many accounts to capital letters. such as:
acc 1. Chan > CHAN
acc 2. Lee > LEE
acc 3. Wong > WONG
...

How should I do?
Please sign in to rate this answer.
Vasil Michev 94,911 Reputation points MVP

2020-08-26T10:24:19.56+00:00

OK, first of all Office 365 doesnt really care about capital letters, so you can just ignore this. If you still need to do it, here's an example that will change all user's last name attribute to all uppercase letters:

Get-MsolUser | % { Set-MsolUser -ObjectId $_.ObjectId -LastName $($_.LastName.ToUpper()) }

As with all scripts you copy from the internet, TEST if first. Also make sure to export the current values, as a backup of sorts in case the script messes things up.

Here's how to run it against a single user:

Get-MsolUser -UserPrincipalName user@domain.com | % { Set-MsolUser -ObjectId $_.ObjectId -LastName $($_.LastName.ToUpper()) }

And here's how to use a CSV file as input, where you have a column UPN designating the user:

Import-CSV blabla.csv | % { Get-MsolUser -UserPrincipalName $_.UPN | % { Set-MsolUser -ObjectId $_.ObjectId -LastName $($_.LastName.ToUpper()) } }

曾銘康 TSANG MING HONG 21 Reputation points

2020-08-26T10:31:04.733+00:00

Excuse me. I mean I need to change the surname to another stings. say:
acc 1. Chan > AAA
acc 2. Lee > BBB
acc 3. Wong > CCC

Vasil Michev 94,911 Reputation points MVP

2020-08-26T11:14:42.967+00:00

For that, you will need to prepare a CSV file with the "UPN" and "new" name. For example,

UPN NewName
Chan@keyman .com AAA
Lee@keyman .com BBB

Then, use this:

Import-CSV blabla.csv | % { Set-MsolUser -UserPrincipalName $_.UPN -LastName $($_.NewName.ToUpper()) }
Sign in to comment