Add several users in AD using Excel

UPDATE – I’ve changed the link below to point to GE.TT a legit file sharing site.

MassUserCreationScriptSource.xls

Link to the script

Taken from Train Signal AD 2008 training.

File needs to be saved as a Formatted Text (Space delimited) file once done.

Here’s the easy way to add a bunch of users all at once!
1. Copy and paste the first and last names of your users into the AddUsersInfoHere sheet
2. Type the ChildOU name and Autofill it down.
3. Type the ParentOU name and Autofill it down.
4. Go to MassUserCreationScriptSource and check to see if the domain name and suffix are correct. If not, fill in
correct value on the first line and Autofill down.
5. On the SaveThisSheetAsTextFile sheet, make sure to autofill for all required user names.
6. Go to File–> Save As and save the sheet in a convenient place, making sure to select Formatted Text (Space Delimited)
as the file type.
7. Take your .prn file, rename it to something.bat.
8. Post to your server and run it at the command line!

2 thoughts on “Add several users in AD using Excel

  1. EDITED by Admin to point to new link.

    How do you edit a Mass User Creation Script Source (XML) suffix from .com to co.uk?

    I have an Excel sheet for adding users to AD in bulk (attached and link below).

    MassUserCreationScriptSource.xls

    Its designed for “dc=com” suffix.

    i want to change it to “dc=co, dc=uk”.

    Its not straight forward though…

    Can someone help me or better yet, change it and email me?

    Thanks!

Comments are closed.