Import Bulk Users to Active Directory


This step is important when decide to build a brand new Green Field Windows 2008 Active Directory service and want to start utilizing the new Windows 2008 R2 Active Directory by importing all organization users’ names and passwords into the Active Directory:

1) Build CSV file that include Organization Users with specific attributes to be imported in the new Windows 2008 R2 Active Directory,

Sample of CSV can be as the following:

Recommendation

For simplicity’s sake we’ll keep it to a few basic properties like Name and Description, of course Organization IT team can and normally would have significantly more. To make it easier IT team can add a few extra columns like the SamAccountName and the Path (OU) where Organization would like the account to be created, and for account password IT team can configure random or fixed password for all users and force it for all users and distribute the new passwords for each user individually while configure all users to be forced to change password after first login.

clip_image002

2) Use cmdlet Import-CSV which read from a standard CSV file and create a set of objects based on data inside the CSV file, then send the results of this cmdlet using PowerShell pipeline to New-ADUser cmdlet from ActiveDirectory module to create the specified users in the Active Directory, as a sample cmdlet: “Import-CSV C:\Users.csv | New-ADUser” this command to be run from Active Directory PowerShell Module.

3) Verify that the users in CSV are imported in the Active Directory.

4) Manually join all workstations to the new Windows 2008 R2 Active Directory and give the required permissions for each user on his workstation

5) Verify that each user can login to his workstation with his new Active Directory user account.

Comments (21)

  1. Maged Ezzat says:

    HiJR

    Password can be new column in same CSV file.

  2. Anonymous says:

    looking for better tool in low cost.try here.really worthiest tool.

    http://www.adsysnet.com/downloads.aspx

  3. Andy Dunn says:

    Thanks. This is actually interesting and v.useful.

  4. MigrationKing says:

    How about helping to create a real user usage file for anyone on the Internet to access and use in real time?

    Do have have any edits that you think would work better?

    Here is the live file:

    blog.migrationking.com/…/active-directory-bulk-user-import-using.html

  5. JR Velasco says:

    how do you to add the password when importing users?

  6. Raghunath.N says:

    Download and use this file.. might be useful..

    hotfile.com/…/Creare_Bulk_Users_in_AD.zip.html

  7. Vaish says:

    Very helpful.. Thanks for the post.

  8. Shabbir says:

    Very easy GUI Based  and helpful….

    gallery.technet.microsoft.com/…/Discussions

  9. Larry says:

    Hi thanks for this nice article and post. Please update like in case this is the exporting of the user but in some cases like i want to the user should be exported with the photo at that case what should be done. Shall we have to use a third party applications for the same. I have google out and founded a tool name

    http://www.lepide.com/ad-bulk-image-editor.html

    A freeware applications, and once again thanks.

  10. Cody says:

    That script you have doesn't seem to reference anything at all in your example picture. lol…

    “Import-CSV C:Users.csv | New-ADUser”

    What about referencing the attributes in your example?  Name, SamAccountName, First Name, Last Name, etc?  

    This blog does nothing more than make you wonder how to get it to work and look elsewhere.

  11. Mahendren says:

    I can refer this active directory tool for importing active directory objects with advanced options ,

    refer here : <a href="http://www.adsysnet.com/asn-active-directory-manager-bulk-objects-creation.aspx">Object Creation using CSV</a>

    For free evaluation for 7 days,

    http://www.adsysnet.com/asn-active-directory-manager-licensing.aspx

  12. ramu says:

    For the value path, I tried entering a path but I get "A value for the attribute was not in the acceptable range of values, Microsoft.ActiveDirectory.Management.Commands.NewADUser" The value is : "OU=2022,OU=Students,OU=Users,OU=ABCD,DC=ABCD,DC=XX,DC=YYY,DC=UU"
    Is there a limit on the number of charaters?

  13. wilson says:

    I am completely stuck.Iam using active directory 2012 and all the tools on the internet arent helping me add bulk users to the directory.Anyone who has an idea of a free tool that can work on server 2012 and steps to doing it.

  14. Adi says:

    not a working script. No field for values like display name and UPN name. I think its a waste of time

  15. David says:

    I tried this and it created the first user account successfully, but all others fail with the following error "New-ADUser : The specified account already exists". But when I search AD there isn’t an account for the users with error messages. If I switch
    the order of the spreadsheet I get the same result where the first account is created but the others fail. Any help appreciated.

  16. Helvio Junior says:

    Hi, you can use an identity manager software to do this. If you want try we software i can provede you a free licence.
    http://single-sign-on.com.br

  17. malcolm says:

    Why on earth can’t MS simply provide a GUI driven import function to do this, rather than us having to write scripts? I know that you’re not truly considered a proper geek unless you enter everything at the command line, but come on! Why does it fall to
    independent developers to create the really useful tools for Windows Server?

  18. Yazan says:

    Thanks! I tried this and it worked.

  19. Problem says:

    Hi, i have problem on screenshot.

    http://screenshot.cz/HIU1Y/problem_import.png

  20. Anonymous says:

    Had a lower level technician try to import a large list of incoming freshman into a high school’s Active Directory via Powershell and mistakes were made. Basically there was no UserPrincipalName created which made logon to workstations difficult. Here

Skip to main content