CSV operations (Import-Csv, Export-Csv) in PowerShell - Step-by-Step Execution

Concept Flow - CSV operations (Import-Csv, Export-Csv)

Start Script

↓

Import-Csv reads file

↓

Data stored as objects

↓

Process or modify data

↓

Export-Csv writes file

↓

End Script

The script starts by reading a CSV file into objects, processes the data, then writes it back to a CSV file.

Execution Sample

PowerShell

Import-Csv -Path 'input.csv' | ForEach-Object {
  $_.Age = [int]$_.Age + 1
  $_
} | Export-Csv -Path 'output.csv' -NoTypeInformation

This script reads 'input.csv', adds 1 to each Age, then saves the updated data to 'output.csv'.

Execution Table

Step	Action	Input Data	Output Data	Notes
1	Import-Csv reads 'input.csv'	CSV file with columns Name, Age	Array of objects [{Name:'Alice', Age:'30'}, {Name:'Bob', Age:'25'}]	CSV converted to objects with string properties
2	ForEach-Object processes each object	{Name:'Alice', Age:'30'}	{Name:'Alice', Age:31}	Age converted to int and incremented by 1
3	ForEach-Object processes each object	{Name:'Bob', Age:'25'}	{Name:'Bob', Age:26}	Age converted to int and incremented by 1
4	Export-Csv writes to 'output.csv'	Array of objects with updated Age	CSV file with updated Age values	Data saved without type information
5	Script ends	N/A	N/A	All data processed and saved

💡 All CSV rows processed and output file created successfully

Variable Tracker

Variable	Start	After 1	After 2	Final
$_	{Name:'Alice', Age:'30'}	{Name:'Alice', Age:31}	{Name:'Bob', Age:'25'}	{Name:'Bob', Age:26}
Data Array	Imported objects	After processing Alice	After processing Bob	Ready for export

Key Moments - 3 Insights

Why does Age change from a string to an integer during processing?

Import-Csv reads all data as strings. We convert Age to int to do math (add 1). See execution_table rows 2 and 3 where Age is changed.

What does the -NoTypeInformation flag do in Export-Csv?

It prevents PowerShell from adding extra type info line at the top of the CSV. This keeps the CSV clean. See execution_table row 4.

Why do we pipe the objects from Import-Csv into ForEach-Object?

Piping sends each object one by one to the processing block, allowing us to modify each row before exporting. See execution_table rows 2 and 3.

Visual Quiz - 3 Questions

Look at the execution_table, what is the Age value of the first object after processing?

A 31

B 30

C 25

D 26

💡 Hint

Check execution_table row 2 Output Data column

At which step does Export-Csv write the updated data to a file?

A Step 2

B Step 4

C Step 3

D Step 5

💡 Hint

Look at execution_table Action column for Export-Csv

If we remove -NoTypeInformation from Export-Csv, what changes in the output file?

A The file will be empty

B The Age values will not increment

C The file will include a type info line at the top

D The file will not save

💡 Hint

Refer to key_moments about -NoTypeInformation flag

Concept Snapshot

Import-Csv reads CSV files into objects.
Each row becomes an object with properties.
Process objects with ForEach-Object.
Export-Csv writes objects back to CSV.
Use -NoTypeInformation to avoid extra header.
Data from CSV is string by default.

Full Transcript

This visual execution shows how PowerShell reads a CSV file using Import-Csv, turning each row into an object with string properties. Then, using ForEach-Object, it processes each object by converting the Age property from string to integer and adding 1. Finally, Export-Csv writes the updated objects back to a new CSV file without extra type information. The variable tracker shows how the current object changes during processing. Key moments clarify why conversion is needed and the role of the -NoTypeInformation flag. The quiz tests understanding of these steps.

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