All AutosheetBench tasks

Add a dropdown of existing values

Data operationsEasyDeterministic scoringLatest run

Passed by 11 of 12 products on their best model. Failed: ChatGPT in Sheets.

Prompt and starting spreadsheet

Task files

Prompt

Add a data-validation dropdown to column F whose allowed values are the unique values currently found in that column.

Starting spreadsheet

Data · rows 1–21 of 31
ABCDEF
1Order IDOrder DateCustomerProductAmountRegion
2ORD-10002026-07-01AcmeWidget A100North
3ORD-10012026-07-02GlobexWidget B137South
4ORD-10022026-07-03InitechGadget X174East
5ORD-10032026-07-04UmbrellaGadget Y211West
6ORD-10042026-07-05SoylentGizmo Z248Central
7ORD-10052026-07-06WayneWidget A285North
8ORD-10062026-07-07StarkWidget B322South
9ORD-10072026-07-08WonkaGadget X359East
10ORD-10082026-07-09AcmeGadget Y396West
11ORD-10092026-07-10GlobexGizmo Z433Central
12ORD-10102026-07-11InitechWidget A470North
13ORD-10112026-07-12UmbrellaWidget B507South
14ORD-10122026-07-13SoylentGadget X544East
15ORD-10132026-07-14WayneGadget Y581West
16ORD-10142026-07-15StarkGizmo Z618Central
17ORD-10152026-07-16WonkaWidget A655North
18ORD-10162026-07-17AcmeWidget B692South
19ORD-10172026-07-18GlobexGadget X729East
20ORD-10182026-07-19InitechGadget Y766West
21ORD-10192026-07-20UmbrellaGizmo Z803Central

A passing output

Autosheet in Excel · Opus 5.5

How each AI configuration did

20 of 22 passRun files
Excel and Sheets · All types · All models · All outputs

Pass criteria

All must be met, checked automatically.
  • F2:F31 has a dropdown of "North", "South", "East", "West" and "Central"

Passed 20

Autosheet in Excel Opus 5.5 · Medium

Passed8s · 2¢

Autosheet in Excel GPT-6 Astra · Low

Passed7s · 5¢

Autosheet in Sheets Opus 5.5 · Medium

Passed12s · 3¢

Autosheet in Excel Sonnet 5.5 · Medium

Passed5s · 1¢

Claude in Excel Opus 5.5 · High

Passed19s · 12¢

Autosheet in Excel Haiku 5.5 · High

Passed8s · 0.1¢

Claude in Sheets Opus 5.5 · Medium

Passed16s · 4¢

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed33s · N/A

Autosheet in Excel GPT-6.1 Sol · Medium

Passed10s · 2¢

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed25s · N/A

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed40s · N/A

Autosheet in Sheets Haiku 5.5 · High

Passed24s · 0.2¢

ChatGPT in Excel GPT-6 Astra · Medium

Passed14s · 37¢

Claude in Excel Haiku 5.5 · High

Passed18s · 0.6¢

Claude in Sheets Haiku 5.5 · High

Passed18s · 1¢

Autosheet in Excel GPT-6 Luna · High

Passed11s · 0.2¢

Copilot in Excel Auto

Passed14s · N/A

ChatGPT + Drive MCP GPT-6 · Medium

Passed25s · N/A

ChatGPT in Excel GPT-6 Luna · High

Passed26s · 0.5¢

Gemini in Sheets Auto

Passed49s · N/A

Failed 2

ChatGPT in Sheets GPT-6 Astra · Medium

Failed24s · 27¢

Why it failed: F2:F31 has no dropdown of the expected values.

ChatGPT in Sheets GPT-6 Luna · High

Failed12s · 0.3¢

Why it failed: F2:F31 has no dropdown of the expected values.