Freeware compare two excel spreadsheets

Set Primary Keys on the columns and rows in your worksheet and get the accurate comparison results. Merge any of the changes found in one excel file into the corresponding one. Compare two excel files by viewing them side by side. Use Case Examples. Detailed Features List. Best Excel Compare Tool. Find and Remove Duplicates. We offer data-specific algoritms, designed for the various types of Excel files.

English German Chinese Russian. Merge Several Excel Files into One. Drop files you are going to merge into xlCompare. To start merging you files with excel diff tool , you need to open your files first. This is very simple step. Excel File Compare has a number of commands to open Excel files. We recommend to drop your files into the xlCompare application. This way is the most fast and simple. Usually this command merge excel files into one is applied to excel files with database structure.

Like price lists, invoices, various tables stored in the Excel Files. For this type of data Primary Key is a basis.

Accurate comparison results are not possible without defined key columns and key rows on the worksheet. Excel File Compare Tool xlCompare works flexible with primary keys and accepts complex key that consists of several columns and contains duplicated values. After files are opened and primary keys are defined, excel diff tool has all needed information to consolidated excel files into one.

Simplicity is one of the principles of the our excel diff tool xlCompare. We would like to give you powerful and best excel file compare tool , but it should be as easy to use as possible.

The most actions you can do in Excel File Compare are done in a few clicks only. Consolidate All Worksheets into one in the Excel File.

Open your excel file in the Excel File Compare Tool. We've described how to open excel file in xlCompare tool in the section above. So, just drop your excel file into the xl comparator xlCompare window. Normally this step is optional. In most cases you need to look into them only. However, if you have a complex data, or ID column is missed and primary key consists of the several columns - you may need to edit them using the Right Click Menu. Merge command on the Home tab on Ribbon opens Merge Excel Worksheets Wizard, if you have only one workbook opened in the excel file compare.

The Wizard has minimum fields to be filled. Just select worksheet that receives consolidated data and check the worksheets whose contents should be merged. That's all. All other work is done by excel diff tool xlCompare. Complete the Wizard to get the results. As you see in a few clicks you are getting the consolidated worksheet. If you receive invoices, part lists, price lists or other tables splitted into smaller parts - xlCompare is a best excel file compare tool to automate your work and increase your productivity.

Why Use xlCompare? Fast and Efficient. Compare Excel worksheets within seconds and maximum accuracy. Get an accurate and easy to understand comparison report. Easy to Use. This Excel diff tool is extremely easy to use. We've made it as simple as possible. You won't need to spend your time on learning this product. Just install it and use it! Clear Results. This is the perfect visual representation of the comparison results. The Benefits of xlCompare. Compare Excel Files.

Compare your version of Excel file with version of your co-worker and merge changes. Comparison Report. Detect cell and structural differences. Show differences in the form of Color Coded Report. Merge Excel Workbooks. Combine Excel Worksheets. Combine several excel worksheets into one in single click. Join and intersect Excel Tables.

Excel Diff Viewer. Export Report. Changed Values. If you've changed cells value, or it was changed after recalculation - it will be highlighted by xlCompare. All cell formatting options are compared. Find Inserted Rows and Columns. Virtualy Aligned Rows. Added and Deleted Rows Columns are virtually inserted into another workbook to make native representation of the comparison results. Every pair of the corresponding rows are on the same places.

With aligned rows you see where merged unique rows will be inserted. Select range of the rows you want to insert and move them in one click on the plus icon. Combine Several Excel Sheets into One. Merge Cells. Select range of cells you want to merge and use Merge command.

All values in the corresponding sheet will be updated in one click. Merge Unique Rows. Select rows or columns you would like to merge and press PLUS icon to add them to other worksheet. You get only records you need! One Click Merge. Merge button combines spreadsheets in a without selecting differences one by one.

One mouse click and few seconds - your worksheets are combined into one. Display Formatted Difference Report. Display Difference. Display Difference option gives you ability to see updated value and difference. Focus on Changes. Sometimes updated value is not so important as difference between values. You get exactly what you need. Unique Feature. This feature is possible only in the xlCompare.

Note: If you get an "Unable to open workbook" message, this might mean a workbook is password protected. Click OK and then enter the password. Learn more about how passwords and Spreadsheet Compare work together. The results of the comparison appear in a two-pane grid. The workbook on the left corresponds to the "Compare" file you chose and the workbook on the right corresponds to the "To" file. Details appear in a pane below the two grids.

Changes are highlighted by color, depending on the kind of change. In the side-by-side grid, a worksheet for each file is compared to the worksheet in the other file, beginning with the leftmost worksheet in each. If a worksheet is hidden in a workbook, it's still shown and compared in Spreadsheet Compare.

If the cells are too narrow to show the cell contents, click Resize Cells to Fit. Differences are highlighted with a cell fill color or text font color, depending on the type of difference.

For example, cells with "entered values" non-formula cells are formatted with a green fill color in the side-by-side grid, and with a green font in the pane results list. The lower-left pane is a legend that shows what the colors mean. If you want to save your results or analyze them elsewhere, you can export them to an Excel file or copy and paste them into in another program, such as Microsoft Word.

There's also an option for getting a high-fidelity look at each worksheet that shows the cell formatting, close to what you'd see it in Excel. You can export the results to an easier to read Excel file. Say your organization is due to be audited. Suppose you have the dataset as shown below in a sheet called Jan and similar data in a sheet called Feb , and you want to know what values are different.

Copy and paste this formula for a range so that it covers the entire dataset in both the sheets. Since I have a small dataset, I will only copy and paste this formula in A1:B10 range. The above formula uses an IF condition to check for differences. In case there is no difference in the values, it will return blank, and in case there is a difference, it will return the values from both the sheets in separate lines in the same cell.

The good thing with this method is that it only gives you the differences and show you exactly what the difference is. In this example, I can easily see that the price in cell B4 and B8 are different as well as the exact values in these cells. Suppose you have two sheets Jan and Feb and you want to compare and highlight differences in the Jan sheet, you can use the below VBA code:.

The above code uses the For Next loop to go through each cell in the Jan sheet the entire used range and compares it with the corresponding cell in the Feb sheet. In case it finds a difference which is checked using the If-Then statement , it highlights those cells in yellow.

In those ways, you will be able to do this comparison with a click of a button. Here are the steps to save this code in the Personal Macro Workbook. And here you will find the steps to add this macro code to the QAT. Another quick way to compare two Excel files and check for matches and differences is by using a free third-party tool such as XL Comparator. This is a web-based tool where you can upload two Excel files and it will create a comparison file that will have the data that is common or different data based on what option you selected.

Suppose you have two files that have customer datasets such as name and email address , and you want to quickly check what customers are there is file 1 and not in file 2. One concern you may have when using a third-party tool to compare Excel files is about privacy. Note that the XL Comparator website mentions that they delete all the files after 1 hour of doing the comparison.

These are some of the methods you can use to compare two different Excel files or worksheets in the same Excel file. Hope you found this Excel tutorial useful. Thanks for this, very helpful. However, with 50 rows and 20 columns to compare, the e.

JanValueFebValue16 is fine other than I then have to go back manually to the Feb sheet to see which product was in cell R45 that has changed values. This macro is just what i have been looking for, thank you.