Export Active Directory To CSV - Users To Excel

It is very useful indeed to keep a copy of all Active Directory users and associated info in a spreadsheet. One of the greatest uses is to easily know the SID of a user when you have to start editing the registry and finding their relevant sub-key.

You can get all this info using Powershell.

First you need to install the free Dell/Quest "ActiveRoles Management Shell for Active Directory" which is a set of free Powershell commands you can use to interrogate your Active Directory and get information from it. Get the download here.

After that, simply open up Powershell, load the snap-in and then execute the command to import the data to a csv. Here's exactly how:

add-PSSnapin quest.activeroles.admanagement
Get-QADUser -SizeLimit 0 |Export-Csv c:\users.csv

You'll see there's a ton of info, nearly 100 columns if I remember correctly!