Menu Close

How To Export Users From Active Directory

Today I’m going to show you how to export users from Active Directory. Active directory users list are required for many admins, especially when they migrate mailboxes. This is a little painful to export users from Active Directory, especially in a bigger environment. Fortunately, a powershell command helps to generate a list of users to accomplish the task. I am glad to show you how to learn.

There are two ways to export users from active directory. They are listed below.

Exchange Admin Center

The first option is obviously the Exchange Admin Center. To do this,

  • Go to “Exchange Admin Center
  • Select “Recipients
  • Select “Mailboxes
  • Click More Options (…)
  • Select Export data to a CSV file
How to export users from Active Directory
  • Do a filter based on your requirements and select “Export
How to export users from Active Directory
  • Wait for a few minutes to get the report exported.

Note: By default, Exchange Admin Center exports only 20K users into CSV file.


The easiest and effective way of exporting users is Powershell. Many of you prefer to use Powershell instead of the GUI so here is what you expected. This may take some time to complete because of the no limitation in exporting data like the GUI.

Go to Windows Powershell and execute the command.

Get-ADUser -Filter ‘Company -like “techieberry*”‘ -Properties * | Select -Property EmailAddress,Surname,DisplayName | Export-CSV “C:\users\ADusers.csv” -NoTypeInformation -Encoding UTF8

To get more information, visit Microsoft website.

Want to improve your Exchange Online experience for better productivity? Check out the tips and tricks mentioned here.

Now I’d like to hear from you:

Which finding from today’s report did you find most interesting? Or maybe you have a question about something that I covered.

Either way, I’d like to hear from you. So go ahead and leave a comment below.

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *