Manage Learn to apply best practices and optimize your operations.

Quick Tips: Exporting AD account information to a spreadsheet

Learn how to export Active Directory account information like email addresses, last name, etc., into a spreadsheet.

RE Aldridge

To export information from Active Directory, such as email addresses, user names, etc.:

  1. Run Active Directory Users and Computers.

  2. Select View -> Add/Remove Columns, and add the columns you want to display and export (email address, last name, etc.).

  3. Select the Users container or another organizational unit (OU) within your Active Directory hierarchy.

  4. Right click on this same container/OU, select Export List and provide a path/filename.

  5. Open up the exported text file with Microsoft Excel or another spreadsheet application.

You now have the information you need in spreadsheet format.

Using Active Directory tools to import/export data

Using LDIFDE to extract Active Directory data

 

Next Steps

Creating Active Directory objects with LDIFDE and CSVDE tools

How to export passwords from Active Directory

This was last published in September 2003

Dig Deeper on Microsoft Active Directory Design and Administration

Start the conversation

Send me notifications when other members comment.

Register

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchServerVirtualization

SearchCloudComputing

SearchExchange

SearchSQLServer

SearchEnterpriseDesktop

SearchVirtualDesktop

Close