0

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

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 Jun 15 at 5:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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