Contact Info

Crumbtrail » Administration » Powershell » Powershell 1.0 » Export-Csv

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 to Comma Separated Values (spreadsheet)


-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.

       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).

       Overwrite without warning, this is the default.
       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.
       Describe what would happen if you executed the command without actually
       executing the command.
       Prompt for confirmation before executing the command.
        -Verbose, -Debug,-ErrorAction,-ErrorVariable, -OutVariable.

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