Merge CSV files by using PowerShell

 

Compare two CSV files via PowerShell to find out difference and export results into new CSV file.

If you are looking for simple script can read two CSV file, which each CSV file has multiple columns, then compare them to find out the difference this script is just going to do that. Simply download and adjust few variables to make it work for your scenario.

I have added both CSV file content into script for you to see what script is pulling then variables you can change to make it fit into your needs.

Adjust your CSV file, if your columns are different, you have more columns etc. that is fine, just adjust them accordingly.

“Computername, and UserName “ are column name on the example below, thus script reflect both variables, and also PS custom object, just adjust them.

 

<#   #$File1   ComputerName UserName ------------ -------- XLT-001      Allison1 XLT-002      Allison2 XLT-003      Allison3 XLT-004      Allison4 XLT-005      Allison5 XLT-006      Allison6 XLT-007      Allison7 XLT-008      Allison8 XLT-009      Allison9 XLT-010      Allison10 WRK-010      Clint   #$File2 ComputerName UserName ------------ -------- XLT-001      Allison1 XLT-002      Allison2 XLT-003      Allison3 XLT-004      Allison4 XLT-005      Allison5 XLT-006      Allison6 XLT-007      Allison7 WRK-001      RAMBO    XLT-008      Allison8 XLT-009      Allison9 XLT-010      Allison10     #>       #(1)_.Path for CSV Files that needs to be comppared $CSV1 = "C:\Users\12024\OneDrive - wiretecpro\Desktop\Compare-CSV\Excell\File1.csv" $CSV2 = "C:\Users\12024\OneDrive - wiretecpro\Desktop\Compare-CSV\Excell\File2.csv"       #(2)_.Path for export results to CSV $CSV3 = "C:\Users\12024\OneDrive - wiretecpro\Desktop\Compare-CSV\Excell\DIFFERENCE.csv"       #(3)_.Import both CSV Files you would like to compare $File1 = Import-Csv $CSV1 $File2 = Import-Csv $CSV2     #(4)_.Compare both CSV files - column ComputerName,UserName   $Results = Compare-Object  $File1 $File2 -Property ComputerName,UserName -IncludeEqual    #(5)_.Set Array $Array = @()   #(6)_.Loop Starts      Foreach($item in $Results) {     If( $item.sideindicator -notcontains "==" )     {         $Object = [pscustomobject][ordered] @{             ComputerName      = $item.ComputerName             UserName          = $item.UserName             Compare_Indicator = $item.sideindicator           }         $Array += $Object     } }   #(7)_.Count users in both files ($Array | sort-object ComputerName | Select-Object * -Unique).count   #(8)_.Display results in console $Array   #(9)_.Export results into CSV File $Array | export-csv -Path $CSV3 -NoTypeInformation

 

Casey, Dedeal

Principal Systems Engineer

https://simplepowershell.blogspot.com/  (blog)

https://smtp25.blogspot.com/ (blog)

https://telnet25.wordpress.com/ (blog)

https://twitter.com/Message_Talk (Twitter)