aiintelligence

Best AI for spreadsheets & Excel / head-to-head

GPT-5.6 Luna vs GPT-5.6 Terrafor spreadsheets & Excel

The verdict

Dead heat: 98 each

Same 12 spreadsheets & Excel tasks, marked blind by three rival labs. Tested 13 Aug 2026.

Where they differed most

The task — Reconcile two lists

You have invoice numbers in Sheet1!A:A and payments in Sheet2!A:A. Give one Excel formula for Sheet1!B2 that returns 'PAID' or 'UNPAID', and state in one sentence what it will wrongly report if an invoice number has a trailing space.

GPT-5.6 Luna10/10
```excel
=IF(COUNTIF(Sheet2!A:A,A2)>0,"PAID","UNPAID")
```

If the invoice number has a trailing space, it may not match the corresponding payment number and will be incorrectly reported as **“UNPAID.”**
GPT-5.6 Terra9/10
```excel
=IF(COUNTIF(Sheet2!A:A,A2)>0,"PAID","UNPAID")
```

If an invoice number in either sheet has a trailing space, it may be wrongly reported as `UNPAID` because the values will not match exactly.

Task by task

TaskGPT-5.6 LunaGPT-5.6 Terra
Excel formula from a description1010
Fix a broken formula88
Clean messy data1010
Choose the right chart1010
Google Sheets QUERY1010
Spot the error in the numbers1010
Pivot logic in words9.510
Percentage change trap1010
Conditional formatting rule1010
Reconcile two lists109
Explain a formula back1010
Refuse the impossible1010

Full receipts: GPT-5.6 Luna, GPT-5.6 Terra · judges claude-sonnet-5, gemini-3.1-pro-preview, grok-4.5

Questions people ask

Which is better for spreadsheets & Excel: GPT-5.6 Luna or GPT-5.6 Terra?

They tied at 98/100 on our spreadsheets & Excel suite — for this job, pick on price or the product you already use.

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 · GPT-5.3-Codex 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 · GPT-5.6 Luna vs Qwen3.7 Max

Full ranking: Best AI for spreadsheets & Excel · model pages: GPT-5.6 Luna, GPT-5.6 Terra