Import Excel Files into Active Directory

j_man202
j_man202 used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial