Get users from CSV, foreach user, get country, name, etc., then Export

SS9911 

Hi.

If your CSV has neither headers nor delimited columns, then it's just a text file and not a CSV. Though at the end you say "my Excel", and Excel (.xlsx file extension) is a whole different discussion.

Assuming Excel has nothing to do with this, then you can get what you want with a simple script.

Input file

Example

Get-Content -Path "D:\Data\Temp\Forum\myInputFile.csv" |
    ForEach-Object {
        Get-ADUser -Filter { (userPrincipalName -eq $_) } -Properties country, department, enabled, title, userPrincipalName
    } |
        Select-Object -Property userPrincipalName, enabled, title, department |
            Export-Csv -NoTypeInformation -Path "D:\Data\Temp\Forum\myExportFile.csv";

Output file

Cheers,

Lain