CertCities.com -- The Ultimate Site for Certified IT Professionals
Keep on Top of the Latest Certification News: Subscribe to CertCities.com Newsletter Share share | bookmark | e-mail
  Microsoft®
  Cisco®
  Security
  Oracle®
  A+/Network+"
  Linux/Unix
  More Certs
  Newsletters
  Salary Surveys
  Forums
  News
  Exam Reviews
  Tips
  Columns
  Features
  PopQuiz
  RSS Feeds
  Press Releases
  Contributors
  About Us
  Search
 

Advanced Search
  Free Newsletter
  Sign-up for the #1 Weekly IT
Certification News
and Advice.
Subscribe to CertCities.com Free Weekly E-mail Newsletter
CertCities.com

See What's New on
Redmondmag.com!

Cover Story: IE8: Behind the 8 Ball

Tech-Ed: Let's (Third) Party!

A Secure Leap into the Cloud

Windows Mobile's New Moves

SQL Speed Secrets


CertCities.com
Let us know what you
think! E-mail us at:



 
 
...Home ... Editorial ... Columns ..Column Story Saturday: April 5, 2014


 Tip o'the Week  
Zubair Alexander
Zubair Alexander


 Exporting Data from AD Users and Computers
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.

  1. Open the Active Directory Users and Computers console.

  2. Select the organizational unit (OU) you want to work with.

  3. Right-click the OU and select Export List.

  4. 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.

  5. 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.

  6. 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.

  1. For example, to export only user objects in the list, select Filter Options from the View menu.

  2. Click the radio button for "Show only the following types of objects."

    Request
    [Click on image for larger view.]

  3. 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 .

 


More articles by Zubair Alexander:

-- advertisement --


There are 49 CertCities.com user Comments for “Exporting Data from AD Users and Computers”
Page 1 of 5
6/30/13: michael kors outlet from [email protected] says: ths michael kors outlet http://www.michaelkorsioutlet.org/
7/1/13: louis vuitton outlet from [email protected] says: good share. louis vuitton outlet http://www.louisvuittonttoutlet.com
7/4/13: christianlouboutinoutleta.com from [email protected] says: nice articles christianlouboutinoutleta.com http://www.christianlouboutinoutleta.com
7/5/13: gucci outlet online from [email protected] says: good share. gucci outlet online http://www.guccioutletstore-online.com
7/23/13: Oakley For Sale from [email protected] says: Transform your own sunglass into a full-scale Goldmine Oakley For Sale http://www.fake-oakleysus.com
7/24/13: Fake Oakleys from [email protected] says: The Spectacular Thriving Juice In sunglass Fake Oakleys http://www.fakeoakleysglasses.com
7/25/13: cheap sunglasses from [email protected] says: thank you for share! cheap sunglasses http://www.cheap-sunglass.net/
7/26/13: fitflops Sale UK from [email protected] says: Weekly shoes Wrap up is without question beginning to feel quite outdated fitflops Sale UK http://www.fitflopsshoesoutlet.com
7/27/13: FakeOakleySunglasses from [email protected] says: An sunglass crawl Dash panel widget Fake Oakley Sunglasses http://www.replicaoakleysglasses.com
7/29/13: Toms Outlet from [email protected] says: Just remember Each time You Could get the latest shoes free of charge, But You Didn't?? Toms Outlet http://www.tomscanadaoutlets.com
First Page   Next Page   Last Page
Your comment about: “Exporting Data from AD Users and Computers”
Name: (optional)
Location: (optional)
E-mail Address: (optional)
Comment:
   

-- advertisement (story continued below) --

top