Cuiar
Sign inDownload

Compare two lists and find the differences

Rows in only one list, and rows in both with different values, side by side in one sheet.

  • You start it: When you start it
Use in CuiarRun from your AI agent

What it does

The task

Open the list list a and the list list b. Match the rows by key columns, and also match keys with small differences, such as spaces, capital letters or zeros at the start. Make a new Google Sheet with 3 tabs: Only in A, Only in B, and Different values, with the value from A and the value from B side by side. Add a Summary tab with the count for each tab. Do not change either list.

  • It works in Google Sheets and Microsoft Excel, in the workspace you pick, and signs in with passwords from your Cuiar vault.
  • It runs once, when you start it.

What you give it

BlankWhat to giveExample
list aThe first sheet or fileSupplier price list, October (Google Sheet link)
list bThe second sheet or fileOur product catalog (Excel file in Drive)
key columnsThe columns that identify a row in both listsSKU

What you get back

An example run with the example values above. Your run uses your own data.

List A: Supplier price list, October (1,912 rows). List B: our product catalog (1,874 rows)

Matched by SKU: 1,820

Only in A: 92 (new supplier products)

Only in B: 54 (no longer on the supplier list)

Different values: 311 rows

  • Price changed: 287 (median +6.5%)
  • Pack size changed: 24

Matched after cleanup: 38 keys (zeros at the start, for example 00482 and 482)

Sheet: List comparison, 4 tabs

Run it in Cuiar

  1. 01

    Open it

    Click Use in Cuiar on this page. The side panel opens with the task in the composer.

  2. 02

    Fill in 3 blanks

    Type list a, list b and key columns. Tab moves to the next blank.

  3. 03

    Run it

    Run sends it to the agent. Follow each step in the panel, and stop it at any time.

From the terminal

cuiar exec "Open the list Supplier price list, October (Google Sheet link) and the list Our product catalog (Excel file in Drive). Match the rows by SKU, and also match keys with small differences, such as spaces, capital letters or zeros at the start. Make a new Google Sheet with 3 tabs: Only in A, Only in B, and Different values, with the value from A and the value from B side by side. Add a Summary tab with the count for each tab. Do not change either list."

Run it from your AI agent

Claude Code, Codex, Cursor and other MCP clients reach Cuiar at https://mcp.cuiar.com/mcp. Add the server one time, then ask for the task in plain words, or call run_task yourself.

1. Add Cuiar to Claude Code

claude mcp add --transport http cuiar https://mcp.cuiar.com/mcp

2. Ask your agent

Use the Cuiar tool run_task to run my "Compare two lists and find the differences" template with list a = Supplier price list, October (Google Sheet link); list b = Our product catalog (Excel file in Drive); key columns = SKU.

Setup for other agents: AI agents.

The tool call

{
  "name": "run_task",
  "arguments": {
    "task": "Open the list Supplier price list, October (Google Sheet link) and the list Our product catalog (Excel file in Drive). Match the rows by SKU, and also match keys with small differences, such as spaces, capital letters or zeros at the start. Make a new Google Sheet with 3 tabs: Only in A, Only in B, and Different values, with the value from A and the value from B side by side. Add a Summary tab with the count for each tab. Do not change either list."
  }
}

Related templates

All data templates

  • Data

    Find errors and outliers in a spreadsheet

    Impossible values, outliers, broken formulas and mixed units, listed by cell with a suggested fix.

    You start it: When you start it
    • Google Sheets
    • Microsoft Excel

  • Data

    Turn a list on a website into a sheet

    Each item from each page, one row for each, with no duplicates.

    You start it: When you start it
    • Any website
    • Google Sheets

  • Data

    List local businesses with their contacts

    Name, address, phone, website, rating and e-mail for each business.

    You start it: When you start it
    • Google Maps
    • Google Sheets

  • Data

    Export your order history

    For stores with no export: each order in a sheet, with totals for each year.

    You start it: When you start it
    • Any online store
    • Google Sheets

  • Data

    Pull tables from PDFs into a spreadsheet

    Each matching table from your PDFs and scans in one sheet, with numbers as numbers and the page noted.

    You start it: When you start it
    • Google Drive
    • Google Sheets

  • Data

    Clean up a messy spreadsheet

    Consistent names, dates, phone numbers and amounts in a new tab, with a count of each type of change.

    You start it: When you start it
    • Google Sheets