Active Directory Tools > Create Users

AD User Creation Tool

With the AD Bulk User Creation Tool, you can easily import Active Directory users from csv. This is a huge time saver compared to manually creating each user account. By using our built-in template, you can assure accounts are created accurately and consistently. The built-in schedular allows you to automate user creation and import new user accounts on a schedule.

Features:

  • Easily bulk import and update user accounts
  • Automative user provisioning
  • Includes CSV template
  • Add or remove users to groups
  • Supports a large number of attributes.

Download Free Trial of this tool and try it out for yourself.

Requirements:

  • You need permission to create user accounts in Active Directory.
  • The following headers are required in the CSV template. All other headers are optional.
    • SamAccountName = This will be the users logon name.
    • password = users password. Make sure it meets your password requirements.
    • givenName = First name
    • sn = Last name

Read First:

  • Run a small test first – It is recommended to first run a small import to ensure the accounts are being created as expected.
  • User attributes – The CSV template includes 33 user attributes. This covers the most common attributes for creating new accounts. Additional attributes can be added to the template.
  • Name column – You DO NOT need to add the name attribute to the CSV. This gets automatically created based on the first and last name.
  • CSV Template – Refer to the provided CSV template for an example of how to setup the CSV file.
  • CSV Template CheatSheet – If you are not familiar with Active Directory attributes then refer to the CSV Template Cheatsheet.

How to use the AD Create User Tool

Step 1. Click on Import Users

Step 2. Click on the CSV Template button

You will be prompted to save the CSV file. You can save it anywhere you want.

Step 3. Modify the CSV Template

The provided template includes an example user as a reference on how to fill out the CSV template.

At a minimum, I recommend setting the following fields for all users.

  • SamAccountName (required) = This will be the users logon name.
  • password (required) = users password. Make sure it meets your password requirements.
  • OU = The organizational unit to import users into. This is the distinguished name of the OU. If you leave it blank it will import into the default users container.
  • givenName (required) = First name
  • sn (required) = Last name
  • displayName = Display Name
  • Groups = Groups to add the users to. Separate each group with a comma.

You can download my CSV template here.

When you have your CSV template configured save it and move to the next step.

Step 4. Select Import Options

Select your import options in box 2.

  • Enable users = The imported accounts will be set to enabled
  • Force Password Change = The import accounts will be required to change their password at next logon.
  • Name: LastName, FirstName – By default the name format is FirstName, LastName, if you want to reverse this select this box.

Step 5. Select your CSV file and click run

Next, click the “Select CSV File” button and select your CSV template. Then click run to start the import.

Then click run to start the import.

When the import process is completed, review the logs for any errors. Errors will be in red and will tell you why the error occurred.

As a reference, it took 45 seconds to create 100 accounts on a virtual machine with 2 GB memory.

You should now see the accounts in Active directory, they should be configured with the settings you specified from the CSV.

Verify the Import (Optional)

A quick way to verify the accounts imported correctly is to use the export users tool.

You are not actually going to export anything but you can quickly preview accounts and their settings.

Click on Export Users and click Run (if you want to check users in a specific OU select the OU).

Now you can scroll through the list and verify all of the user fields are set correctly.

Supported Attributes List

Below is a list of attributes included in the template. The CSV headers are case sensitive and can be in any order. You can delete any columns from the template that you do not need.

Attribute Name (column headers)Example ValueDescription
sAMAccountNametest.user1This is the users logon name
passwordFullb@@ller02#The users password.
ouOU=ADPRO Users2,DC=ad,DC=activedirectorypro,DC=comThe OU where you want to import accounts to.
memberofit_wrk_admins,it_srv_adminsAdds users to groups. Separate multiple groups with a comma.
userPrincipalNametest.user1@activedirectorypro.comThe users user principal name.
givenNameRobertThe users first name
initialsRAThe users initials
snAllenThe users last name
displaynameRobert AllenThe users display name
descriptionIT staffThe description field in AD.
physicalDeliveryOfficeName
1st floor
This is the office field in Active Directory (General tab).
telephoneNumber1-888-214-3802This is the Telephone number field (General tab).
mailrobert@activedirectorypro.comThis is the E-mail field (General tab).
wwwHomepageactivedirectorypro.comP.O Box field (Address tab).
streetAddress123 W. EagleCrest LNStreet field (Address tab).
postOfficeBoxPO Box 1P.O Box field (Address tab).
lSpringfieldThis is the City field (Address tab).
stMOState/province field (Address tab).
postalCode65802Zip/Postal Code field (Address tab).
cUS2-digit string value
profilePath\file1\profiles\%username%Profile path field (Profile tab).
scriptPathit.batLogon script field (Profile tab).
homeDirectory\file2\users\IT\%usernameThis is the home folder path (Profile tab)
homePhone1-888-214-3802Home phone (Telephones tab)
mobile1-888-214-3802Mobile number (Telephones tab)
ipPhone1-888-214-3802Ip phone (Telephones tab)
titleNetwork ManagerJob title field (Organization tab)
departmentITDepartment field (Organization tab)
companyActive Directory ProCompany field (Organization tab)
employeeid12345This is the employeeID attribute
employeenumber
1

This is the employeenumber attribute
managerrobert.allenThis will assign a manager to the user account. Use the managers logon name.
proxyAddressesSMTP:test.user1@activedirectorypro.com,
smtp:test.user2@activedirectorypro.com
This column will add additional proxyAddress to the user.

Add Additional Attributes

You can add additional user attributes to the CSV file, you just need to know the LDAP name. You can find the LDAP name by opening the attribute editor in Active Directory Users and Computers. You could also use PowerShell to list all user account properties.

To see the attribute editor you first need to enable the advanced features in Active Directory Users and Computer

Click view from the top menu then select advanced features.

Now when you open an account you will see the attribute editor tab.

The attribute editor screen will show you all the user LDAP properties.

Now just find the attribute name and add it to the CSV. For example, I want to add information to the other Home telephone section for users.

In the attribute editor, I see the name is “otherHomePhone”. I will add this to the CSV.

All done. That is how you add additional attributes to the CSV file to import with new accounts.

Schedule User Creation

You can use the built-in task scheduler to automate importing new user accounts.

  1. Click on Scheduler.
  2. Click on the Add button.
  3. For the type select “Import new users”
  4. Give the task a name.
  5. Set the credentials.
  6. Click Next
  7. Set the schedule frequency. You can choose from Daily, Weekly or Monthly.
  8. Click Next
  9. Select your CSV template. Click the options button to change import options if needed.
  10. Your task will now appear in the list.