Find Matching & Missing Rows
Compare selected keys and find rows present or absent in another sheet.
Find differences between two selected worksheets by row and column position. The result lists each differing cell with the values from both sheets.
Loading workspace…
Preparing the controls for this tool. Your files have not been selected or uploaded.Working with many files? Open batch processing for supported operations. Batch uses its own basic options.
Compare two inventory files — Find changed quantities and missing product records.
Choose XLSX or CSV, then load your worksheets. The first row is a header. Downloads contain values; original formulas and formatting are not preserved.
Your files and inputs are processed in your browser and are not uploaded. Download or copy results before leaving. Normal site and library requests still reach the hosting service.
The comparison checks imported cell values, including headers. It does not compare formatting, styles or formula expressions: formulas use cached values from the source. Numbers and text are distinct, so numeric 1 differs from text "1".
Extra rows or cells produce differences against blank positions. Inserting a row shifts later comparisons; the tool does not automatically match business keys or classify rows as added/removed. Use Match Rows Between Files for selected-key matching. Useful examples include checking exports or comparing two versions of a price list.
This tool compares cell positions. Use Match Rows Between Files for matching or non-matching rows based on selected columns.
No. It compares imported values; cached formula results may be compared, but formula expressions and formatting are excluded.
Files and inputs are processed locally in your browser and are not uploaded. The hosting service receives normal website and library requests. Download or copy results before leaving.
Choose XLSX or CSV, then load your worksheets. The first row is a header. Downloads contain values; original formulas and formatting are not preserved.