AD User Import & Export

Export User Profiles

Import-Module ActiveDirectory
Get-ADUser -Filter {enabled -eq $true} -Properties Name, SamAccountName, UserPrincipalName, EmailAddress, Company `
    , DisplayName, Fax, HomeDirectory, HomeDrive, HomePage, HomePhone, Initials, Office, OfficePhone, Department, Description `
    , ScriptPath, City, State, StreetAddress, Title, Manager `
    | ? {$_.DistinguishedName -like "*,OU=XXXX,*"} | Export-csv -path D:\deploy\UserProfiles.csv -NoTypeInformation

Import User Profiles

Import-Module ActiveDirectory

Import-Csv "D:\Deploy\UserProfiles.csv" | ForEach-Object {

New-ADUser -Verbose `

 -Name $_."Name" `

 -Path "OU=XXX,DC=xxx,DC=com" `

 -SamAccountName $_."samAccountName" `

 -UserPrincipalName $_."UserPrincipalName" `

 -AccountPassword (ConvertTo-SecureString "password1" -AsPlainText -Force) `

 -ChangePasswordAtLogon $false `

 -Enabled $true `

 -EmailAddress $_."EmailAddress" `

 -CannotChangePassword $false `

 -Company $_."Company" `

 -Department $_."Department" `

 -Description $_."Description" `

 -DisplayName $_."DisplayName" `

 -Fax $_."Fax" `

 -GivenName $_."GivenName" `

 -HomeDirectory $_."HomeDirectory" `

 -HomeDrive $_."HomeDrive" `

 -HomePage $_."HomePage" `

 -HomePhone $_."HomePhone" `

 -Initials $_."Initials" `

 -Office $_."Office" `

 -OfficePhone $_."OfficePhone" `

 -PasswordNeverExpires $true `

 -ScriptPath $_."ScriptPath" `

 -City $_."City" `

 -State $_."State" `

 -StreetAddress $_."StreetAddress" `

 -Surname $_."Surname" `

 -Title $_."Title" `

 }