To export information from Active Directory, such as email addresses, user names, etc.:
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
Run Active Directory Users and Computers.
Select View -> Add/Remove Columns, and add the columns you want to display and export (email address, last name, etc.).
Right click on this same container/OU, select Export List and provide a path/filename.
- Open up the exported text file with Microsoft Excel or another spreadsheet application.
You now have the information you need in spreadsheet format.
Creating Active Directory objects with LDIFDE and CSVDE tools