Export-Csv
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> -NoTypeInformationParameters
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 | where to write | Yes |
-NoTypeInformation | leave out the type header line | Yes |
-Delimiter | the separator to use | No |
Examples
Writes three process rows to CSV.
Example 1
Get-Process | Select-Object Name -First 3 | Export-Csv -Path "C:\Temp\procs.csv" -NoTypeInformationIllustrative 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.