Can I export data from an organizational unit in Active Directory Users and Computers to an Excel spreadsheet?
by Zubair Alexander
9/14/2009 -- We are running Windows Server 2003 at our company. Can I export data from an organizational unit in Active Directory Users and Computers to an Excel spreadsheet?
Answer:
Yes, you can use the export feature in Active Directory Users and Computers to perform this task. You can export data to a text file, either a Tab Delimited (.TXT) or Comma Delimited (.CSV) file. You can then open the file in Excel. Here's the step-by-step procedure.
Open the Active Directory Users and Computers console.
Select the organizational unit (OU) you want to work with.
Right-click the OU and select Export List.
You will have the option to save the file as a text file in either.TXT or .CSV format in the "Save as type" box.
Select the .CSV file type so when you save the file, you can open it in Excel by simply double-clicking it. If you select .TXT, you'll have to import the file in Excel and go through some extra steps.
Double-click the saved .CSV file to open it and manipulate the data to configure the way you want.
If you're interested only in certain types of objects (for example: users), you can filter the list first and then export the data.
For example, to export only user objects in the list, select Filter Options from the View menu.
Click the radio button for "Show only the following types of objects."
[Click on image for larger view.]
Notice that by default, "Show all types of objects" is selected. Check the box for the users object and click OK. Now when you export the list it will only include the users objects.
You can only export a list, not import it. If you want to import data into Active Directory Users and Computers, there are lots of tools available to do that. Don't forget to reset the filter options when you're done.
Zubair Alexander, MCSE, MCT, MCSA and Microsoft MVP is the founder of SeattlePro Enterprises, an IT training and consulting business. His experience covers a wide range of spectrum: trainer, consultant, systems administrator, security architect, network engineer, author, technical editor, college instructor and public speaker. Zubair holds more than 25 technical certifications and Bachelor of Science degrees in Aeronautics & Astronautics Engineering, Mathematics and Computer Information Systems. His Web site, www.techgalaxy.net, is dedicated to technical resources for IT professionals. Zubair may be reached at .
Home | Microsoft® | Cisco® | Oracle® | A+/Network+" | Linux/Unix | MOS | Security | List of Certs Advertise | Contact Us | Contributors | Features | Forums | News | Pop Quiz | Tips | Press Releases | RSS Feeds Search | Site Map | Redmond Media Group | TechMentor Conferences | Tech Library Webcasts This Web site is not sponsored by, endorsed by or affiliated with Cisco Systems, Inc., Microsoft Corp., Oracle Corp., The Computing Technology Industry Association, Linus Torvolds, or any other certification or technology vendor. CiscoÆ and Cisco SystemsÆ are registered trademarks of Cisco Systems, Inc. Microsoft, Windows and Windows NT are either registered trademarks or trademarks of Microsoft Corp. OracleÆ is a registered trademark of Oracle Corp. A+Æ, i-Net+T, Network+T, and Server+T are trademarks and registered trademarks of The Computing Technology Industry Association. (CompTIA). LinuxT is a registered trademark of Linus Torvalds. All other trademarks belong to their respective owners.
Reprints allowed with written permission from the publisher. For more information, e-mail
Application Development Trends | Campus Technology | CertCities.com | The Data Warehousing Institute
E-Gov | EduHound | ENTmag.com | Enterprise Systems | Federal Computer Week | FTPOnline.com | Government Health IT
IT Compliance Institute | MCPmag.com | Recharger | Redmond Developer News | Redmond | Redmond Events | Redmond Channel Partner | Redmond Report
TCPmag.com | T.H.E. Journal | Virtualization Review | Visual Studio Magazine | VSLive!
Copyright 1996-2009 1105 Media, Inc. See our Privacy Policy.