Compare Two Lists

Identifiers can lose meaning when a spreadsheet treats them as numbers. Compare Two Lists keeps leading zeros as part of a text value. In the site's built-in example, List A contains 00123, 123 and two copies of SKU-A; List B contains 123 and SKU-B. Running that example produced 00123 and SKU-A only in A, SKU-B only in B, and 123 in both.

The repeated SKU-A appeared as one group with two source lines. That distinction is central to the tool: it compares which values are present, not how many units of an item exist. A product-code check fits; inventory quantity reconciliation doesn't.

The interface accepts pasted lines or an imported TXT, CSV or Excel column. Outer whitespace is trimmed for matching by default, while case remains significant unless Ignore case is selected. Results retain original text, and imports can keep cell or record references for checking where a value came from.

The documentation describes Excel export with separate worksheets for values only in A, only in B and in both, stored as text. CSV and TXT are available too. Import is limited to one selected column per list, about 5.2 MB per file and 100,000 data rows. It can't restore digits a spreadsheet has already discarded. ProjectRadar observed the small built-in example, without testing file imports, downloads or those limits.

No account is required. The October 1 privacy policy says list comparisons, file reading and exports run locally, with list contents held in page memory rather than saved. Refreshing or closing the tab may clear the work.

That doesn't make the website offline: it uses hosting services and default-on Umami usage analytics. The policy excludes list contents and filenames from analytics, and a footer control turns analytics off. The tool is a focused place to inspect a pair of columns, with the original spreadsheet still needed for the rest of the record.