heres the plan,

i need to export all AD users, then using a excel file fill in the missing information, so job title, department, location etc....

PEople are not in the base OU of users, they are in multiple containers

Domain, Location, Department.

so i need to export them, either manually or some other way fill in all the information from the excel spreadsheet, then bulk import this back into AD.

Can someone please advise me on doing this via powershell?

Thanks in advance for any advice you can give me...

Easy:

Get-AdUser -filter * | select distinguishedname | export-csv myusers.csv -NoType

Look in the 'Gallery' for prebuilt scripts that input users from an CSV file of spreadsheet.

 

You might want to add in -Properties * to Get-ADUser as well.