Contact Info

Crumbtrail » Administration » Powershell » Powershell 3.0 » Export-Csv

Export-Csv - Powershell 3.0 CmdLet

ActiveXperts Network Monitor ships with integrated Powershell scripts to monitor complex network. The scripts run out of the box
Download the ActiveXperts Network Monitor FREE version now »


Short description
Converts objects into a series of comma-separated (CSV) strings and saves the strings in a CSV file.

Export-Csv [[-Path] <String>] [[-Delimiter] <Char>] [-Append] [-Encoding <String>] [-Force] [-LiteralPath <String>] [-N
oClobber] [-NoTypeInformation] -InputObject <PSObject> [-Confirm] [-WhatIf] [<CommonParameters>]
Export-Csv [[-Path] <String>] [-Append] [-Encoding <String>] [-Force] [-LiteralPath <String>] [-NoClobber] [-NoTypeInfo
rmation] [-UseCulture] -InputObject <PSObject> [-Confirm] [-WhatIf] [<CommonParameters>]

The Export-CSV cmdlet creates a CSV file of the objects that you submit. Each object is represented as a line or row of
 the CSV. The row consists of a comma-separated list of the values of object properties. You can use this cmdlet to cre
ate spreadsheets and share data with programs that take CSV files as input.

NOTE: Do not format objects before sending them to the Export-CSV cmdlet. If you do, the format properties are represen
ted in the CSV file, instead of the properties of the original objects. To export only selected properties of an object
, use the Select-Object cmdlet.