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

DeepSeek V4 Flash vs Qwen3.7 Maxfor spreadsheets & Excel

The verdict

Qwen3.7 Max wins, 95–93

Same 12 spreadsheets & Excel tasks, marked blind by three rival labs. Qwen3.7 Max took 3 tasks, DeepSeek V4 Flash took 1, 8 tied. Tested 13 Aug 2026.

Where they differed most

The task — Clean messy data

These postcodes were typed by hand: 'sw1a1aa', 'SW1A 1AA', ' m1 4wb', 'M14WB', 'ec1v9nr'. Give a single Excel formula that normalises any one of them to standard UK format (uppercase, one space before the final three characters). Assume the raw value is in A2.

DeepSeek V4 Flash10/10

=REPLACE(UPPER(TRIM(SUBSTITUTE(A2," ",""))),LEN(UPPER(TRIM(SUBSTITUTE(A2," ",""))))-2,0," ")

Qwen3.7 Max8/10

## The Formula

```excel
=LET(c, UPPER(SUBSTITUTE(A2," ","")), LEFT(c, LEN(c)-3) & " " & RIGHT(c, 3))
```

## How it works

The formula does three things in sequence:

| Step | Action | Example (`' m1 4wb'`) |
|---|---|---|
| **1. Clean** | `UPPER(SUBSTITUTE(A2," ",""))` — strips *all* spaces and uppercases | `M14WB` |
| **2. Outward** | `LEFT(c, LEN(c)-3)` — grabs everything except the last 3 chars | `M1` |
| **3. Inward** | `RIGHT(c, 3)` — grabs the last 3 chars | `4WB` |

These are then joined with a single space: **`M1 4WB`**

## Verificati…

Task by task

Task	DeepSeek V4 Flash	Qwen3.7 Max
Excel formula from a description	9	10
Fix a broken formula	7	7
Clean messy data	10	8
Choose the right chart	8	10
Google Sheets QUERY	10	10
Spot the error in the numbers	10	10
Pivot logic in words	10	10
Percentage change trap	10	10
Conditional formatting rule	10	10
Reconcile two lists	10	10
Explain a formula back	10	10
Refuse the impossible	7	9

Full receipts: DeepSeek V4 Flash, Qwen3.7 Max · judges claude-sonnet-5, gemini-3.1-pro-preview, gpt-5.6-terra

Questions people ask

Which is better for spreadsheets & Excel: DeepSeek V4 Flash or Qwen3.7 Max?

Qwen3.7 Max — it scored 95/100 against 93/100 on our 12-task spreadsheets & Excel suite, winning 3 tasks to 1 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 Qwen3.7 Max · DeepSeek V4 Flash vs GPT-5.3-Codex · GPT-5.6 Luna vs Qwen3.7 Max · DeepSeek V4 Flash vs GPT-5.6 Luna · GPT-5.6 Terra vs Qwen3.7 Max · DeepSeek V4 Flash vs GPT-5.6 Terra

Full ranking: Best AI for spreadsheets & Excel · model pages: DeepSeek V4 Flash, Qwen3.7 Max