Compare Excel Sheets - gHacks Tech News

Compare Excel Sheets

microsoft excelWhat 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.

compare excel sheets

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.





  • We need your help

    Advertising revenue is falling fast across the Internet, and independently-run sites like Ghacks are hit hardest by it. The advertising model in its current form is coming to an end, and we have to find other ways to continue operating this site.

    We are committed to keeping our content free and independent, which means no paywalls, no sponsored posts, no annoying ad formats (video ads) or subscription fees.

    If you like our content, and would like to help, please consider making a contribution:

    Comments

    1. jack said on September 19, 2009 at 5:10 pm
      Reply

      I use OfficeTab that makes tabs in Office much like tabs in IE or Firefox.. I can just switch between the tabs. I know this isn’t the same as this is making them directly compare on the same screen. I usually want to be able to switch tabs to copy/paste data and whatnot.

      Their website is in another language, but you can use the translated page.

      http://lmgtfy.com/?q=officetab

    2. Carlos said on February 22, 2010 at 4:12 am
      Reply

      OfficeTab is PAID!

      Microsoft should include this feature in its package.

    3. Marisa said on September 10, 2012 at 12:19 am
      Reply

      DiffEngineX works a lot better and is much faster.

      Download the free trial.

      http://www.florencesoft.com/excel-differences-download.html

    Leave a Reply