Import csv column wise

Hi All,
Thanks in advance, I have a script that runs a report to retrieve email addresses from Exchange by importing a csv file, the csv file will carry the samaccountname of the users. This csv file will be created everytime and the powershell script will import this csv file.
Now, I want to import the csv file column wise, the thing is there is no header in the csv file.
1st column carries the list of samaccountname and the second column carries the list of recipients for which the report of email address report has to be shared.

All I am looking for is how to import-csv file column wise

You can specify the header when you import:

Import-Csv .\nohead.csv -Header sAMAccountName,email
1 Like