This guide explains bulk user creation in Active Directory via CSV import. Mandatory CSV headers include givenName, sn, samAccountName, and mail. Users import the CSV through the Create Bulk Users wizard under the Management tab, edit user details following the header template, save as .CSV, and upload for preview. Errors indicate format or missing data issues, which must be corrected before final user creation and status checking.
Bulk User Creation in Active Directory by CSV Import
- Following Details are mandatory: (GivenName, SN, SamAccountName, Mail)
| Name in AD | LDAP Name (header in CSV file) |
| First Name | GivenName |
| Last Name | SN |
| Logon Name (Pre Windows 2000) | SamAccountName |
- Click Management tab.
- Click the Create Bulk Users link under User Creation to invoke the Create Bulk Users wizard.
- Click Import button and then Browse and choose File button to import the CSV file containing user details located at: My Documents\TemplateSSP and Downloads\TemplateSSP
- Right Click and Edit on the file, and then insert the users’ details as required.
- Keep the first line as header, and modify only the second row onwards, by following the header template with comma between the values.
Ex: givenName,sn,samAccountName,Mail
John,Doe,JDoe,John.doe@contoso.com
Once file is completed with the details (Clipboard Copy/Paste) click "File" in Notepad and click "Save As." In the "File name" box, type the name of your file followed by ".CSV."
- Close the file.
- Select it from the Window Explorer window and press the Open option.
- After adding the file, a preview of the users will be created.
*If errors are displayed is related to the format or the missing information from the template*
Once adjustments are made you can reselect the file for validation
- Check Creation and user Status
Comments (0 comments)