Export a powershell object to a comma-separated values (CSV) file.
Syntax
Export-Csv [-path] string -inputObject psobject [Options]
Key:
-Path path
The path to the CSV to create
-inputObject psobject
Accepts objects that the cmdlet will represents as a CSV file. Enter a
variable that contains the objects or type a command or expression that
gets the objects.
-noTypeInformation
Omits the #TYPE header from the CSV file.
By default the first line of the CSV file will contain the
string "#TYPE " followed by the object type (fully qualified).
-force
Overwrite without warning, this is the default.
-noClobber
Do not overwrite the contents of an existing file.
The default is to overwrite without warning.
-encoding string
The type of encoding for the target file. Valid values are:
ASCII, UTF7, UTF8, Unicode.
-whatIf
Describe what would happen if you executed the command without actually
executing the command.
-confirm
Prompt for confirmation before executing the command.
CommonParameters:
-Verbose, -Debug,-ErrorAction,-ErrorVariable, -OutVariable.
Examples
Save details of the spooler process to a CSV file:
PS C:>get-process spoolsv | select-object ID,Path,sessionid | export-csv -path c:\spoolerdata.csv
"Try not to become a man of success but rather to become a man of value" - Albert Einstein
Related Powershell Commands:
import-csv - Take values from a CSV list and send objects down the pipeline.
export-clixml - Produce a clixml representation of powershell objects
import-clixml - Import a clixml file and rebuild the PS object
convertTo-Html - Convert the input into an HTML table
