Compare two lists (unique and shared rows, count changes)
About this tool
Find the product codes added, removed or kept between inventory counts, even if the order changed. When a code was scanned more than once, compare its number of occurrences. Paste a column from Excel or another spreadsheet. All processing happens entirely in your browser (no data is sent).
Lists to compare
Paste one entry per line and omit the header. Results update as you type.
By default, leading and trailing whitespace matters. Blank lines and lines containing only whitespace are always skipped.
Comparison results
Paste the lists you want to compare into A and B.
Compare occurrence counts, including duplicates
Shows entries with different counts in A and B. The number in parentheses is B minus A. Entries are quoted, with tabs shown as \t and backslashes as \\.
Reconcile product codes before and after an inventory count
Suppose list A contains 0017, 0024 and 0031 before the count, and list B contains 0031, 0017, 0048 and 0048 after it. Enter one code per line to get these results.
- Only in A: 0024. This code disappeared from the new list.
- Only in B: 0048. This code was added. It occurs twice in B, so the tool counts one duplicate and lists the code once.
- In both lists: 0017, 0031. The codes match even when their order changes. Shared rows follow their first occurrence in A. Rows found in one list follow their first occurrence there.
When each item is scanned individually
If you scanned 0017 twice last time and once this time, it appears in “In both lists”. Open “Compare occurrence counts, including duplicates” to see A 2 → B 1 (-1) "0017". The scan count fell by one. If your spreadsheet puts a product code and quantity on the same row, the tool does not sum the quantity column.
Things to check when matching codes
0017 and 17 are different codes, as are p01 and P01. To preserve leading zeros when pasting results into a spreadsheet, format the destination column as text first.
Each result lists a code once, regardless of how often it occurs. To track moved lines or rewritten text, use the side-by-side text diff tool.
To reconcile folders before and after delivery, list the files in each folder and paste their relative paths into A and B. “Only in A” and “Only in B” show files found in just one folder.