I’m not sure why I discounted this one, it may be just that Synkronizer did 95% of what I wanted. It also shows the differences directly in the spreadsheet. I just tried a simple summary spreadsheet and it showed all the columns in the results window not lined up, so it was basically impossible to use.ĮxcelDiff and 4 Tops re-create the spreadsheet into a HTML report with hyperlinks back to the spreadsheet – useful but it doesn’t help to show the context of where the differences are and not having the underlying spreadsheet’s formatting is not helpful.Įxcel compare is similar to above but presents the differences in Excel, but still lacks the ability to see your whole spreadsheet in i’s original context with the differences shown.ĭiffEngineX has a great feature that allows you to insert rows and / or columns to make the 2 spreadsheets layouts the same. I quickly discounted Diff Doc – it had a great slick website but it was a text based comparison tool that meant it converted the spreadsheet to text first before comparing. Diff Doc – It’s more of a text based comparison but it did say it compared Excel.Synkronizer – looks like it’s by a Swiss company.I needed to have the results either appear in the spreadsheet OR link to the spreadsheet as I needed to see the differences in context of the surrounding data.I just needed to be able to compare values, not formula as i had checked most of the formula’s previously and there seemed to be no major formula consistency issues.As my spreadsheets are HUGE (this one has over 30 sheets, but one I have has over 200 sheets in it), I needed one that would cope with big and cumbersome spreadsheets (don’t worry they will be FIXED on the next project).My review is going to be skewed toward my criteria as it was very specific. I downloaded and trialed 5 excel comparison tools this week and thought I’d share my thoughts on them – they seem to fit into 3 camps, text based, link based and excel based.
0 kommentar(er)
