PowerShell - Compare 2 csv files and output differences to 3rd csv
- Jon Boyette
- Apr 15, 2022
- 1 min read
Save as a named .ps1, this prompts for the 1st and 2nd csv to compare, and outputs the path you put in 3 times, 3rd being the differences between the 2 into a csv place of choice
$F1 = Read-Host "Enter Path of First csv file to Import and compare"
$F2 = Read-Host "Enter Path of Second csv file to Import and compare"
$Out = Read-Host "Enter Path to Export Results"
$file1 = Import-Csv $F1
$file2 = Import-Csv $F2
Compare-Object $file1 $file2 -property Name, Status | Export-Csv $Out -NoTypeInformation
Comments