How to create a CSV file for bulk New User upload to Windows Active Directory using PowerShell.
You will need the names of the users you want to import in a spreadsheet, preferably with their first name and last names in different columns.However, the more information about the user the better. For this exercise, I will use the following information:

1. Username
   
2. Login Account Info
   
3. Email Address
4. Description
5. Telephone
6. Location
7. Department
   

In each Column add the following syntax:

• objectClass (e.g. User, Contact, Computer, etc.)
• Name (e.g. Bart Simpton)
• givenName (e.g. Bart)
• Surname (e.g. Simpton)
• DisplayName (e.g. Bart Simpson)
• Office (add the office location of the user)
• OfficePhone (e.g. (555) 555 5555)
• SamAccountName (e.g. simpsonb or whatever username format is required)
• Description (e.g. User, Manager, Supervisor, etc.)
• Department (add the department name)
• Email Address (add the email address)
• userPrincipalName (here's where you will enter the user login name e.g. simpsonb or whichever format required)
• Path (here's where you enter the AD path e.g. OU=Pubs,DC=Springfield,DC=com
• Enabled (e.g. $True or $False)

Note: the account will be disabled by default - more ahead.