Import Excel Files into Active Directory

I have Windows 2003 Server, I have and Excel file with all my Contacts information in it, I wanted to know if there was a way for me to Import this excel file into my AD?
j_man202Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Shift-3Connect With a Mentor Commented:
Yes.  Save it as a comma-delimited text file (.csv) and then import it using CSVDE.  This KB article has instructions:
http://support.microsoft.com/kb/327620

It would probably be best to do a CSVDE export of existing accounts and then copy the spreadsheet data into the appropriate fields.  This should ensure that the formatting is correct.

This site has some more examples:
http://www.computerperformance.co.uk/Logon/Logon_CSVDE_import.htm
0
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.