Handled by Morning Book a free look

Compare two lists and see what is missing

Paste two lists, or drop in two spreadsheets. You get what is only in the first, only in the second and in both, with repeats pointed out. It is free, there is no sign-up, and your lists never leave this page.

Comparing the same two lists every week?

That usually means two systems that should agree and do not. I connect them read-only and send one page each morning with what is missing from each side. A free 30-minute look shows what your systems could answer today.

This sends your email address and nothing else. Nothing you put into the tool is sent.

Book a free look

What people use it for

  • Customers in two systems. Who is in the accounting system and missing from the sales system, and the other way round.
  • This month's price list against last month's. Match on the product code, compare the price column, and see what was added, dropped and repriced.
  • Who has not paid, replied or signed up. Everyone you invited against everyone who answered.
  • Stock counts. What the system says is on the shelf against what was counted.

How to compare two columns from Excel

Select the first column in your spreadsheet, copy it, and paste it into list A. Do the same with the second column into list B. The result appears as you paste.

To compare whole tables, copy several columns at once or drop the file in. Then choose which column to match on, such as a product code or an email address, and which column to compare, such as a price or a balance.

Questions

Are my lists uploaded?

No. The page compares them inside your browser and never sends them anywhere.

How big can the lists be?

A hundred thousand rows on each side compares in about a second on an ordinary computer. Very long files are compared in full even when the box does not show them.

Does "Acme Inc." match "ACME INC"?

Capital letters and extra spaces are ignored unless you untick those boxes. Tick "Ignore punctuation" to also ignore full stops, commas and dashes. Different spellings, such as "Acme Incorporated", do not match.

What happens to repeats?

A value that appears more than once in a list is counted once, and the page tells you which values repeat and how many times.

Who made this?

Handled by Morning sets up private reporting and AI on a company's own books for businesses of about 10 to 100 people. This is one of its free tools, with the aging report and the supplier bill checker.