Active directory user export to csv file

How to export user of active directory into .CSV file.
SmukhtarAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MASEE Solution Guide - Technical Dept HeadCommented:
Please check this
Get-ADUser -Filter * -SearchBase "ou=Ou,dc=domain,dc=local" -Properties * | Export-Csv  "c:\ADUsers.csv"

Open in new window

http://technet.microsoft.com/en-us/library/ee617241.aspx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mac carterCommented:
You can use Get-ADUser and Export-Csv cmdlets like below:

Get-ADUser -Filter * -SearchBase "ou=Ou,dc=contoso,dc=com" -Properties * | Export-Csv  "c:\somefile.csv"

The parameter "-Filter" is used to specify the query string, "-SearchBase" to specify an Active Directory path to search under and the "-Properties" to specify user's properties you want to export.
For more details please refer to above given reference.

You can use Power Shell or any other scripting language.  You can even use DS commands.
Here are some examples - http://social.technet.microsoft.com/wiki/contents/articles/3537.active-directory-domain-services-ad-ds-commands-and-scripts.aspx

Meanwhile try this:
At a glance pure & gold result. Go ahead with below lines.
> dsquery user -name * -limit 0 >> c:\users.txt & c:\users.txt
Import the text file in excel and filter it from Data>>>>>Text to columns


Also have a look on below given informative post.

Exporting Data from an Active Directory Organizational Unit: https://redmondmag.com/articles/2015/01/14/exporting-ad-data.aspx

Step-by-Step Guide to Bulk Import and Export to Active Directory Using the LDIFDE Utility: https://technet.microsoft.com/en-us/library/bb727091.aspx

Hope it helps you!
SmukhtarAuthor Commented:
any free tool who can easily do it.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Active Directory

From novice to tech pro — start learning today.