Data & Spreadsheets

Compare Two Lists

Paste two lists of names or IDs to see what is missing, shared or repeated. Compare a column from two spreadsheets and download the results as TXT, CSV or Excel.

Compare my lists
FreeWebOfficial source checked Task notes available ↓
Start with a specific job

Compare two lists

Compare a guest list with your RSVPs. Put invited names in A and replies in B, then open Only in A to see who still needs a reminder.

See the steps, results & sample files

What you can use it for

  • List comparison
A practical starting point

Find missing, shared and repeated values

Paste two lists or pick a column from each spreadsheet. See which names or IDs appear on just one side and which appear on both.

Copy just the group you need, or download all three groups together as an Excel workbook.

A short workflow

  1. Select one identifying column per file or paste one value per line.
  2. Choose whitespace and case rules before comparing; check the preview and duplicate groups.
  3. Inspect the source rows for surprises, then verify the complete downloaded results.
List comparison results with the source rows for a repeated value expanded.
Expand a repeated value to see every row where it appears. View full size ↗

Before you start

Where did a missing or repeated ID come from?

Expand the value in the results to see its original line, CSV record or spreadsheet cell.

How do I compare IDs with leading zeros?

Keep IDs as text in the source file. The text values 00123 and 123 will appear as separate IDs.

Notes based on evidence checked .

Working with your files

For codes such as 00123, keep the source column as text. Choose whether letter case and outer spaces should count as differences.

Try the sample lists

With the default rules, the sample gives 3 values only in A, 2 only in B and 4 in both. Select the ID column in the CSV or Excel sample to get the same groups.

Follow the example with text, CSV or Excel files ↗

Try the sample files

Compare the sample lists with your own results. The download includes two lists, their matching rules and the expected values in each group.

Evidence files and checksums — list-comparison-v1

Features and plans change. If something here is out of date, suggest a correction.

Choose by the job

Other routes worth considering

Alternatives and useful next steps, with their limits made clear.

Curated collections

See how it fits the task.

Shortlists with a reason for every choice.

All collections ↗

More in this category

See all ↗

Estimate a spending allowance before giving an AI agent access to paid services. Enter expected tasks, unit cost and a buffer to generate daily, monthly and per-payment budgets plus a JSON configuration outline.

  • Agent cost planning
  • API spend budgets

Use TradingView analytical scripts to organise manual chart review, market structure, scenario planning and portfolio context.

  • Structure chart-analysis workflows
  • Review risk scenarios