Create Bulk users in AD from CSV through Powershell Script

 CSV format

# Import active directory module for running AD cmdlets

Import-Module activedirectory

  

#Store the data from ADUsers.csv in the $ADUsers variable

$ADUsers = Import-csv C:\Users\Administrator\Desktop\nvedu.csv

#Loop through each row containing user details in the CSV file 

foreach ($User in $ADUsers)

{

#Read user data from each field in each row and assign the data to a variable as below

$Username = $User.samaccountname

$Password = $User.password

$Firstname = $User.GivenName

$Lastname = $User.SurName

$OU = $User.ou #This field refers to the OU the user account is to be created in

    $email      = $User.emailaddress

    $streetaddress = $User.streetaddress

    $city       = $User.city

    $zipcode    = $User.zipcode

    $state      = $User.state

    $country    = $User.country

    $telephone  = $User.telephone

    $jobtitle   = $User.jobtitle

    $company    = $User.company

    $department = $User.department

    $Password = $User.Password

#Check to see if the user already exists in AD

if (Get-ADUser -F {SamAccountName -eq $Username})

{

#If user does exist, give a warning

Write-Warning "A user account with username $Username already exist in Active Directory."

}

else

{

#User does not exist then proceed to create the new user account

        #Account will be created in the OU provided by the $OU variable read from the CSV file

New-ADUser `

            -SamAccountName $Username `

                       -Name "$Firstname $Lastname" `

            -GivenName $Firstname `

            -Surname $Lastname `

            -Enabled $True `

            -DisplayName "$Lastname, $Firstname" `               -Company $company `

            -State $state `

            -StreetAddress $streetaddress `

            -OfficePhone $telephone `

            -EmailAddress $email `

            -Title $jobtitle `

            -Department $department `

            -AccountPassword (convertto-securestring $Password -AsPlainText -Force) -ChangePasswordAtLogon $True

            

}

}