CSV operations (Import-Csv, Export-Csv) in PowerShell - Practice Problems & Coding Challenges

Challenge - 5 Problems

💻 Command Output

intermediate

What is the output of this Import-Csv command?

Given a CSV file named data.csv with the following content:

Id,Name,Age
1,Alice,30
2,Bob,25

What will be the output of this PowerShell command?

Import-Csv -Path 'data.csv' | ForEach-Object { $_.Name }

PowerShell

Import-Csv -Path 'data.csv' | ForEach-Object { $_.Name }

A

Id
Name
Age

B

Alice
Bob

C

30
25

D

1
2

💡 Hint

Import-Csv reads the CSV and creates objects with properties matching the headers.

Import-Csv reads each row as an object with properties Id, Name, and Age. The command selects the Name property, so it outputs the names 'Alice' and 'Bob'.

💻 Command Output

intermediate

What does this Export-Csv command produce?

Consider this PowerShell code:

$data = @(
  @{Id=1; Name='Alice'; Age=30},
  @{Id=2; Name='Bob'; Age=25}
)
$data | Export-Csv -Path 'output.csv' -NoTypeInformation

What will be the content of output.csv?

PowerShell

$data = @(@{Id=1; Name='Alice'; Age=30}, @{Id=2; Name='Bob'; Age=25})
$data | Export-Csv -Path 'output.csv' -NoTypeInformation

A

Id,Name,Age
1,Alice,30
2,Bob,25

B

@{Id=1; Name=Alice; Age=30}
@{Id=2; Name=Bob; Age=25}

C

"Id","Name","Age"
"1","Alice","30"
"2","Bob","25"

D

TypeId
System.Management.Automation.PSCustomObject
System.Management.Automation.PSCustomObject

💡 Hint

Export-Csv outputs CSV with quoted values by default and includes headers.

Export-Csv creates a CSV file with headers and quotes around each field. The -NoTypeInformation flag omits the type info line.

🔧 Debug

advanced

Why does this Import-Csv command fail?

You run this command:

Import-Csv -Path 'missing.csv'

But you get an error:
Import-Csv : Cannot find path 'missing.csv' because it does not exist.
What is the cause?

PowerShell

Import-Csv -Path 'missing.csv'

A The file 'missing.csv' does not exist in the current directory.

B Import-Csv cannot read CSV files with .csv extension.

C The command requires -Delimiter parameter to work.

D PowerShell does not support Import-Csv on Windows.

💡 Hint

Check if the file path is correct and the file exists.

The error means the file path is invalid or the file is missing. Import-Csv needs an existing file to read.

🚀 Application

advanced

How to filter CSV rows with Import-Csv and Export-Csv?

You have a CSV file users.csv with columns: Id, Name, Age.
You want to create a new CSV adults.csv containing only rows where Age is 18 or more.
Which PowerShell command does this correctly?

A Import-Csv users.csv | ForEach-Object { if ($_.Age -ge 18) { $_ } } | Export-Csv adults.csv

B Import-Csv users.csv | Where-Object { $_.Age -lt 18 } | Export-Csv adults.csv

C Get-Content users.csv | Where { $_ -ge 18 } | Export-Csv adults.csv

D Import-Csv users.csv | Where-Object { [int]$_.Age -ge 18 } | Export-Csv adults.csv -NoTypeInformation

💡 Hint

Use Where-Object to filter and Export-Csv with -NoTypeInformation to save.

Option D correctly converts Age to int and filters rows with Age >= 18, then exports without type info.

🧠 Conceptual

expert

What is the effect of the -NoTypeInformation parameter in Export-Csv?

When using Export-Csv in PowerShell, what does the -NoTypeInformation parameter do?

A It prevents adding a type information line at the top of the CSV file.

B It disables exporting the header row with column names.

C It encrypts the CSV file to protect data.

D It converts all data to string before exporting.

💡 Hint

Check the first line of CSV files exported with and without this parameter.

By default, Export-Csv adds a line with type info like '#TYPE System.Management.Automation.PSCustomObject'. -NoTypeInformation omits this line.