Best AI for spreadsheets & Excel / head-to-head
Claude Opus 4.8 vs GPT-5.6 Lunafor spreadsheets & Excel
GPT-5.6 Luna wins, 98–94
Same 12 spreadsheets & Excel tasks, marked blind by three rival labs. GPT-5.6 Luna took 2 tasks, Claude Opus 4.8 took 2, 8 tied. Tested 13 Aug 2026.
Where they differed most
In Google Sheets, tab 'Sales' has headers in row 1: Date, Rep, Region, Amount. Write one QUERY() formula returning total Amount per Rep for the North region only, sorted highest first. Return only the formula.
``` =QUERY(Sales!A:D, "SELECT B, SUM(D) WHERE C = 'North' GROUP BY B ORDER BY SUM(D) DESC LABEL SUM(D) 'Total Amount'", 1) ```
=QUERY(Sales!A:D,"select B, sum(D) where C = 'North' group by B order by sum(D) desc label sum(D) ''",1)
Task by task
| Task | Claude Opus 4.8 | GPT-5.6 Luna |
|---|---|---|
| Excel formula from a description | 10 | 10 |
| Fix a broken formula | 9 | 8 |
| Clean messy data | 10 | 10 |
| Choose the right chart | 10 | 10 |
| Google Sheets QUERY | 5 | 10 |
| Spot the error in the numbers | 10 | 10 |
| Pivot logic in words | 10 | 9.5 |
| Percentage change trap | 10 | 10 |
| Conditional formatting rule | 10 | 10 |
| Reconcile two lists | 9 | 10 |
| Explain a formula back | 10 | 10 |
| Refuse the impossible | 10 | 10 |
Full receipts: Claude Opus 4.8, GPT-5.6 Luna · judges gemini-3.1-pro-preview, gpt-5.6-terra, grok-4.5
Questions people ask
Which is better for spreadsheets & Excel: Claude Opus 4.8 or GPT-5.6 Luna?
GPT-5.6 Luna — it scored 98/100 against 94/100 on our 12-task spreadsheets & Excel suite, winning 2 tasks to 2 with 8 tied. Every answer was marked blind by three judges from three rival AI labs.
How was this tested?
Both models answered the identical published spreadsheets & Excel tasks. Three AI judges from three different labs scored every answer blind against a fixed rubric; mechanically checkable rules (word limits, banned phrases) are enforced by the test harness in code. The raw outputs and judge verdicts are downloadable.
More spreadsheets & Excel head-to-heads: GPT-5.3-Codex vs GPT-5.6 Luna · Claude Opus 4.8 vs GPT-5.3-Codex · GPT-5.6 Luna vs GPT-5.6 Terra · GPT-5.5 vs GPT-5.6 Luna · GPT-5.6 Luna vs GPT-5.6 Sol · GLM 5.2 vs GPT-5.6 Luna
Full ranking: Best AI for spreadsheets & Excel · model pages: Claude Opus 4.8, GPT-5.6 Luna