Export-Csv - Powershell 1.0 CmdLet
Microsoft Windows PowerShell is a command-line shell and scripting tool based on the Microsoft .NET Framework. It is designed for system administrators, engineers and developers to control and automate the administration of Windows and applications.
More than hundred command-line tools (so called "cmdlets") can be used to perform system administration tasks and Windows Management Instrumentation (WMI). These cmdlets are easy to use, with standard naming conventions and common parameters, and standard tools for piping, sorting, filtering, and formatting data and objects.
Export-Csv
Description Export to Comma Separated Values (spreadsheet) Usage Options -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. Example(s) 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