Comparing Excel worksheets: recommended tools for comparing exported Jama data

By swoo posted 05-27-2016 04: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. https://support.office.com/en-us/arti...

#OfficeTemplates
6 comments
427 views

Comments

01-11-2019 02: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: https://www.synkronizer.com/compare-excel-tables-features/compare

05-27-2016 18: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 17: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 https://www.florencesoft.com/ 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:

DiffEngineX
 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 https://www.florencesoft.com/excel-differences-download.html to download the free 30 day trial of the compare Excel worksheets tool.

05-27-2016 17:14

Shawnna,

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.

swoo

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).

https://www.florencesoft.com/


05-27-2016 16: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?
Shawnna

05-27-2016 12: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...

Cheers,
Bob