how to import the User details in Ative Driectory from Excel

Dear Experts
we are using AD 2003, in AD only user account has been created. they are 150 users, now i want to update users details in AD at one single step with Excel Sheet.
1.  i have exported all  user account in the excel sheet.
2. then i have updated all the users accounts details in excel. now i want to import the excel sheet to AD 2003, so that all the users should be updated in signal step

Who is Participating?
gaurav05Connect With a Mentor Commented:

Instructions to Create a Simple CSVDE Import Spreadsheet
1) Copy my example below and paste into an Excel spreadsheet at precisely cell A1.

user,Petergr," CN=Peter Graham,OU=Newport,DC=cp,dc=com"
user,Janiebo," CN=Janie Bourne,OU=Newport,DC=cp,dc=com"
user,Edgardu," CN=Edgar Dunn,OU=Newport,DC=cp,dc=com"
user,Belindaha," CN=Belinda Hart,OU=Newport,DC=cp,dc=com"
user,Mayja," CN=May Jamieson,OU=Newport,DC=cp,dc=com"
user,Leroyot," CN=Leroy Ota,OU=Newport,DC=cp,dc=com"

2) In Excel, select the Data Menu and then Text to Columns.  Naturally, choose the comma delimiter. Save the file as .csv for example, Newort.csv

3) Make sure that the 3 LDAP fields are in the first row.  (ObjectClass, sAMAccountName, and DN.)

4) Once you have opened the file in Excel, it is easier to manipulate the values.  For example, you may wish to find and replace dc=cp, dc=com with the name of your domain as we discussed earlier.

 5) When you have finished preparing the spreadsheet to your liking, then Save As and make sure you select Save as type CSV (Comma delimiter).  Since the next step is the command prompt, save the file into an easily accessible folder. E.g. C:\csv.

The Actual CSVDE -i Import Command
After all the hard work in preparing the spreadsheet, we are now ready for the import.  Open the CMD prompt, navigate to the folder where you saved your .csv file.

Type this command:  CSVDE -i -f Newport.csv

let us know is there any issue.
SandeshdubeySenior Server EngineerCommented:
Windows server provide you with 2 utility tools to modify existing AD accounts - CSVDE or LDIFDE

What you do is to export your AD user accounts into a csv/spreadsheet, modify it and import it back to AD. Easy.



ldifde -f Exportuser.ldf -s <Server1> -d "dc=Export,dc=com" -p subtree
-r "(&(objectCategory=person)(objectClass=User)(givenname=*))"
-l "cn,givenName,objectclass,samAccountName"

also check this.

Refer to the article:

Hope it works.

Thank you
mshakebAuthor Commented:
problem sloved
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.