Cuiar
Sign inDownload

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
Use in CuiarRun from your AI agent

What it does

The task

Open the sheet sheet url. Check each column for values of the wrong type, impossible values such as negative quantities or dates in the future, outliers far from the rest of the column, mixed units or currencies, broken formulas, and totals that do not match their rows. Also apply these rules: rules. Do not change any cell. Add a tab named Issues with the cell, the value, the problem and a suggested fix, the most serious first.

  • 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
sheet urlThe Google Sheet to checkhttps://docs.google.com/spreadsheets/d/1Fe7pQs3Mb/edit
rulesYour own rules for valid values, or noneDiscount is 0% to 40%. Ship date is on or after the order date.

What you get back

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

Issues found: 47 in 9,120 rows

CellValueProblemSuggested fix
F2231-12Negative quantityCheck the return order R-2231
H4082027-03-14Ship date in the futureProbably 2026-03-14
J51101,240.00Unit price 100 times the medianProbably 12.40
K17 to K96Reference errorBroken formula after a column was deletedPoint it to column M

Rule breaks: 6 discounts above 40%, 3 ship dates before the order date

Tab: Issues, 47 rows. No cell changed.

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 2 blanks

    Type sheet url and rules. 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 sheet https://docs.google.com/spreadsheets/d/1Fe7pQs3Mb/edit. Check each column for values of the wrong type, impossible values such as negative quantities or dates in the future, outliers far from the rest of the column, mixed units or currencies, broken formulas, and totals that do not match their rows. Also apply these rules: Discount is 0% to 40%. Ship date is on or after the order date.. Do not change any cell. Add a tab named Issues with the cell, the value, the problem and a suggested fix, the most serious first."

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 "Find errors and outliers in a spreadsheet" template with sheet url = https://docs.google.com/spreadsheets/d/1Fe7pQs3Mb/edit; rules = Discount is 0% to 40%. Ship date is on or after the order date..

Setup for other agents: AI agents.

The tool call

{
  "name": "run_task",
  "arguments": {
    "task": "Open the sheet https://docs.google.com/spreadsheets/d/1Fe7pQs3Mb/edit. Check each column for values of the wrong type, impossible values such as negative quantities or dates in the future, outliers far from the rest of the column, mixed units or currencies, broken formulas, and totals that do not match their rows. Also apply these rules: Discount is 0% to 40%. Ship date is on or after the order date.. Do not change any cell. Add a tab named Issues with the cell, the value, the problem and a suggested fix, the most serious first."
  }
}

Related templates

All data templates

  • Data

    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
    • 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