Import-Csv
Reads a CSV file into one object per row.
Syntax
Short syntax for this command. The parameter table below may list more parameters than this short line shows.
Syntax
Import-Csv -Path <File> [-Delimiter <Char>]Parameters
Note: the short syntax above does not show every parameter in this table. The rows marked No in the last column are still listed here with their descriptions. Check Get-Help for the full syntax before you use one of them.
| Parameter | What it does | In short syntax |
|---|---|---|
-Path | the CSV file | Yes |
-Delimiter | the separator, comma by default | Yes |
-Header | headers to use if the file has none | No |
Examples
Reads users.csv into objects.
Example 1
Import-Csv -Path "C:\Temp\users.csv"Illustrative output: see the lesson example for this command.
Common mistakes
General cautions for this command.
- Guessing parameters instead of checking Get-Help for this command.
- Running a changing form of this command before previewing its effect.
Related commands
Commands that share this command's lesson come first, then commands that share its verb. Every link goes to a real command page.