CoreGPT
Data · Free

Compare Two Lists

Paste two lists, one item per line, and see which items are only in the first, only in the second, or in both. Ideal for Excel and Google Sheets columns.

Only in list A (0)
Only in list B (0)
In both lists (0)
Take it further

Do this inside Excel and Google Sheets with AI.

CoreGPT writes formulas, cleans columns and compares data right in your spreadsheet. Ask in plain English.

Get CoreGPT for Excel

Comparing two lists by eye is slow and easy to get wrong. Paste them here, one item per line, and the tool sorts every item into three groups: only in list A, only in list B, and in both. Copy a column straight out of Excel or Google Sheets: each cell becomes a line. Everything runs in your browser, so customer names, emails and IDs are not uploaded.

  • Finding who is on last month's list but not this month's
  • Checking two columns in Excel or Google Sheets for missing values
  • Comparing email lists before sending a campaign
  • Reconciling product codes, order numbers or invoice IDs
  • Seeing which attendees registered but did not show up
  • Keep Ignore case and Ignore spaces on unless "ABC" and "abc" really are different items
  • Each line is one item: put multi-word items on a single line
  • Duplicates inside one list are counted once
  • Copy a result with its button and paste it back into a spreadsheet column
  • In Excel you can do the same with XLOOKUP or COUNTIF if the lists must stay live

How do I compare two columns in Excel with this tool?

Select the first column in Excel, copy it and paste it into list A. Do the same for the second column and list B. The three result boxes update immediately.

Is there a limit on list size?

No fixed limit. Lists with tens of thousands of lines compare in a moment because the work happens in your browser.

Does the order of items matter?

No. The tool compares the items themselves and keeps each result in the order it first appeared.

Is my data uploaded?

No. The comparison runs entirely in your browser.