Excel Compare

Excel Compare is a tool developed by Formula Software, Inc. that automates the process of comparing Excel files, spreadsheets, and selected ranges of sheets. According to the vendor, it is specifically designed to help users identify differences between datasets and generate publication-quality reports highlighting added, deleted, and changed data. Excel Compare is aimed at small to large-sized companies and is used by business analysts, data analysts, financial professionals, project managers, and quality assurance teams across various industries.

Key Features

Compatibility with all Excel versions: According to the vendor, Excel Compare supports all versions of Microsoft Excel, ensuring compatibility across different Excel file formats.

Comparison of database structures: The vendor claims that Excel Compare allows for comparing sheets that contain a database structure, making it suitable for analyzing structured data.

Advanced comparison algorithm: The vendor states that Excel Compare utilizes an advanced comparison algorithm, which can accurately identify differences even in data that does not contain unique identifiers.

Selective range comparison: According to the vendor, users can compare any selected ranges within a sheet, providing flexibility in analyzing specific data subsets.

Comparison of multiple files: Excel Compare streamlines the process of comparing multiple files by supporting the comparison of all files located in two different directories, as claimed by the vendor.

Comparison of sheets with the same names: The vendor claims that Excel Compare enables the convenient comparison of sheets with the same names in two workbooks, making it easy to compare data across different versions or scenarios.

Publication-quality Difference Report: Excel Compare generates a Difference Report as a new Excel sheet, presenting the compared data in a publication-quality format, according to the vendor.

Retains original data format: According to the vendor, Excel Compare retains the format of the compared data in the Difference Report, ensuring visual consistency with the original files.

Highlighting of changed cells: The vendor states that Excel Compare highlights the cells that have changed, making it easy to identify and focus on the differences.

Clear breakdown of differences: According to the vendor, the Difference Report can be divided into three parts: deleted, added, and changed data, providing a clear breakdown of the differences.