Been trying to build a CSV file to import users into Active Directory. I can get everything to populate, except for E-mail, Password, and Enabling the user. Just using this cmdlet in Powershell.

Import-CSV "C:\Users\Administrator\Downloads\adimport.csv" | new-ADUser

This is what my CSV looks like.

CSV File

For some reason the E-Mail field in the General tab won't fill. I'm also not sure what column header to use to enable the profile, and I think password is userPassword, right?

Is there something i'm doing wrong that the E-Mail field won't fill in?

2 Answers 2


Try rename field in csv from mail to EmailAddress

New-ADUser accepts a property of EmailAddress, but not mail. Some of these correspond to an AD attribute, but not all.


  • That was it, didn't see that anywhere in the Attribute Editor and everything I had read said to use mail Apr 22, 2015 at 17:55
  • You can try: get-AdUser -filter 'samAccountName -like "Administrator"' -properties *|Get-Member to view all properties of the object Apr 22, 2015 at 18:20
  • Ahh, thank you so much. Most of the stuff I was reading was from Server 2008, so maybe they changed that property name. Apr 22, 2015 at 18:25

Here is list of all Get-aduser default and extended properties.


You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .