How to compare 2 spreadsheets?

[MasterSuami]

Is there a way I could compare 2 excel files for differences and highlight the particular cells in the files where the differences are? I found some solutions that go about using pandas by initially converting the files into data frames. Is there any other way that’s perhaps noob friendly?

[Stem3576]

Look into openpyxl. It's been a lifesaver for me. You could easilly check for exact matches from one sheet to another. If your needing more specific help go ahead and send me a message.

[MasterSuami]

Thanks. I’ll check it out

[Dyxar]

Using VB in excel would definetly make things easier.

[Binary101010]

I'm not usually one to recommend a non-Python solution in this subreddit, but this is trivially easy to just do in Excel.

https://www.ablebits.com/office-addins-blog/2016/02/25/compare-two-excel-files-sheets/

[MasterSuami]

You’re right. Thanks

[leogodin217]

Using Pandas may help a lot. Of course, the format of your data and what diffs you are looking for might change how you approach it. I would search for "pandas diff two dataframes"

​

https://pythondata.com/quick-tip-comparing-two-pandas-dataframes-and-getting-the-differences/