Topics for PowerShell’s ConvertFrom-CSV

To see ConvertFrom-Csv in action let us create a file using notepad, or better still Excel. In the test file create 3 rows of data with each item separated by the default delimiter, the comma, and then ‘Save as’ using a .txt or .csv extension. Here is an example:

Colour,Ford,Audi,NissanBlue,87,37,45Red,56,21,23 Green,41,32,44

Save the file; call it cars.csv. Make a note of the full pathname, mine was D: \PShell\cars.csv.

Alternatively, you could call it research.txt, it does not require a csv file extension.

Note 2: The neatest way to view this data is to employ Out-GridView to take care of the formatting. Real-life examples have more rows than this test file, this is where Out-GridView’s ability to filter the data is valuable.

Guy Recommends: SolarWinds’ Free Bulk Import Tool

Import users from a spreadsheet. Just provide a list of the users with their fields in the top row, and save as .csv file. Then launch this FREE utility and match your fields with AD’s attributes, click and import the users.