Best AI tools to write Excel/Sheets formulas
Short answer
Better Analyst (formerly Formula Bot) ranks #1 for write Excel/Sheets formulas (score 10.0/10). Pricing: $20/mo ($10 first-month promo); free tier: yes. Runners-up: Copilot in Excel, Rows.
Top 5, ranked by our published rubric. Sponsorship never affects the order. Last updated 2026-10-13.
1Better Analyst (formerly Formula Bot)
All-in-one AI analytics app (formulas, data analysis)Score 10.0/10 (fit 10.0 · value 10.0 · breadth 10 · availability 10) · how we score
Pricing: Free tier: yes · Paid from: $20/mo ($10 first-month promo) · source, Pricing last checked: 2026-10-13 · Site checked: 2026-10-13 (live)
Why ranked: Its own site says: “Better Analyst is the all-in-one analytics app for individuals and growing businesses.” We placed it 1st of 5 on fit for this task. Free tier; paid from $20/mo ($10 first-month promo).
2Copilot in Excel
AI features inside ExcelScore 8.0/10 (fit 8.5 · value 7.5 · breadth 8 · availability 7) · how we score
Pricing: Free tier: no (1-month trial) · Paid from: $9.99/mo via Microsoft 365 Personal ($99.99/yr) · source, Pricing last checked: 2026-10-13 · Site checked: 2026-10-13 (bot-blocked (403))
Why ranked: Copilot in Excel: AI features inside Excel. We placed it 2nd of 5 on fit for this task. No free plan confirmed; paid from $9.99/mo via Microsoft 365 Personal ($99.99/yr).
3Rows
Spreadsheet with built-in AIScore 7.8/10 (fit 5.5 · value 10.0 · breadth 10 · availability 10) · how we score
Pricing: Free tier: yes · Paid from: $8/user/mo · source, Pricing last checked: 2026-10-13 · Site checked: 2026-10-13 (live)
Why ranked: Its own site says: “Use AI to analyze data from 50+ sources — PDFs, databases, analytics tools, and bank accounts.” We placed it 4th of 5 on fit for this task. Free tier; paid from $8/user/mo.
SPONSORED Your tool here: paid placement is shown here, separate from the ranking, and never changes the order. Advertise
4Gemini in Google Sheets
AI features in SheetsScore 7.3/10 (fit 7.0 · value 7.5 · breadth 6 · availability 10) · how we score
Pricing: Free tier: no (14-day trial) · Paid from: $7/user/mo (Workspace Business Starter, annual; $4.90 intro promo) · source, Pricing last checked: 2026-10-13 · Site checked: 2026-10-13 (live)
Why ranked: Its own site says: “Gemini in Sheets helps you simplify complex data, reveal insights, and turn data into interactive mini-apps.” We placed it 3rd of 5 on fit for this task. No free plan confirmed; paid from $7/user/mo (Workspace Business Starter, annual; $4.90 intro promo).
5ChatGPT
General AI assistant by OpenAIScore 7.0/10 (fit 4.0 · value 10.0 · breadth 10 · availability 10) · how we score
Pricing: Free tier: yes · Paid from: Go $8/mo (Plus $20/mo) · source, Pricing last checked: 2026-10-13 · Site checked: 2026-10-13 (live)
Why ranked: Its own site says: “Use ChatGPT to answer questions, write, create images, complete work, and code—all in one place.” We placed it 5th of 5 on fit for this task. Free tier; paid from Go $8/mo (Plus $20/mo).
FAQ
What is the best AI tool to write Excel/Sheets formulas?
By TaskRanking's published rubric, Better Analyst (formerly Formula Bot) ranks first, followed by Copilot in Excel and Rows.
Is there a free AI tool to write Excel/Sheets formulas?
Yes: Better Analyst (formerly Formula Bot) has a free tier per its own pricing page (checked 2026-10-13).
How are these tools ranked?
Score = 50% fit, 25% value (from vendor pricing pages), 15% breadth, 10% availability. Sponsorship never affects rank.