Create bulk users in Active Directory using .CSV format and PowerShell

By | November 18, 2013

Create bulk users in Active Directory using .CSV format and PowerShell

Bulk user creation in Active Directory can be completed using .CSV import and the steps are follows.

Create a .CSV formatted sheet with details, an example given below. This sheet is filled with test user account details to create in Active Directory.

Name = Account Name, givenName =First Name, SamAccountName = login account, Description, Department, Path = OU in which we need to create accounts, UserPassword = password


Run PowerShell as Administrator and execute the command

Import-CSV <path to the .csv file> | New-AdUser


The account password need to meet the complexity requirements, otherwise account cannot be enabled until reset with a new password.

Melbin Mathew

I am Melbin Mathew, Systems Engineer from Kerala, India. I live with my parents, daughter and my wonderful wife. I graduated in 2004 with a bachelor’s degree in Electronics and Hardware from Mahatma Gandhi University, Kottayam and completed certification in MCITP, RHCE, CCNA, VCP ...Read More
Category: Windows

About Melbin Mathew

I am Melbin Mathew, Systems Engineer from Kerala, India. I live with my parents, daughter and my wonderful wife. I graduated in 2004 with a bachelor’s degree in Electronics and Hardware from Mahatma Gandhi University, Kottayam and completed certification in MCITP, RHCE, CCNA, VCP ...Read More