Best AI for spreadsheets & Excel / head-to-head
Claude Opus 4.8 vs GLM 5.2for spreadsheets & Excel
GLM 5.2 wins, 96–94
Same 12 spreadsheets & Excel tasks, marked blind by three rival labs. GLM 5.2 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'!A1:D, "SELECT B, SUM(D) WHERE C = 'North' GROUP BY B ORDER BY SUM(D) DESC", 1)Task by task
| Task | Claude Opus 4.8 | GLM 5.2 |
|---|---|---|
| Excel formula from a description | 10 | 10 |
| Fix a broken formula | 9 | 7 |
| 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 | 10 |
| 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 | 8 |
Full receipts: Claude Opus 4.8, GLM 5.2 · 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 GLM 5.2?
GLM 5.2 — it scored 96/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: GLM 5.2 vs GPT-5.3-Codex · Claude Opus 4.8 vs GPT-5.3-Codex · GLM 5.2 vs GPT-5.6 Luna · Claude Opus 4.8 vs GPT-5.6 Luna · GLM 5.2 vs GPT-5.6 Terra · Claude Opus 4.8 vs GPT-5.6 Terra
Full ranking: Best AI for spreadsheets & Excel · model pages: Claude Opus 4.8, GLM 5.2