Track differences and compare Microsoft Excel files and spreadsheets with Excel Compare.
Did you ever have an Excel spreadsheet that was edited and updated by several people? Was it a headache to figure out the differences between the files, and insert just the most recent entries into the final spreadsheet? Excel Compare saves your time by eliminating the routine operations, and improves the final result by telling you exactly what and where has been changed. No more missed changes or forgotten updates thanks to clear highlight of every little difference between the sheets of data!

Test Results

Installing the Excel Compare download: Formula Software, Inc provides their software as a Windows Executable file and therefore installation is as easy as downloading the file ExcelCompare-3.8.exe and running it directly after retrieving it. Excel compare tool. Excel compare tool. Download Latest Version CompareExcel-v07.zip (42.1 MB) Get Updates. Get project updates, sponsored content from our select partners, and more.

Excel Compare supports all versions of Microsoft Excel, and conveniently creates a difference report as a new Excel sheet. It supports comparing the sheets that contain database structures, and correctly processes data that does not have unique identifiers. Excel Compare treats inserted rows and columns in a correct manner, reporting that a row or column has been added or removed, without creating the visual clutter of multiple raw-to-raw or column-to-column changes. Updated cells will be highlighted, allowing you to synchronize changes between the two sheets of data.
Are you looking for a specific change in a spreadsheet? You can easily add macros to your report workbook that will highlight just the changes you need.
If you have multiple excel spreadsheets to compare, Excel Compare will take the two folders and process all Excel files, creating single difference report for all spreadsheets. For a more complex task, such as a comparison of multiple folders, Excel Compare can be run in batch mode from a command line, taking command line parameters.

Size: 3.4 MB | Download Counter: 170
If Excel Compare download does not start please click this: Download Link 1 | Download Link 2
Can't download? Please inform us.

Released: July 23, 2011 | Added: July 24, 2011 | Viewed: 4546

Test Details

There are many different ways that you might want to use a table to compare the features or specifications for different products. You might be comparing different versions of your own products (free, student, business, enterprise), or doing a competitive analysis comparing products created by different companies.

One set of features might use simple check marks to indicate whether a product supports the feature. For another set of features, you may want to indicate numeric or text-based specifications likes sizes, quantities, operating system, screen size, etc. For a competitive analysis, you may want to rate the quality of a feature using a star rating or numeric ranking.

⤓ DownloadLicense: Private Use

Cached

(not for distribution or resale)

'No installation, no macros - just a simple spreadsheet' - by Jon Wittwer

Description

I designed this feature comparison template to demonstrate many different ways of showing different types of ratings, specifications, and check marks using a table in Excel. The techniques mostly involve the use of data-validation drop down lists in Excel, special characters for stars and check marks, and various conditional formatting techniques like icon sets and data bars.

To use the table, you can delete all the rows that you don't need and then insert more rows and copy/paste rows that you want to use.

Feature Lists with Check Marks using Unicode Symbols

If your computer can display the Unicode check mark symbol (✓ or ✔), then using that symbol is a very simple way to create a feature list for different products. See my article Unicode Character Symbols in Excel or this page on wikipedia.com for a list of various Unicode symbols you may be able to copy/paste into Excel. Here are some of the symbols I find useful:

✓, ✔, 🗶, ✗, ✘, ✪, ★, ☐, ☑, ☒, ⚐, ⚑, ◆, ⬧

5-Star Rating System ★★★★★

A simple 1-5 star rating system is extremely easy to create with a drop-down list. You can change the color of the stars by changing the font color. Copy the character or symbol and go to Data > Data Validation and choose List. In the Source box, create the following comma-delimited list:

★,★★,★★★,★★★★,★★★★★

The diamond ◆ example in the template shows that you can use other symbols besides stars if you want to.

Benefit of Using Icon Sets

Many of the techniques demonstrated in this template use custom conditional formatting icon sets. One of the reasons I like using icon sets is that they can be based on numeric values. So, if you were doing a competitive analysis and had a fancy formula for combining the rankings for a group of features to come up with an overall score, you could use numeric rankings for the features. The icons would be displayed, but the numeric values that the symbols are based on can be used in formulas.

Excel File Comparison Tools Overview

Related Content