Comparing Excel worksheets: recommended tools for comparing exported Jama data

By swoo posted 05-27-2016 01:56

No, I did not lose my mind. The following is an Excel tip, but you may find it useful. Though Jama is a very useful and usable tool, at times we export data to Excel. Perhaps you exported data last week and you want to export the data again and want to see the changes. Yesterday I was just introduced to an Excel 2013 COM add-in called Inquire that you can enable to compare two work sheets. Read more here.



01-10-2019 23:20

Thanks for the Suggestion. But I Think Synkronizer Excel Compare Tool is the Best Excel Add-in for Comparing and Merge Multiple Excel Files. Also Provides 30 Day Trail so That you can Check All Features of this tool:

05-27-2016 15:09

Thanks for the two suggestions, Swoo! I made your Idea an Article because I think it's not quite an Idea, but more of a handy tip. (If only we had a posting type for those!)

05-27-2016 14:20

Hi All, I need to amend my tip. I don't work for florencesoft or don't get any money from that company. For those people who needs an outside-of-Jama capability to compare Excel worksheet, I highly recommend DiffengineX. I did not recommend it last night because I had thought that it was out of business in the last couple of years. 

from their website:

 is a fast and scalable compare software utility that finds the differences between the formulae, constants, defined names, cell comments and Visual Basic VBA code contained in either two whole Excel workbooks or selected worksheets on Windows. It can align similar rows and columns across two different Excel spreadsheets. It works with xls, xlsx, xlsm and xlsb files. xla and xlam add-ins need to be converted first into xls and xlsm files before DiffEngineX can compare them. Excel 2003 - 2016 is required for this spreadsheet comparison tool to work.
Download DiffEngineX Software to download the free 30 day trial of the compare Excel worksheets tool.

05-27-2016 14:14


As far as I can tell, Excel 2013 Inquire colorcodes the whole cell and does not highlight the detailed changes. Perhaps in 2016? :-)

I could be wrong. I just learned about this function two days ago.

Have a good day.


p.s. By the way, I use to use DiffengineX, which was a shareware program. It was out of business for a while. I just checked. It's back in business. You can download the free trial version. This does a very comprehensive job of comparing and highlighting (including changes within a cell).

05-27-2016 13:49

Swoo - If you have a bunch of text in the field, and you only have one piece of that field changed, does it highlight that change, or does it just highlight the field and you have to figure out what changed?

05-27-2016 09:13

That's a good one swoo!  It always struck me as a missing function when it's been in Word for a long time.  I don't have '13 sadly.   I've been working around it with various hacks to focus on differences but they require some effort.  This could be enough to just '13 if you do enough of it...