Import the users provided in the excel file in their appropriate OU.

PowerShell Help
1

Just need a script that add users in appropriate ou .
#Import the PowerShell module containing AD cmdlets
Import-Module ActiveDirectory

write-host “Start Process”
write-host “-------------------------------------”

try
{
#Read the CSV file
$csvPath = “C:\AccountsImportFile.csv”
$csvData = import-csv $csvPath

write-host "Reading the CSV file......"
#Loop through all items in the CSV items

ForEach ($user In $csvData)
{
	$saMAccountName = $user.sAMAccountName

	#Check if the User exists
	$ADuser = Get-ADUser -LDAPFilter "(sAMAccountName=$saMAccountName)"

	If ($ADuser -eq $Null)
	{
		#Create user using New-ADUser cmdlet
		$userPrincipalName =  $user.sAMAccountName + "@intwkx.allaboutfood.com.mt"
         
		New-ADUser -Name $user.displayName`
		-SamAccountName $sAMAccountName `
		-UserPrincipalName $userPrincipalName `
		-GivenName $user.givenname `
		-Surname $user.sn `
		-DisplayName $user.displayName `
        -AccountPassword (ConvertTo-SecureString "Pa`$`$w0rd" -AsPlainText -Force) `
        -PasswordNeverExpires $true `
		-ChangePasswordAtLogon $false `
		-Enabled $true

		write-host "- " $user.sAMAccountName "| Account Created" -ForegroundColor green

	}
	else
	{
		write-host "- " $user.sAMAccountName "|Account Exists" -ForegroundColor yellow
	}
}

}

catch
{
write-host "Error: " $($.CategoryInfo) -ForegroundColor red
write-host "Message: " $($.Exception.Message) -ForegroundColor red

}

write-host “-----------------------------------------------------------------”
write-host “End Process”

2

New-ADUser has a -Path attribute to specify the OU path. You may want to also take a look at splatting.