Bulk user operations from CSV in PowerShell

Introduction

Bulk user operations from CSV help you manage many users at once without typing each one. It saves time and reduces mistakes.

You need to add many users to a system quickly.

You want to update details for a list of users all at once.

You have a CSV file with user info and want to automate creating or modifying accounts.

You want to delete multiple users listed in a CSV file.

You want to export user info from a CSV and process it in a script.

Syntax

PowerShell

Import-Csv -Path "file.csv" | ForEach-Object {
    # Your user operation here, e.g. New-ADUser, Set-ADUser
}

Import-Csv reads the CSV file and converts each row into an object you can use.

ForEach-Object lets you run commands on each user from the CSV one by one.

Examples

This reads users.csv and prints each user's name.

PowerShell

Import-Csv -Path "users.csv" | ForEach-Object {
    Write-Output "Creating user: $($_.Name)"
}

Creates Active Directory users using info from the CSV columns.

PowerShell

Import-Csv -Path "users.csv" | ForEach-Object {
    New-ADUser -Name $_.Name -GivenName $_.FirstName -Surname $_.LastName
}

Deletes users listed in the CSV by their username.

PowerShell

Import-Csv -Path "users.csv" | ForEach-Object {
    Remove-ADUser -Identity $_.UserName
}

Sample Program

This script reads a CSV file named users.csv with columns UserName and Email. It prints each user's name and email.

PowerShell

Import-Csv -Path "users.csv" | ForEach-Object {
    Write-Output "User: $($_.UserName), Email: $($_.Email)"
}

Important Notes

Make sure your CSV file has headers matching the property names you use in the script.

Test your script with a small CSV first to avoid mistakes on many users.

Use quotes around file paths if they contain spaces.

Summary

Bulk user operations from CSV automate handling many users at once.

Use Import-Csv to read user data and ForEach-Object to process each user.

Always check your CSV headers and test scripts carefully.