How To Export Active Directory User to CSV File

November 23, 2008 | By voidzzz | Filed in: How-To, Windows, Windows 2003, Windows 2008.

sometimes it’s a pain in the *ss when you have to list all your user manually in Windows Server Active Directory.
I’ll show you how to easily export active directory users and computers to csv file so that you can open and edit the list easily with microsoft excel (or other programs).

launch command prompt at your active directory server and issue the following command :

csvde -f domain.csv -r (objectclass=user) -l "sn,givenname,department,mail"

change the value within -l “…..” to fit your needs. the command will take attributes from Active Directory data that fit your request within -l “….”

Tags: , ,

Leave a Reply

Your email address will not be published. Required fields are marked *