Link to home
Start Free TrialLog in
Avatar of John Caspary
John Caspary

asked on

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,

John
Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

do you have a list of the fields you require?
SOLUTION
Avatar of Guy Lidbetter
Guy Lidbetter
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of John Caspary
John Caspary

ASKER

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.