PowerShell Script To Remove Office 365 Users From CSV Input

In this blog, we will learn how we can write a PowerShell script which will read the principal user name from the csv file and remove those users from the Office 365 Account.

Overview

In this blog, we will learn how to write a PowerShell script which will read principal user name from the CSV file and remove those users from Office 365 account.

Step 1

Connect Windows Azure Active Directory Module for Windows PowerShell.

Use the following code snippet to connect with Office 365 tenant.

$UserCredential = Get-Credential
Connect-AzureAD -Credential $UserCredential

Step 2

Execute the following script.

Below is a screenshot for my CSV file.

$sInputFile = "D:\deleteuser.csv"
$sColumnName = "UserPrincipalName"
$tblDatos = Import - CSV $sInputFile
foreach($fila in $tblDatos)
{
    "Deleting user " + $fila.$sColumnName.ToString()
    Write - Host - ForegroundColor Yellow "User staring to deleter"
    $fila.$sColumnName
    Remove - MsolUser - UserPrincipalName $fila.$sColumnName
    Write - Host - ForegroundColor Yellow $fila.$sColumnName "Deleted........"
    $fila.
    $sColumnName
}

It will ask for confirmation for deleting every user.

Press "Yes".

Conclusion

This is how we can use PowerShell script to delete multiple users from Office 365.