Powershell export csv

Using Powershell we can export the output of the script or the data that you need into Excel .CSV file, this article explains how to write the output of any script into CSV file and how to import CSV file data into the script and perform the defined action. The Excel comma-separated value (CSV) file is a simple text file, Powershell easily reads the data and puts in, for reading data from CSV file format we have a Cmdlet available in powershell is Import-CSV and for exporting the data or output of any script then there is another Cmdlet we use Export-CSV. Let’s discuss these two commands in a detailed way. This powershell command converts objects (from the pipeline output) into a series of comma-separated values,  Each object is represented as a line or row and you can store it in a defined location as .CSV file.  This files contains the property values of methods and their out data strings in columns and rows, let’s see it’s syntax. Powershell Export-CSV Syntax I have explained each parameter of export-csv powershell command and each property has its own functionality, let’s discuss how they work in real-time scripting environment. 1. -Delimiter char This a parameter and used with a delimiter to separate the property values, we will discuss more in our upcoming articles. -Encoding string This parameter used for encoding for the exported CSV file, only valid values are allowed, such as UTF7, UTF8, ASCII, UTF32, it’s the default value for encoding string is ASCII. -Force This is the most important property that we use all the time whenever we use Export-CSV command in scripts, It used for overwriting data into the file where it is specified like without prompting anything. -Path string This is a mandatory parameter that we need to mention the path to export CSV file,  basically, we need to mention where to export the CSV file. -NoTypeInformation If you used this parameter then it removes the type information from the CSV file, making out file more clear format. -confirm This parameter is a command for most of the Powershell commands, it prompts for confirmation before executing command or script, just make sure we are executing the what is intended. -InputObject psobject This parameter of Export-CSV is used for The objects to export as CSV strings, each object is represented as a line or row and you can store it in any defined location as .CSV file. -NoClobber This parameter used for not to overwrite (replace the contents) of an existing file, when you don’t define this then it performs the default action as overwrite any existing file without any warnings, make sure one has to use these properties to export the data as need. Examples Scripts:

Get-Process | Export-Csv -path C:\temp\Process.csv

This above one-line script gets all the process and their usage and writes into an Excel CSV file in C:\temp\Process.csv Let’s open the Process.CSV file Example 2 Let’s write a function to get C drive information total size, free space, and Export it as CSV file.

Function Get-Devicesize {

param($ComputerName)
# you need pass your remote machine name when you use this function
$drive = Get-WmiObject Win32_logicaldisk -Filter 'Deviceid = "c:"'
$properties = @{       
     ComputerName = $ComputerName
     FreeSpace = $drive.FreeSpace
     DeviceID = $drive.DeviceID
     Size = $drive.Size
     }  
      New-Object -TypeName PSobject -Property $properties
}

Let’s run this function and export!

Get-Devicesize -ComputerName DESKTOP-Win10 | Export-Csv -Path C:\temp\deviceinfo.csv -Force -NoTypeInformation -Append

Output:

While running the function we used -NoTypeInformation parameter, this omits writing the object type information on top of the Excel CSV file. Generally, we don’t use this object type information of any output (Powershell commands). Let’s Learn How to Import or Read data from CSV file to Powershell Script There are two commands available in powershell to import the data into scripts, one is Import-Csv and another one is Get-Content, both work technically same, however, the command Import-Csv reads the data structured Csv file format,  but not a simple text file. Syntax:

Example:

Import-Csv -Path C:\temp\deviceinfo.csv

If you observe closely, we are importing the Excel CSV file that we were exported in our example of the above Powershell function. OutPut: FreeSpace         Size            ComputerName         DeviceID ——— —- ———— ————————————- 51386757120 106820530176 DESKTOP-Win10    C: Thank you for reading this article, if you have any questions please let us know. Thank you for visiting my site, for any scripts in these articles you are testing please make sure you have tested this script in our lower environment before you run in production.

Top 5 Notepad++ Tricks that you should know in 2021

Best Minecraft mods in 2021

Windows Minecraft

Pokemon Sword and Shield: Post Game 2021

5 Best Free Youtube Video to MP3 Converters in 2021

Best beat making softwares List

DaVinci Resolve Plugins you Should have in 2021