What do most Excel users do when they want to compare two sheets of the same document? They usually either navigate back and forth in one Excel window or open a second one and align both Excel windows next to each other to speed up the sheet comparison. Both methods are prone for errors and a software driven way of comparing Excel sheets is usually the way to go to ensure an error free comparison.
Most software programs that compare Excel sheets are commercial or shareware. Compare Sheets on the other hand is a free portable solution for comparing Microsoft Excel sheets. The only real limitation of the program is that it only supports standard xls documents and not the newer xlsx document format. A solution would be to convert the Excel document into xls format if it happens to be in a different format.
The software program is pretty easy to use. Users can load one Excel document into it. The software will automatically display the first two sheets of the document in the two key areas. It is now possible to manually selected different sheets from the document and pick a column for comparison. The program will automatically update the display with the contents of the selected sheets. These columns are called reference fields in the software and can be selected for both sheets individually.
Three comparison criteria can be selected: Lines that match, lines that do not match and absolute difference. The comparison can either be added as a sheet in the existing Excel document or in a new document that will be created by the software program.
Compare Sheets is available at the developer's website. Just scroll down to the bottom of the screen for download links. The program is compatible with most Windows operating systems including Windows XP, Windows Vista and Windows 7.Advertisement
Ghacks is a technology news blog that was founded in 2005 by Martin Brinkmann. It has since then become one of the most popular tech news sites on the Internet with five authors and regular contributions from freelance writers.