Contact Info

Crumbtrail » Administration » Powershell » Powershell 2.0 » Export-CSV

Export-CSV - Powershell 2.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.


Short description
Converts Microsoft .NET Framework objects into a series of comma-separated value (CSV) variable-length strings and 
    saves the strings in a CSV file.

Export-CSV [[-Delimiter] <char>] [-Path] <string> -InputObject <psobject> [-Encoding <string>] [-Force] [-NoClobber
    ] [-NoTypeInformation] [-Confirm] [-WhatIf] [<CommonParameters>]
    Export-CSV [-UseCulture] [-Path] <string> -InputObject <psobject> [-Encoding <string>] [-Force] [-NoClobber] [-NoTy
    peInformation] [-Confirm] [-WhatIf] [<CommonParameters>]

The Export-CSV cmdlet creates a CSV variable-length file that represents the objects that you submit. 
    You can then use the Import-CSV cmdlet to re-create objects from the CSV strings in the files. The resulting object
    s are CSV versions of the original objects that consist of string representations of the property values and no met
    You can also use the ConvertTo-CSV and ConvertFrom-CSV cmdlets to convert .NET Framework objects to CSV strings (an
    d back). Export-CSV is the same as ConvertTo-CSV, except that it saves the CSV strings in a file.
    You can use the parameters of the Export-CSV cmdlet to specify a delimiter other than a comma or to direct Export-C
    SV to use the default delimiter for the current culture. 
    When you submit multiple objects to Export-CSV, Export-CSV organizes the file based on the properties of the first 
    object that you submit. If the remaining objects do not have one of the specified properties, the property value of
     that object is null, as represented by two consecutive commas. If the remaining objects have additional properties
    , those property values are not included in the file.
    For more information, see Export-CSV, and see the Notes section.