CSV operations (Import-Csv, Export-Csv) in PowerShell - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the <code>Import-Csv</code> cmdlet do in PowerShell?

It reads data from a CSV file and converts each row into a PowerShell object, making it easy to work with the data in scripts.

beginner

How does Export-Csv help in PowerShell scripting?

It takes PowerShell objects and saves them as a CSV file, allowing you to export data in a simple, readable format.

intermediate

Why is it important to use the -NoTypeInformation parameter with Export-Csv?

Because it prevents PowerShell from adding extra type information as the first line in the CSV file, keeping the file clean and easier to use with other programs.

beginner

Show a simple PowerShell command to import a CSV file named <code>data.csv</code>.

Import-Csv -Path "data.csv"

This command reads the CSV and outputs objects representing each row.

beginner

How can you export a list of objects stored in a variable $users to a CSV file named users.csv without type info?

$users | Export-Csv -Path "users.csv" -NoTypeInformation

This saves the objects as CSV cleanly.

What does Import-Csv return when it reads a CSV file?

A Nothing, it only displays the file

B A list of PowerShell objects representing each row

C A binary file

D A plain text string of the CSV content

Import-Csv converts each row into an object, making it easy to work with data in scripts.

Which parameter prevents extra type info from being added when exporting CSV?

A -SkipHeader

B -CleanOutput

C -Raw

D -NoTypeInformation

The -NoTypeInformation parameter stops PowerShell from adding type info as the first line.

How do you export objects stored in $data to a CSV file named output.csv?

A Import-Csv -Path output.csv

B Export-Csv -Input $data -File output.csv

C $data | Export-Csv -Path "output.csv" -NoTypeInformation

D Save-Data -File output.csv

Use the pipeline to send objects to Export-Csv with the file path and -NoTypeInformation.

What is the default delimiter used by Import-Csv and Export-Csv?

A Comma (,)

B Semicolon (;)

C Tab (\t)

D Pipe (|)

CSV stands for Comma-Separated Values, so the default delimiter is a comma.

If you want to read a CSV file and filter rows where the 'Age' column is greater than 30, which cmdlet would you use first?

A Import-Csv

B Export-Csv

C Get-Content

D ConvertTo-Csv

You first import the CSV as objects with Import-Csv to filter by properties like 'Age'.

Explain how you would use PowerShell to read a CSV file, modify some data, and save it back to a new CSV file.

Think about reading, changing, then writing data.

Describe why CSV files are useful in scripting and automation tasks.

Consider how CSV helps move data between tools.