Best Free Add-ins for Comparing 2 Excel Files?

[PP3321]

Hi thank you always for helping me on this forum.

I have a table, which contains about 100 rows & 20 columns.
This table gets updated every month.

I need to compare the latest version with the old version,
in order to see what was updated.

**********************************************************************
I googled and found these 4 add-ins...
http://www.ilovefreesoftware.com/30/featured/4-free-add-ins-to-compare-excel-files.html

If any one used these, what would you recommend...?

**********************************************************************
I looked into VBA option, but I think it is easier to go with free-addins.
http://forum.chandoo.org/threads/need-to-compare-two-excel-files.29513/

Thanking you in advance...

 

[Chihiro]

If you have access to PowerQuery, Left/Right Anti join of two query can achieve what you are looking for. From my experience, it's by far the most stable and efficient method.

If you don't have access to PowerQuery, you can still use MS Query by using Subtract join method.
https://support.microsoft.com/en-ca/kb/136699

 

[PP3321]

@Chihiro
Thank you so much!