csv spreadsheets with the following data:

Sheet 1:

ID Name Address City PostalCode Phone

Sheet 2: ID Name Address City PostalCode Phone

I would like to compare the two sheets for added rows, deleted rows, changes in a column based on ID

Do you have any recommendation on how to achieve this in excel or use a third party software?

1 Answer 1


My usual approach is to sort by id and copy paste it into open source tool WinMerge (Windows) or Meld (Linux)

  • Would you mind adding links, and ideally a screenshot showing the comparison? Thanks!
    – Nicolas Raoul
    Commented Jun 15, 2019 at 5:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.