All AutosheetBench tasks

Make a table look professional

FormattingHardLLM judge scoringLatest run

Passed by 2 of 12 products on their best model: Autosheet in Excel and Autosheet in Sheets.

Prompt and starting spreadsheet

Task files

Prompt

Make this table look professionnal.

Starting spreadsheet

Data
ABCDEFG
1DateItems soldRevenueTarget revenueAbove targetMarginMargin %
24567212501850017000TRUE62000.3351
3456899801425015000FALSE41000.2877
44570521002630024000TRUE79000.3004
54572115751980020000FALSE56000.2828
64573730504120038000TRUE126000.3058

Expected result

How each AI configuration did

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

Pass criteria

All must be met, checked by an LLM judge.
  • Formatted in place, with a distinct header
  • Dates as dates, thousands separators on quantities
  • Currency and percentage formats
  • Above target colored green or red

Passed 4

Autosheet in Excel Opus 5.5 · Medium

Passed14s · 5¢

Autosheet in Excel GPT-6 Astra · Low

Passed10s · 7¢

Autosheet in Sheets Opus 5.5 · Medium

Passed30s · 9¢

Autosheet in Excel GPT-6.1 Sol · Medium

Passed25s · 4¢

Failed 18

Autosheet in Excel Sonnet 5.5 · Medium

Failed8s · 2¢

Why it failed: The 'Above target' values (TRUE/FALSE) are displayed in plain black font without any green/red text or cell background color coding.

Claude in Excel Opus 5.5 · High

Failed18s · 9¢

Why it failed: Revenue and Target revenue were given number format '#,##0' without currency formatting or symbols.

Autosheet in Excel Haiku 5.5 · High

Failed17s · 0.2¢

Why it failed: Revenue and Target revenue were formatted with standard thousands separators without any currency formatting/symbol.

Claude in Sheets Opus 5.5 · Medium

Failed25s · 6¢

Why it failed: Revenue and Target revenue were formatted as plain integers with comma separators rather than being formatted as currency.

Claude Code + Sheets MCP Opus 5.5 · Medium

Failed1m 8s · N/A

Why it failed: The 'Above target' column uses standard checkboxes rather than visual color coding (such as green for TRUE and red for FALSE).

Claude Code + Autosheet MCP Opus 5.5 · Medium

Failed57s · N/A

Why it failed: Above target values remain standard text without color coding.

ChatGPT + Autosheet MCP GPT-6 · Medium

Failed56s · N/A

Why it failed: The Above target column is not color coded; TRUE and FALSE are displayed as standard black text.

Autosheet in Sheets Haiku 5.5 · High

Failed31s · 0.3¢

Why it failed: The 'Above target' column shows standard black text ('TRUE'/'FALSE') with no color coding applied.

ChatGPT in Excel GPT-6 Astra · Medium

Failed42s · 64¢

Why it failed: Revenue and Target revenue get thousands separators but no currency format.

Claude in Excel Haiku 5.5 · High

Failed14s · 0.5¢

Why it failed: Revenue and Target revenue are formatted as plain integers with space separators (e.g., 18 500) rather than currency.

Claude in Sheets Haiku 5.5 · High

Failed42s · 1¢

Why it failed: Revenue and Target revenue are formatted as plain numbers (#,##0) without any currency formatting or currency symbols.

Autosheet in Excel GPT-6 Luna · High

Failed17s · 0.3¢

Why it failed: Revenue amounts lack currency symbols.

Copilot in Excel Auto

Failed42s · N/A

Why it failed: Revenue and Target revenue lack currency symbols.

ChatGPT + Drive MCP GPT-6 · Medium

Failed55s · N/A

Why it failed: Revenue and Target revenue columns are formatted with plain thousand separators (e.g., 18,500) rather than currency symbols/formatting.

ChatGPT in Excel GPT-6 Luna · High

Failed43s · 0.7¢

Why it failed: Revenue and Target revenue are formatted as standard numbers with thousand separators ('18 500', '17 000') rather than as currency.

Gemini in Sheets Auto

Failed2m 33s · N/A

Why it failed: The 'Above target' column contains plain black text with white backgrounds and is not visually color coded.

ChatGPT in Sheets GPT-6 Astra · Medium

Failed50s · 59¢

Why it failed: Revenue and Target revenue are formatted as plain numbers with thousands separators (e.g., '18,500', '17,000') rather than currency formatted with a currency symbol.

ChatGPT in Sheets GPT-6 Luna · High

Failed1m 16s · 0.7¢

Why it failed: Revenue and Target revenue were formatted with commas but lack currency formatting (as noted in the transcript: 'I left revenue and margin without a currency symbol').