Import Bulk users into AD from Excel

[jeandrevanzyl]

Description

Advertisement

Close

My first real powershell script . I know their is an easier why of doing this without scripts but wanted to just play around with powershell .

Source Code

$users = Import-Csv -Delimiter "," -Path "C:\[!TestScripts]\[!Untested]\NewUsers-List.csv"
foreach ($users in $users)
{
    $Displayname = $users.Firstname + " " + $users.Lastname
    $UserFirstname = $users.Firstname
    $UserLastname = $users.Lastname
    $OU = "$User.OU"
    $SAM = $User.SAM
    $UPN = $User.Firstname + "." + $User.Lastname +"@" + $users.maildomain
    $Description = $User.Description
    $Password = $User.Password
    New-ADUser -Name "Displayname" -DisplayName "$Displayname" -SamAccountName $Sam
}