Compare two Excel sheet having AD Users This topic contains 2 replies, has 3 voices, and was last updated by random commandline 1 year, 2 months ago. Author Posts February 16, 2016 at 4:16 am #35298 Anonymous i want to compare two CSV files both having AD Users. e.g csv1 contains all users about 3000 csv2 contains about 600 i want a csv3 that contains CSV1 – CSV2 February 16, 2016 at 6:06 am #35303 Wilfredo PerezParticipant use compare-object cmdlet. If you need help or examples use help compare-object -examples, or -full. Remember to get the content of the CSV files. February 16, 2016 at 6:15 am #35304 random commandlineParticipant # Export results excluding entries contained in both csv files $ref = Import-Csv .\adusers1.csv $dif = Import-Csv .\adusers2.csv Compare-Object -ReferenceObject $ref -DifferenceObject $dif | select -ExpandProperty inputobject | export-csv .\adusers3.csv -NoTypeInformation Author Posts You must be logged in to reply to this topic.