Here is my BulkAddADUsers.csv file sample :
Name,SamAccountNAme,Description,Department,EmployeeID,Path,Enabled,Password,PasswordNeverExpires First1 Last1,First1.Last1,Consultant,IT,990,"OU=IT,DC=DomainA,DC=contoso,DC=ca",$True,P@ssw0rd1,$True First1 Last2,First1.Last2,Manager,IT,405,"OU=IT,DC=DomainA,DC=contoso,DC=ca",$True,P@ssw0rd1,$True First1 Last3,First1.Last3,Sales,Sales,265,"OU=Sales,DC=DomainA,DC=contoso,DC=ca",$True,P@ssw0rd1,$True First1 Last4,First1.Last4,Windows Administrator,IT,365,"OU=IT,DC=DomainA,DC=contoso,DC=ca",$True,P@ssw0rd1,$True First1 Last5,First1.Last5,Marketing,Marketing,$True63,"OU=Marketing,DC=DomainA,DC=contoso,DC=ca",$True,P@ssw0rd1,$True First1 Last6,First1.Last6,Marketing,Marketing,964,"OU=Marketing,DC=DomainA,DC=contoso,DC=ca",$True,P@ssw0rd1,$True First1 Last7,First1.Last7,Sales Manager,Sales,889,"OU=Sales,DC=DomainA,DC=contoso,DC=ca",$True,P@ssw0rd1,$True First1 Last8,First1.Last8,Marketing Manager,Marketing,375,"OU=Marketing,DC=DomainA,DC=contoso,DC=ca",$True,P@ssw0rd1,$True First1 Last9,First1.Last9,Exchange Administrator,IT,435,"OU=IT,DC=DomainA,DC=contoso,DC=ca",$True,P@ssw0rd1,$True First1 Last10,First1.Last10,Technical Lead,IT,378,"OU=IT,DC=DomainA,DC=contoso,DC=ca",$True,P@ssw0rd1,$True First1 Last11,First1.Last11,Team Member 1,IT,731,"OU=IT,DC=DomainA,DC=contoso,DC=ca",$True,P@ssw0rd1,$True First1 Last12,First1.Last12,Team Member 2,IT,370,"OU=IT,DC=DomainA,DC=contoso,DC=ca",$True,P@ssw0rd1,$True First1 Last13,First1.Last13,Team Member 3,IT,$True34,"OU=IT,DC=DomainA,DC=contoso,DC=ca",$True,P@ssw0rd1,$True First1 Last14,First1.Last14,Team Member 4,IT,263,"OU=IT,DC=DomainA,DC=contoso,DC=ca",$True,P@ssw0rd1,$True First1 Last15,First1.Last15,Team Member 5,IT,978,"OU=IT,DC=DomainA,DC=contoso,DC=ca",$True,P@ssw0rd1,$True First1 Last16,First1.Last16,Team Member 6,IT,872,"OU=IT,DC=DomainA,DC=contoso,DC=ca",$True,P@ssw0rd1,$True First1 Last17,First1.Last17,Team Member 7,IT,603,"OU=IT,DC=DomainA,DC=contoso,DC=ca",$True,P@ssw0rd1,$True First1 Last18,First1.Last18,Team Member 8,IT,813,"OU=IT,DC=DomainA,DC=contoso,DC=ca",$True,P@ssw0rd1,$True
[PS] C:\users\Administrator.DOMAINA\Desktop>import-CSV .\BulkAddADUsers.csv|New-ADUser
Note the AD accounts are not enabled, because the password was not taken from the CSV file, as New-ADUser requires a Secure String for the Password. Here is what you get when you try to enable it :
==>
[PS] C:\users\Administrator.DOMAINA\Desktop>import-csv .\BulkAddADUsers.csv | % {New-ADUser -Name $_.Name -SamAccountName $_.SamAccountName -Description $_.Description -Department $_.Department -EmployeeID $_.EmployeeID -Path $_.Path -Enabled $True -AccountPassword (ConvertTo-SecureString $_.Password -AsPlainText -force) -PasswordNeverExpires $True}
Quod erat demonstrandum.
Sam