Import Users CSV Template Attributes
List of attributes and example values for the bulk import users template. The CSV template uses the LDAP names, refer to the CSV Cheat Sheet to see a mapping of LDAP names to Active Directory fields.
Resources
- User Import CSV Template - CSV template with user examples and multiple user attributes.
- CSV Cheat Sheet - A quick reference PDF that shows the CSV headers and what they map to in Active Directory.
sAMAccountName
This will be the users logon name.
Example: test.user1
password
The users password. You can require password change at first logon from the import tool.
- The password must meet your domain password policy settings.
ou
The organizational unit the account will be created in.
- The value in the csv file needs to be the distinguishedName of the OU.
Example: OU=ADPRO Users2,DC=ad,DC=activedirectorypro,DC=com
memberof
Add users to one or more groups.
- Use the groups name and seperate multiple groups with a comma.
Example: it_wrk_admins,it_srv_admins
userPrincipalName
Sets the user’s userPrincipalName.
Example: test.user1@activedirectorypro.com
givenName
This will be the users First name.
Example: Amy
initials
This will be the users Initials.
sn
This will be the users Last name.
Example: Paige
displayname
The users display name.
Example: Amy Paige
description
Sets the description field on the user account.
Example: Temp accounting for testing
physicalDeliveryOfficeName
This sets the Office field.
Example: Management 1st floor
telephoneNumber
Sets the Telephone number on the general tab in Active Directory.
Sets the users E-mail field on the general tab.
Example: test-user@activedirectorypro.com
wwwHomepage
Sets the Web page on the gernal tab.
Example: activedirectorypro.com
streetAddress
Sets the street on the address tab.
Example: 123 w stree ln
postOfficeBox
Sets the P.O Box on the address tab.
Example: PO Box 1234
l
This is the City field on the address tab.
Example: Springfield
st
This is the state/province field on the address tab.
Example: MO
postalCode
Zip/Postal Code on the address tab.
Example: 65802
c
To letter country code.
- Refer to the ISO 3166 country codes list to find your country code.
Example: US
profilePath
Profile path on the profile tab.
Example: \file1\profiles\%username%
scriptPath
Sets the logon script on the profile page.
Example: logon.bat
homeDrive
This is the connect to on the profile tab.
Example: z:
homeDirectory
This is the connect to field on the profile tab
Example: \file2\users\IT\%username%
homePhone
This is the home field on the telephones tab.
mobile
This is the Mobile field on the telephones tab.
ipPhone
This is the IP phone field on the telephones tab.
title
This is the Job Title field on the Organization tab.
Exampe: Network Manager
department
This is the Department field on the Organization tab
Example: Information Technology
company
This is the Company field on the Organization Tab.
Example: Active Directory Pro
employeeid
This is the employeeid attribute.
Example: 12345
employeenumber
This is the employeenumber attribute.
Example: 1
manager
This is the manager name on the organization tab.
- The value needs to be the sAMAccountName of the manager
Example: robert.allen
proxyAddresses
Sets the proxyAddresses attribute.
- To add multiple proxyaddresses seperate with a comma
- You can set a primary smtp address with a capical SMTP.
Example SMTP: test.user1@activedirectorypro.com,smtp: test.user1@otherdomain.com