Pick two .xlsx files and get a diff in one list: changed cells, added rows, removed rows and column changes. Select a row to see it side by side, old and new. Works offline.
Get Sheet Compare on the Microsoft Store 日本語のページ
Windows only. Your files are only read and nothing goes over the network.
Changed cells, added rows, removed rows and added or removed columns are listed with the sheet, the cell, the value before and after, and the kind. Six tiles at the top give the counts first: same rows, changed rows, only in new, only in old, differing cells, columns added or removed.
Row order lines rows up by content even when rows were inserted or deleted. Key columns lets you pick up to three columns, such as an employee or order number, and compares rows with the same key. If a sheet lacks the key column, the Notes box says it was compared by row order instead. It also flags codes that lost their leading zeros.
The heading row is picked automatically and can be set per sheet and per side, rows 1 to 30 or none. When the pick may be a title line, Notes in the result names the row.
Export the result to .xlsx writes one file: a summary, a differences list with a filter and a frozen header, and a side-by-side sheet for each compared sheet (changed is yellow, only in new green, only in old red). Dates are written as real date cells. Then open the file or its folder from the app. Japanese and English, light and dark.
No. Sheet Compare reads .xlsx files itself, so no other app is needed.
No. Row order lines rows up by content, so one inserted row does not turn the rows below it into differences. Key columns compares rows that share a key such as an employee or order number, even when the order differs. Columns with the same heading match even if they moved.
The heading row is picked automatically at first. A title line as wide as the table that is identical in both files cannot be told from a heading. When that title holds a number or a date (a year, version or month), the row the app took is named under Notes. A title with neither is not flagged, so check the column names on screen. Under Heading row in step 2 you can set the row per sheet and per side (rows 1 to 30, or none).
Measured on the author's PC with made-up data: 100,000 rows × 20 columns, nearly every value different, took about 15 seconds to read, compare and write, and used about 700 MB of memory. A table with many repeated values took about 13 seconds and 430 MB. 1,000,000 rows was not measured. Time and memory on other PCs were not measured either.
It compares cell values: text, numbers, dates, booleans and error values. Formulas are compared by their saved results. Comments, pictures, shapes, charts, pivot tables, conditional formatting and data validation are not compared. Only .xlsx is read. .xls, .xlsm, .xlsb and password-protected files are not read, and for .xls and password-protected files the reason is shown in a red box. The on-screen list shows the first 10,000 differences; the exported file holds all of them.
No. The originals are only read, and nothing goes over the network. The exported file contains no author name and no file location.
Not yet. The file passed a validator with 0 errors, but it has not been opened in a spreadsheet application itself, so a repair prompt is not ruled out.
Yes, when they are saved as .xlsx. It lists every changed cell, added and removed row and column change between the two files.
On the Microsoft Store, linked at the top and bottom of this page.
Get Sheet Compare on the Microsoft Store
Microsoft, Windows and Excel are trademarks of Microsoft Corporation. This page and the app are not affiliated with, made or endorsed by Microsoft.
Questions? Support or support@hullspark.com.
Hullspark