Skip to Content
Communication Square LLC Help Center

Edit MSOL user details using CSV and Powershell

Written October 2020. Microsoft changes these admin screens often, so the screenshots below may not match what you see today. The sequence of steps is usually still correct — if something looks wrong, tell us and we'll update it.

Description:

This script is used to edit the multiple user parameters at once using CSV file and Powershell

For Example:

A office365 tenant has 1000's of user and you need to update their usage location their title.

You need to create a CSV file which contain the following columns  

-UPN of the user of whom you want to edit the details

-Usage Location: New usage Location

-Title: New title  

Script:

Install-Module -Name Msonline

Connect-MsolService

Import-Csv -Path "C:\Users\Awais\Desktop\Details.csv" | foreach {

$users = get-msoluser | select userprincipalname,objectid | where {-userprincipalname -like $_.UPN }

Set-Msoluser  -UserPrincipalName $_.UPN -UsageLocation "IE" -Title “Driver” -ObjectId (Get-MsolUser -UserPrincipalName $_.UPN).objectid}

OR

If you want to edit all users

Import-Csv "C:\Users\Awais\Desktop\Faculty.csv" | ForEach-Object { Set-MsolUser -userPrincipalName $_.UserPrincipalName -Title $_.Jobprofile}

Last updated on

Related articles