Active Directory Pro
Book a demo Free Trial

Import Users into Active Directory from CSV

This guide shows you how to bulk import Active Directory users with the AD Pro Toolkit.

How to bulk import AD users

  1. Click Tools > Users > Create Bulk Users (Import).

  2. Click Download Template.

  3. Modify the CSV template with details about the users you want to create. These columns are required:

    • Logon Name (sAMAccountName)
    • First Name
    • Last Name
    • OU
    • Password

    Save your template when you are done. Every other column in the table below is optional.

    Leave Password blank and the app generates a random password for that user. You are prompted to save those passwords at the end of the import.

  4. Browse and select your CSV file.

  5. Select account options. Change them or leave the default settings.

  6. Click Preview (optional). This checks your CSV for problems and shows what will be created and set for each user.

  7. Click Import Users to start the import.

    If you chose to auto-generate passwords, you are prompted to save a CSV containing each user's logon name and password. Review the logs for any errors.

Supported attributes

Supported headers and aliases for the CSV file. If you need additional attributes, please contact support.

CSV Header LDAP Attribute Aliases Required
Logon Name (sAMAccountName) sAMAccountName User Logon Name, Username, User Name, Logon Name Yes
First Name givenName FirstName Yes
Last Name sn LastName Yes
OU n/a Yes
Password unicodePwd No
Display Name displayName No
User Principal Name userPrincipalName UPN No
Initials initials No
Member Of memberOf Groups, Group Membership No
Department department No
City l No
State st No
Job Title title JobTitle No
Office physicalDeliveryOfficeName No
Country/Region co Country, Region No
Manager manager No
Company company No
Description description No
Telephone Number telephoneNumber Telephone, Phone, PhoneNumber, Phone Number No
E-mail mail Email, EmailAddress, Email Address No
Street streetAddress No
P.O. Box postOfficeBox POBox, PO Box No
Zip / Postal Code postalCode Zip, ZipCode, Zip Code, Postal Code No
Profile Path profilePath No
Logon Script scriptPath No
Home Folder (Connect) homeDrive No
Home Folder (Path) homeDirectory No
Home Phone homePhone No
Mobile mobile MobilePhone, Mobile Phone, Cell, Cell Phone, CellPhone No
Fax facsimileTelephoneNumber No
IP Phone ipPhone IPPhone No
Proxy Addresses (email aliases) proxyAddresses ProxyAddresses, Proxy Addresses No
Employee ID employeeID No
Employee Number employeeNumber Employee # No
Hidden from Address List msExchHideFromAddressLists HiddenFromAddressList, Hidden No