CSV operations (Import-Csv, Export-Csv) in PowerShell - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to import a CSV file named 'data.csv' into a variable.

PowerShell

$data = [1] -Path 'data.csv'

Drag options to blanks, or click blank then click option'

AImport-Csv

BExport-Csv

CConvertTo-Csv

DGet-Content

Attempts:

3 left

💡 Hint

Common Mistakes

Using Export-Csv instead of Import-Csv.

Using Get-Content which reads raw text, not objects.

The Import-Csv cmdlet reads a CSV file and converts it into objects in PowerShell.

2fill in blank

medium

Complete the code to export the variable $data to a CSV file named 'output.csv' without type information.

PowerShell

$data | [1] -Path 'output.csv' -NoTypeInformation

Drag options to blanks, or click blank then click option'

AConvertTo-Csv

BImport-Csv

CExport-Csv

DOut-File

Attempts:

3 left

💡 Hint

Common Mistakes

Using Import-Csv instead of Export-Csv.

Using ConvertTo-Csv which outputs CSV text but does not save to file.

The Export-Csv cmdlet converts objects into CSV format and saves them to a file.

3fill in blank

hard

Fix the error in the code to import 'records.csv' and select only the 'Name' column.

PowerShell

$names = [1] -Path 'records.csv' | Select-Object Name

Drag options to blanks, or click blank then click option'

AExport-Csv

BGet-Content

CConvertTo-Csv

DImport-Csv

Attempts:

3 left

💡 Hint

Common Mistakes

Using Get-Content which reads raw text, not objects.

Using Export-Csv which writes CSV files.

To read CSV data as objects, use Import-Csv. Then you can select columns.

4fill in blank

hard

Fill both blanks to filter imported CSV data where Age is greater than 30.

PowerShell

$filtered = [1] -Path 'people.csv' | Where-Object { $_.Age [2] 30 }

Drag options to blanks, or click blank then click option'

AImport-Csv

BExport-Csv

C>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using Export-Csv instead of Import-Csv.

Using '<' instead of '>' for the age comparison.

Use Import-Csv to read the file, then filter with Where-Object using the 'greater than' operator.

5fill in blank

hard

Fill all three blanks to create a CSV from $users with only 'Username' and 'Email' where 'Active' is true.

PowerShell

$activeUsers = { [1]: [2], Email: $_.Email for [3] in $users if $_.Active } | Export-Csv -Path 'active.csv' -NoTypeInformation

Drag options to blanks, or click blank then click option'

AUsername

B$_.Username

Cuser

DEmail

Attempts:

3 left

💡 Hint

Common Mistakes

Using $_ instead of a variable name in the loop.

Not matching keys and values correctly in the hashtable.

This creates a custom object with Username and Email for each active user, then exports to CSV.

Practice

1. What does the PowerShell cmdlet Import-Csv do?

easy

A. Reads a CSV file and converts each row into an object

B. Saves objects into a CSV file

C. Deletes a CSV file from disk

D. Converts objects into JSON format

Solution

1. Step 1: Understand the purpose of Import-Csv

   Import-Csv reads data from a CSV file and creates objects where each row is an object with properties matching the CSV headers.

2. Step 2: Compare with other options

   Export-Csv saves objects to CSV, deletion and JSON conversion are unrelated to Import-Csv.

3. Final Answer:

   Reads a CSV file and converts each row into an object -> Option A

4. Quick Check:

   Import-Csv = Reads CSV to objects [OK]

Hint: Import-Csv reads CSV; Export-Csv writes CSV [OK]

Common Mistakes:

• Confusing Import-Csv with Export-Csv
• Thinking Import-Csv deletes files
• Assuming Import-Csv converts to JSON

2. Which of the following is the correct syntax to export objects to a CSV file named data.csv?

easy

A. Export-Csv -Path data.csv -InputObject $objects

B. Import-Csv -Path data.csv -InputObject $objects

C. Export-Csv $objects data.csv

D. Export-Csv -File data.csv -Objects $objects

Solution

1. Step 1: Identify correct Export-Csv syntax

   The correct syntax uses -Path to specify the file and -InputObject for the objects to export.

2. Step 2: Eliminate incorrect options

   Import-Csv is for reading, not exporting. Options A and D use wrong parameter names or order.

3. Final Answer:

   Export-Csv -Path data.csv -InputObject $objects -> Option A

4. Quick Check:

   Export-Csv uses -Path and -InputObject [OK]

Hint: Use -Path for file and -InputObject for data in Export-Csv [OK]

Common Mistakes:

• Using Import-Csv instead of Export-Csv
• Wrong parameter names like -File or -Objects
• Omitting parameter names and relying on position

3. Given the CSV file users.csv with content:

Name,Age
Alice,30
Bob,25

What will the following PowerShell command output?

Import-Csv users.csv | Where-Object { $_.Age -gt 27 } | Select-Object -ExpandProperty Name

medium

A. No output

B. Bob

C. Alice`nBob

D. Alice

Solution

1. Step 1: Import and filter CSV data

   The command imports the CSV, then filters rows where Age > 27. Alice's age is 30, Bob's is 25, so only Alice passes.

2. Step 2: Select and output the Name property

   Select-Object -ExpandProperty Name outputs the Name value directly, so output is 'Alice'.

3. Final Answer:

   Alice -> Option D

4. Quick Check:

   Filter Age > 27 = Alice [OK]

Hint: Filter with Where-Object, then expand property for direct output [OK]

Common Mistakes:

• Confusing string output with array output
• Using -ExpandProperty incorrectly
• Assuming both names print without filtering

4. You run this command to export data:

$data | Export-Csv -Path output.csv

But the CSV file contains extra quotes around each field. How can you fix this?

medium

A. Use Import-Csv instead of Export-Csv

B. Add the parameter -NoQuotes to Export-Csv

C. Add the parameter -NoTypeInformation to Export-Csv

D. Use Export-Csv -Raw to avoid quotes

Solution

1. Step 1: Understand default Export-Csv behavior

   By default, Export-Csv adds type information as the first line and quotes fields. The extra quotes are normal but can be controlled.

2. Step 2: Use -NoTypeInformation to remove type info and reduce quotes

   Adding -NoTypeInformation removes the type info line and often reduces unnecessary quotes.

3. Final Answer:

   Add the parameter -NoTypeInformation to Export-Csv -> Option C

4. Quick Check:

   -NoTypeInformation removes extra info and quotes [OK]

Hint: Use -NoTypeInformation to clean Export-Csv output [OK]

Common Mistakes:

• Trying to use non-existent -NoQuotes parameter
• Confusing Import-Csv with Export-Csv
• Using -Raw which is invalid for Export-Csv

5. You have a CSV file products.csv with columns Id,Name,Price. You want to increase the price by 10% and save the updated data back to products.csv. Which script correctly does this?

hard

A. Import-Csv products.csv | ForEach-Object { $_.Price = $_.Price + 10 } | Export-Csv products.csv

B. $products = Import-Csv products.csv; $products | ForEach-Object { $_.Price = [math]::Round($_.Price * 1.1, 2) }; $products | Export-Csv -Path products.csv -NoTypeInformation

C. $products = Import-Csv products.csv; foreach ($p in $products) { $p.Price = $p.Price * 1.1 }; Export-Csv $products products.csv

D. Import-Csv products.csv | ForEach-Object { $_.Price = $_.Price * 1.1 } > products.csv

Solution

1. Step 1: Import CSV and update prices correctly

   $products = Import-Csv products.csv; $products | ForEach-Object { $_.Price = [math]::Round($_.Price * 1.1, 2) }; $products | Export-Csv -Path products.csv -NoTypeInformation imports CSV into $products, then uses ForEach-Object to update each Price by multiplying by 1.1 and rounding to 2 decimals.

2. Step 2: Export updated objects back to CSV with -NoTypeInformation

   $products = Import-Csv products.csv; $products | ForEach-Object { $_.Price = [math]::Round($_.Price * 1.1, 2) }; $products | Export-Csv -Path products.csv -NoTypeInformation exports $products back to the same file with -NoTypeInformation to avoid extra lines.

3. Step 3: Identify errors in other options

   Import-Csv products.csv | ForEach-Object { $_.Price = $_.Price + 10 } | Export-Csv products.csv adds 10 instead of 10%, $products = Import-Csv products.csv; foreach ($p in $products) { $p.Price = $p.Price * 1.1 }; Export-Csv $products products.csv has wrong Export-Csv syntax, Import-Csv products.csv | ForEach-Object { $_.Price = $_.Price * 1.1 } > products.csv redirects output incorrectly.

4. Final Answer:

   $products = Import-Csv products.csv; $products | ForEach-Object { $_.Price = [math]::Round($_.Price * 1.1, 2) }; $products | Export-Csv -Path products.csv -NoTypeInformation -> Option B

5. Quick Check:

   Import, update with ForEach-Object, Export with -NoTypeInformation [OK]

Hint: Use Import-Csv, update in ForEach-Object, then Export-Csv -NoTypeInformation [OK]

Common Mistakes:

• Adding fixed amount instead of percentage
• Wrong Export-Csv parameter order or syntax
• Redirecting output instead of using Export-Csv