Exporting/Importing Active Directory User Information to a CSV File

I'd like to export all of my AD data into a .CSV file for Manipulation in Excel. Then I'd like to import the data back into the AD. I need all fields including the person's title. I've tried the powershell scripts that come up first in google, but nothing hits the mark yet.  Please try the solution you give before posting it.

Thank you,

Who is Participating?

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

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.

David Johnson, CD, MVPOwnerCommented:
do you have a list of the fields you require?
Guy LidbetterCommented:
Hi John,

You are asking for ALL fields, that is a lot, and some you have no business editing.

Can you be more specific on what you are looking for? Understand, what you would like to do is easily achievable, but you have the potential to cause a lot of harm if you are not specific on what your end goal is.



EDIT: Also bear in mind that Powershell cannot get ALL attributes, only a subset. These can be found here
JohnMan777Author Commented:
This has worked for the exporting:

get-aduser -filter * -properties * | export-csv c:\whatever.txt


I won't be proceeding to the import for a few months, so this is where I stop for now.

Thank you all for your help,


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
JohnMan777Author Commented:
My solution lists the command to get the first half of this goal done. It exports everything, all fields, in one go.

Guy's solution has a fantastic link to the fields that are exportable if I choose to later pick and choose the fields to export.
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.