Compare Excel Sheets

Martin Brinkmann
Sep 15, 2009
Software, Windows, Windows software
|
5

microsoft excel 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

Tutorials & Tips


Previous Post: «
Next Post: «

Comments

  1. 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

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

    OfficeTab is PAID!

    Microsoft should include this feature in its package.

  3. 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

Leave a Reply

Check the box to consent to your data being stored in line with the guidelines set out in our privacy policy

We love comments and welcome thoughtful and civilized discussion. Rudeness and personal attacks will not be tolerated. Please stay on-topic.
Please note that your comment may not appear immediately after you post it.