XL Compare software quickly compares Excel spreadsheets and generates simple, clear Excel reports highlighting the differences. Users can filter what they want to compare and save profiles for future use. There is also a command-line version for automated batch jobs.
One of the standout features of XLCompare is its ability to compare spreadsheets, including multiple spreadsheets contained in one or more folders. Upon completion of a comparison, the software generates an easy-to-understand report, complete with a summary page and detailed report for each workbook with links back to the source worksheet.
Further, XLCompare provides users with filters to customise comparisons based on folder name, spreadsheet name, worksheet name, named ranges or explicit ranges within one or more sheets. This capability is significantly enriched by the ability to use wildcards or regular expressions to specify filters.
In addition, XLCompare provides users with an option for synchronising comparisons where additional rows have been inserted in worksheets. Users may also store details of comparisons to be made in profiles for easy re-use, limiting the number of differences reported by worksheet, workbook or for the entire comparison.
Notably, the software also provides users with an option to cancel a comparison, system-wide or otherwise, whilst it is running. XLCompare enables users to export and import profiles and view the most recent report for a profile without re-running the comparison. Users may also use a template for the report.
While Excel is not required for comparison, XLCompare provides a command-line interface to run profiles via a batch file, allowing for scheduled comparisons. To conclude, XLCompare is the ideal software for quick, customised and flexible comparison of Excel spreadsheets.
Version 1.0: N/A