Import CSV with PowerShell foreach: A Practical Guide

Learn how to import CSV data in PowerShell and process rows with foreach using Import-Csv and ForEach-Object. This guide covers delimiters, headers, error handling, and exporting results for automation tasks.

MyDataTables Team

March 25, 2026·5 min read

CSV Delimiter CSV Import MyDataTables CSV Headers CSV Tools

Quick AnswerSteps

To import CSV data in PowerShell and iterate each row, start with Import-Csv to load records, then pipe to ForEach-Object or a foreach loop for per-row processing. This approach handles comma-delimited files with headers, supports custom delimiters, and enables simple transformations, filtering, and aggregation during the loop. It works across Windows PowerShell and PowerShell Core, and you can expand it with error handling and output formatting as needed.

Import CSV with PowerShell: The Basics of import csv powershell foreach

The combination of Import-Csv and foreach in PowerShell provides a straightforward method to read CSV data into objects and iterate over rows. In this article, we use the keyword import csv powershell foreach to anchor the discussion and ensure practical guidance for data analysts and developers. According to MyDataTables, this pattern scales well from small datasets to larger ones when used with proper streaming considerations. The approach works on Windows PowerShell and PowerShell Core, and it forms the foundation for more advanced transformations and reporting.

PowerShell

# Basic import and per-row processing
Import-Csv -Path ".\\customers.csv" | ForEach-Object {
  Write-Output "Customer: $($_.Name) - Email: $($_.Email)" 
}

PowerShell

# Access a single field directly
$firstRow = Import-Csv -Path ".\\customers.csv" | Select-Object -First 1
$firstName = $firstRow.Name

Handling Delimiters and Headers in CSV Imports

CSV files vary: some use semicolons, pipes, or tabs; some lack header rows. The Import-Csv cmdlet infers header names from the first row, but you can override with -Header to supply your own field names. Use -Delimiter to specify a non-comma separator. This flexibility is essential when integrating with legacy data sources. According to MyDataTables, you can tailor imports for robustness across environments.

PowerShell

# Customized delimiter and header override
Import-Csv -Path ".\\sales.tsv" -Delimiter "`t" -Header "Date","Product","Quantity","Price" | ForEach-Object {
  # process each row
  $_.Date, $_.Product, $_.Quantity
}

PowerShell

# Without headers, building objects explicitly
Import-Csv -Path ".\\data.csv" -Header "Id","Value" | ForEach-Object {
  [PSCustomObject]@{ ID = $_.Id; Value = $_.Value }
}

Using foreach vs ForEach-Object: Performance and style

PowerShell offers both the foreach keyword and the ForEach-Object cmdlet for per-row processing. The foreach loop is often clearer for complex logic, while ForEach-Object shines in pipelines and streaming scenarios. Example usage:

PowerShell

# foreach keyword
foreach ($row in Import-Csv -Path ".\\data.csv" ) {
  Write-Output "$($row.Name) <$row.Email>"
}

PowerShell

# ForEach-Object in a pipeline
Import-Csv -Path ".\\data.csv" | ForEach-Object {
  # mutate or analyze
  $_ | Add-MemoryInfo
  $_
}

Building transformed objects and aggregations

Often you need to transform raw CSV rows into a structured summary. Build PSCustomObjects and collect results for export or reporting. This example creates a summary with a boolean flag and numeric conversion, then writes to CSV:

PowerShell

$summary = Import-Csv -Path ".\\data.csv" | ForEach-Object {
  [PSCustomObject]@{
    Name   = $_.Name
    Active = $_.Status -eq "Active"
    Amount = [decimal]$($_.Amount)
  }
}
$summary | Export-Csv -Path ".\\summary.csv" -NoTypeInformation

This pattern scales to larger datasets and supports chaining to ConvertTo-Json for API consumption.

Error handling and streaming considerations

Error handling is essential when automating CSV processing. Use Try/Catch blocks around Import-Csv, especially for large or remote sources. PowerShell errors can be escalated with -ErrorAction Stop to ensure they land in Catch for cleanup or retry logic. Example:

PowerShell

try {
  Import-Csv -Path ".\\big.csv" -ErrorAction Stop | ForEach-Object {
    # processing
  }
} catch {
  Write-Error "CSV read failed: $_"
}

For very large files, consider streaming approaches or chunked processing to reduce memory footprint, and validate input schemas before heavy processing.

Working with large CSVs: memory and performance tips

When dealing with large CSVs, streaming and chunked processing helps avoid excessive memory use. Avoid loading the entire file into memory if possible; instead, process in chunks and write incremental results. Consider using Get-Content to stream lines and ConvertFrom-Csv on blocks:

PowerShell

# Process in chunks by streaming lines
Get-Content -Path ".\\large.csv" -ReadCount 1000 | ForEach-Object {
  $rows = $_ | ConvertFrom-Csv -Delimiter ","
  foreach ($r in $rows) {
    # process $r
  }
}

For complex schemas, maintain a small in-memory map and flush results periodically to disk.

Practical example: filtering and exporting

A common task is filtering and exporting a subset of data. The following example keeps only Open orders and writes a compact summary:

PowerShell

Import-Csv -Path ".\\orders.csv" | Where-Object { $_.Status -eq "Open" } | 
  Select-Object OrderId, Customer, Total |
  Export-Csv -Path ".\\open_orders.csv" -NoTypeInformation

This pattern can be extended with grouping and aggregate calculations as needed.

Debugging and common pitfalls

Begin with header inspection and a quick sample to validate your assumptions. This helps avoid runtime errors due to missing fields or mismatched delimiters.

PowerShell

# Check headers
Import-Csv -Path ".\\data.csv" -Delimiter "," | Get-Member -MemberType NoteProperty

# Validate a sample row
$row = Import-Csv -Path ".\\data.csv" | Select-Object -First 1
Write-Output "First row: Name=$($row.Name) Email=$($row.Email)"

If headers mismatch, fix the source CSV or override with -Header accordingly.

Other approaches include converting from a raw string or using ConvertFrom-Csv on streamed content. This can be handy when data is embedded in logs or API responses. Example:

PowerShell

# Alternative: ConvertFrom-Csv with a single string
$content = Get-Content ".\\data.csv" -Raw
$rows = $content | ConvertFrom-Csv
foreach ($r in $rows) {
  # ...
}

Adopt the approach that minimizes memory usage while preserving readability and maintainability.

Steps

Estimated time: 45-75 minutes

1
Prepare the CSV and environment
Ensure the CSV has a header row or supply headers with -Header. Confirm the delimiter matches the file, and pick the PowerShell version you use.
Tip: Start with a small sample to validate field names.
2
Import the CSV
Use Import-Csv to read the file into objects and set up the pipeline.
Tip: Prefer Import-Csv over Get-Content + ConvertFrom-Csv for readability.
3
Process each row
Choose foreach or ForEach-Object to implement per-row logic and transformations.
Tip: Keep logic stateless within the loop for easier testing.
4
Transform and summarize
Create PSCustomObject results and accumulate necessary fields.
Tip: Use [decimal] casts for monetary fields to avoid string math.
5
Output results
Export to CSV, JSON, or display; align with downstream systems.
Tip: Use -NoTypeInformation to keep CSV clean.

Pro Tip: Override headers with -Header when the source has no header row.

Warning: Large CSVs can exhaust memory; prefer streaming and chunked processing.

Note: Prefer PSCustomObject for predictable output shapes.

Prerequisites

Required

PowerShell 5.1+ (Windows) or PowerShell Core 7+ (cross-platform)↗
Required
CSV file(s) to import
Required
Basic PowerShell knowledge (pipelines, variables, objects)
Required

Optional

Editor or terminal with access to PowerShell
Optional
Error handling concepts (try/catch, -ErrorAction)
Optional

Commands

Action	Command
Import CSV fileDefault delimiter is comma; adjust with -Delimiter	`Import-Csv -Path '.\\data.csv' -Delimiter ','`
Iterate rowsUsing the pipeline keeps memory usage stable for moderate files	`Import-Csv -Path '.\\data.csv' \| ForEach-Object { ... }`
Export resultsUse -Append to accumulate results if needed	`Export-Csv -Path '.\\result.csv' -NoTypeInformation`
Convert to JSONFor API payloads or storage	`Import-Csv -Path '.\\data.csv' \| ConvertTo-Json`

Main Points

Import CSV with Import-Csv and foreach for per-row work
Use -Delimiter and -Header to handle varied CSV formats
Choose ForEach-Object or foreach based on readability and performance
Export results with Export-Csv or ConvertTo-Json as needed
Plan for large files with streaming or chunking

← More in CSV Import & Export

Import CSV with PowerShell foreach: A Practical Guide

Import CSV with PowerShell: The Basics of import csv powershell foreach

Handling Delimiters and Headers in CSV Imports

Using foreach vs ForEach-Object: Performance and style

Building transformed objects and aggregations

Error handling and streaming considerations

Working with large CSVs: memory and performance tips

Practical example: filtering and exporting

Debugging and common pitfalls

Steps

Prepare the CSV and environment

Import the CSV

Process each row

Transform and summarize

Output results

Prerequisites

Commands

People Also Ask

Main Points

Related Articles

Import CSV with PowerShell: The Basics of import csv powershell foreach

Handling Delimiters and Headers in CSV Imports

Using foreach vs ForEach-Object: Performance and style

Building transformed objects and aggregations

Error handling and streaming considerations

Working with large CSVs: memory and performance tips

Practical example: filtering and exporting

Debugging and common pitfalls

Variations and related approaches

Steps

Prepare the CSV and environment

Import the CSV

Process each row

Transform and summarize

Output results

Prerequisites

Commands

People Also Ask

Main Points

Related Articles