<div>
You can use command line utility called CSVDE to export required information into .csv format that can be easily opened into Excel.<br />
<br />
Like:<br />
Click Start -&gt; Run -&gt; Cmd.exe -&gt; OK<br />
<br />
CSVDE &nbsp;-R &quot;(objectCategory=user)&quot; -L givenName,sn,sAMAccountNam<wbr />e,mail -F UserInfo.csv<br />
<br />
Above statement will create UserInfo.csv file. <br />
<br />
OR <br />
Directory Users and Computers (ADUC):<br />
1. &nbsp;Open ADUC and go to the OU you want to export<br />
2. &nbsp;Click View - Add/Remove Colums - and select / arrange the attributes you want to export<br />
3. &nbsp;Click Action - Export<br />
<br />
Hope this helps!<br />
Farhan
</div>


You can use command line utility called CSVDE to export required information into .csv format that can be easily opened into Excel.

Like:
Click Start -> Run -> Cmd.exe -> OK

CSVDE  -R "(objectCategory=user)" -L givenName,sn,sAMAccountName,mail -F UserInfo.csv

Above statement will create UserInfo.csv file.

OR
Directory Users and Computers (ADUC):
1.  Open ADUC and go to the OU you want to export
2.  Click View - Add/Remove Colums - and select / arrange the attributes you want to export
3.  Click Action - Export

Hope this helps!
Farhan

<div>
<div class="content wysiwyg-content">
We have a lot of user accounts that are old and should be removed. &nbsp;However I need a way to export the list off all the user accounts from AD to excel or word so that I can show it to the boss and get his help deciding which accounts should be removed. &nbsp;Anyone know of a way to do this?
</div>
</div>


We have a lot of user accounts that are old and should be removed.  However I need a way to export the list off all the user accounts from AD to excel or word so that I can show it to the boss and get his help deciding which accounts should be removed.  Anyone know of a way to do this?

Export AD User accounts to excel

Active Directory (AD) is a Microsoft brand for identity-related capabilities. In the on-premises world, Windows Server AD provides a set of identity capabilities and services, and is hugely popular (88% of Fortune 1000 and 95% of enterprises use AD). This topic includes all things Active Directory including DNS, Group Policy, DFS, troubleshooting, ADFS, and all other topics under the Microsoft AD and identity umbrella.

Active Directory

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).