Compare two Excel files, catch every difference
Drop two files (or two sheets) in, pick key columns and instantly see missing rows, extra rows and every changed cell. Everything runs on your device.
Original
Drop the file for side A
.xlsx · .xls · .csv · up to 50 MB
Comparison copy
Drop the file for side B
.xlsx · .xls · .csv · up to 50 MB
How rows are matched between the two sides
Pairs: Column 1 ↔ Column 1
How to compare two Excel files for differences
Reconcile two reporting periods, two versions sent by a client or two sheets in the same file — SheetDrop shows missing rows, extra rows and every changed cell.
- 1. Drop the 2 files to compare
Pick two .xlsx, .xls or .csv files (or the same file to compare two of its sheets). Each side accepts up to 50 MB.
- 2. Choose sheets and matching mode
Select the sheet for each side, then match by key column(s) (one or more, paired between the sides) or compare entire rows.
- 3. Run the comparison and review
Results split into four groups: only in A, only in B, identical and changed values. The changed group lists every differing cell with both values.
- 4. Download the XLSX report
The report contains the Overview, Only in A, Only in B and Changed values sheets so you can keep filtering in Excel if needed.
Frequently asked questions about comparing Excel files
Does SheetDrop send my file contents anywhere?
No. Both files are read and compared entirely in your browser. SheetDrop sends nothing anywhere and never modifies your original files.
Which formats and sizes can I compare?
Each side accepts one .xlsx, .xls or .csv file up to 50 MB. The two sides can come from different files or from two sheets of the same file.
Are my original files modified?
No. SheetDrop only reads the data to compare and creates a brand-new report file for you to download. Both source files remain exactly as they were.
Can I compare files with different column names?
Yes. Columns are paired by header name, regardless of order; columns that exist on only one side are reported in a warning instead of being compared. For key matching you can pick different columns on each side (paired in the order you select).
How should I choose key columns?
Pick a column whose value is unique per row on both sides, for example Customer ID, Product Code or Code + Region when one column is not enough. Without key columns, use “Entire row” mode to match identical rows. When comparing values, numbers and numeric strings are considered equal (5 equals "5"), leading zeros are preserved so "001" differs from "1"; if a side has duplicate column names, only the first of each name is compared and a warning is shown.