Choose an original and an update
Add two files and select the worksheet in each Excel workbook. File A is the original and file B is the updated export. Choose a matching ID column on each side.
Compare two CSV, TSV or Excel sheets using the column that identifies a record. Row order can change without creating false additions. Choose one value pair or compare all shared non-key columns.
Order 00102 can move from row 3 to row 9 and still match. If its amount changes from 49.90 to 54.90, it is marked Changed rather than Removed and Added.
Add two files and select the worksheet in each Excel workbook. File A is the original and file B is the updated export. Choose a matching ID column on each side.
Compare all shared non-key column names, or choose one value column from each file. Trim spaces or ignore case if that is appropriate for your data. Amount formatting can be normalised without converting ID keys.
The result labels Added, Removed, Changed and Unchanged records. Duplicate IDs are reported as ambiguous, and blank IDs are listed separately. Download the overview plus a cell-level change report.
This compares table values. It does not compare Excel formatting, charts, formulas or workbook structure. Formula cells are read from their saved cached values; recalculate and save the source first.
Supports CSV, TSV and unencrypted XLSX, up to 20 MB per file and 100 input columns. Free use includes 2,000 total input rows per run. Excel downloads contain text cells to preserve identifiers such as 00123. Workbook styling and formulas are not retained.
Read the file and export guideTrim spaces, remove duplicate rows and standardise selected date and number columns. Download a change report alongside your cleaned data.
Stack exports with different headers or join two files using an ID. Keep source file and row details so the combined result is easier to trace.
Rename, reorder and select columns for an import. Set defaults or constant values, then save the mapping for the next export.