BEST AI FOR SPREADSHEETS
As of 22 November 2026, our pick for spreadsheets is Kimi K3: an editor's pick until there are enough blind-test votes.
Editor's pick for now: level with Gemini 4 Neon and GPT-6.2 Astra and Claude Opus 5.5 in LMArena's coding ranking, and the only free one of them (Nov 2026).
Already paying for an AI? Check your setupTHE FIVE MAIN AIS SIDE BY SIDE
The best model each chat app gives a typical $20-a-month subscriber, best first in coding on LMArena. "Level with the best" means its 95% range overlaps the top one's.
| Model | Where to get it | LMArena: coding |
|---|---|---|
| Gemini 4 Neon Google | Google AI Pro, $19.99/month | #1 of 5 · 1559 ±17 · level with the best |
| Claude Opus 5.5 Anthropic | Claude Pro, $20/month, or $17/month billed yearly | #2 of 5 · 1548 ±10 · level with the best |
| Kimi K3 Moonshot AI · our pick | Free in the Kimi app | #3 of 5 · 1537 ±7 · level with the best |
| DeepSeek V4.1 Flash DeepSeek | Free in the DeepSeek app | #4 of 5 · 1525 ±10 |
| GPT-6.2 Astra OpenAI | ChatGPT Plus, $20/month | #5 of 5 · 1523 ±28 · level with the best |
Sources: LMArena text leaderboard, 19 November 2026 (CC BY 4.0); prices from each lab's plan page. Preference in blind votes, not a fact check. All plans and prices
HOW THE MODELS COMPARE
Voting has just started.
A people's pick needs 200 counted votes across at least 3 prompts. Until then, the pick above is the editor's. Vote in the blind test: it takes a minute.
No scores yet: they appear once there are 100 counted votes across the site and a model has been in 20 votes.
What players preferred in blind tests. Preference, not a fact check. Scores are Bradley-Terry ratings (1000 = average) with 95% ranges; each prompt counts equally. How we score
THE PROMPTS WE TEST WITH
Written in advance and picked by rotation, never after seeing the answers.
- In Excel, I have names in column A and birthdays in column B. What formula shows each person's current age in column C?
- How do I make Google Sheets turn a whole row red when the date in column D is in the past?
- I have a list of expenses with a date, an amount and a category. What's the easiest way to see how much I spent per category each month in Excel? Step by step.
- Write a formula that looks up the price for a product code from another sheet called "Prices". Should I use VLOOKUP or XLOOKUP?
- My spreadsheet has the same email address on several rows. How do I remove the duplicates but keep the rest of each row?
- Help me set up a simple monthly budget spreadsheet. What columns and formulas should it have? I'm a beginner.
- In Google Sheets, how do I count how many times the word "yes" appears in column B?
- I have first names in column A and last names in column B. What formula puts "Last, First" in column C?
- How do I freeze the top row in Excel so the headers stay visible when I scroll?
- I have dates in column A. What formula gives me the day of the week (like Monday) in column B?
- How do I make a simple drop-down list in Google Sheets so people can only choose "Open", "In progress" or "Done"?
- My column of numbers is stored as text, so SUM doesn't work. How do I fix it in Excel?
- I track my running: date, distance and time. What formulas show my average pace per kilometre and my total distance this month?
- How do I make a chart in Excel that shows monthly sales as bars, with a line for the target? Step by step.
- What's the difference between relative and absolute cell references, like A1 and $A$1? Give one example of when I'd need the dollar signs.