Import-Csv

Verb: ImportChapter 15: CSV: import and export

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.

ParameterWhat it doesIn short syntax
-Paththe CSV fileYes
-Delimiterthe separator, comma by defaultYes
-Headerheaders to use if the file has noneNo

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.

Related lessons