Import Users into Active Directory from CSV

Home > Docs > Import Users into Active Directory from CSV

In this guide, you will learn how to import users into Active Directory from a CSV file using the AD Pro Toolkit.

The AD Pro Toolkit makes it easy to import multiple AD user accounts and configure all account properties at the same time.

Step 1. Download CSV Template

From the left menu click on “Create Bulk Users”.

• This CSV includes an example of two user accounts.
• 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 (see the section Add Additional Attributes for details)

Step 2. Modify the CSV Template with User details

Open the CSV template and enter the account details. The below columns are required; all other fields are optional. You can delete the columns you don’t need.

1. SamAccountName = This will be the users logon name.
2. password = users password. Make sure it meets your password requirements.
3. givenName = First name
4. sn = Last name

CSV Example

Tips

1. Remove unused columns: You can remove any column from the CSV you don’t need. This can make working with the CSV template much easier. Just make sure you have the 4 required columns listed above; all other columns can be removed.
2. CSV Cheat Sheet: Use the CSV Cheat Sheet from the resources section if you do not understand the column names in the csv template.
3. Run a small test import: Run a small test import first (1-2 accounts) to ensure the CSV is correct and the accounts import as needed.

Step 3. Run the Bulk Create Users Tool

At this point you should have a csv file filled out with your user details. Now you are ready to start the import process.

1. Click on “Bulk Create Users”.
2. Click “Browse” and select your csv file.
3. Enable or disable any of the following options.
   
   
   
   
   • Enable: This will enable or disable the account when it is created (enabled by default)
   • User must change password at next logon: This option will require users to change their password at first logon.
   • FirstName LastName: Sets the name format to FirstName + LastName
   • LastName, FirstName: Sets the name format to LastName, + FirstName
   • Same as user logon name: Sets the name format to logon name (samaccountname)
     
     
4. Click “run” to start the import.
   
   

Add Additional User 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.