Import users from an Excel spreadsheet Even if you don’t create new users in bulk often, when you have more than one new user to deal with, importing from a comma-delimited file is faster than using the GUI server administration tools or manually typing PowerShell commands. Just fill out the fields in the spreadsheet, run the script and the job is done. Use an Excel spreadsheet to import new Active Directory users (Image: Russell Smith) In the script below, I’ve used a simple foreach loop and the import-csv cmdlet to import and generate the new user accounts. The only additional code I’ve added is a split to separate users’ first and second names in the .csv file’s Name field, to populate the –givenName and –surname parameters, for the sake of completeness and to keep the number of columns in the .csv file to a minimum. PowerShell 1 2 3 4 5 6 7 import-csv -path c : \ temp \ users . csv | foreach { $givenName ...