Export-Csv

Verb: ExportChapter 15: CSV: import and export

Writes objects to a CSV file.

Syntax

Short syntax for this command. The parameter table below may list more parameters than this short line shows.

Syntax
Export-Csv -Path <File> -NoTypeInformation

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
-Pathwhere to writeYes
-NoTypeInformationleave out the type header lineYes
-Delimiterthe separator to useNo

Examples

Writes three process rows to CSV.

Example 1
Get-Process | Select-Object Name -First 3 | Export-Csv -Path "C:\Temp\procs.csv" -NoTypeInformation

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