Compare two Excel workbooks cell by cell
With a schedule of rents, a purchase price calculation or a list of shareholdings, looking at the text is not enough. CompareDesk compares workbooks cell by cell, on the basis of the stored values and formulas.
25 comparisons free, no sign-up.
Compare Excel workbooks
Transcript
Select “Two files” and load two Excel workbooks. Put the original version on the left and the newer version on the right. Check the spreadsheet options. CompareDesk considers stored cell values and formulas, among other things. You can adjust row matching if needed. Choose an Excel workbook with highlighted changes or a comparison PDF. Check the destination folder and start the comparison. Open the result. Read changes alongside their sheet, row and column. Look out for inserted or removed rows as well. Review the affected values and formulas in context, then save your checked working version.
What the comparison captures
It captures changed values, changed formulas, changed number formats and changed formatting as well as inserted or deleted rows, columns and sheets. Every finding states sheet, cell and column heading, so that it can be checked without searching. Two cells with the same value in different notation do not count as a change.
Inserted and deleted rows and columns are recognised as such, so that the remaining cells do not appear as changed merely because they have shifted.
Formulas with old and new expression
Changed formulas are marked separately and shown with the old and the new expression. A workbook that was not recalculated before saving contains formula cells without a result value; CompareDesk points this out rather than pass over it in silence.
A result to check and to pass on
You receive a result workbook in which changed cells are highlighted in colour and the earlier value stands as a cell comment, together with a sheet giving the particulars of the check, the SHA-256 checksums of both files and a summary of all differences. On request a comparison PDF is produced in addition for passing on.
Rounding, excluded ranges and a key column can be set; without any setting the cell-exact comparison applies.
Formats and confidentiality
Workbooks in the formats XLSX, XLSM, XLS, ODS and CSV are compared, also against one another. The comparison suits shareholder registers, purchase price lists, distribution plans, rent schedules and budgets. It runs solely on your own computer, on Windows as on macOS, with no upload and no cloud.
In three steps
- Drop both workbooks into the fields.
- Optionally set rounding, excluded ranges and a key column; without any input the cell-exact comparison applies.
- Compare. The result is a workbook in which the changed cells and the new and removed rows are marked.
What you get
The marking of changed values and of new and removed rows and columns, together with the number of differences and the degree of agreement.
Both the stored values and the formulas are compared. A workbook that was not recalculated before saving contains formula cells without a result value; CompareDesk points that out instead of passing over it in silence.
On request the result is also produced as a comparison PDF.
What the comparison does not do
Charts, pivot analyses and macros are not compared as to their content. The comparison covers the cells, their values and formulas, and the structure of the sheets.
Frequently asked questions
Can I compare a CSV file with an Excel file?
Yes. The formats may differ; CSV, ODS, XLS, XLSX and XLSM can be compared with one another.
Are formulas compared as well?
Yes. Changed formulas are marked separately and shown with the old and the new expression.
What happens with inserted rows?
Inserted and deleted rows and columns are recognised as such, so that the remaining cells do not appear as changed merely because they have shifted.
Are charts and macros compared?
No. Charts, pivot reports and macros are not compared for content. The comparison concerns the cells, their values and formulas and the structure of the sheets.
Are the workbooks uploaded?
No. The comparison runs solely on your own computer.
Try it on your own schedules
CompareDesk processes the workbooks solely on your own computer. Twenty-five full comparisons are available without signing up.
Download for free To the user guide
Also possible: Compare spreadsheets Compare documents Compare folders (batch comparison) Comparison certificate and checksums Glossary of document comparison