Best AI for Excel (2026): Copilot, Claude, ChatGPT and Gemini for Spreadsheets
Which AI to use inside Excel, in Google Sheets, on an uploaded file or just for formulas, which plans include it on 2026-11-17, and how to check what it writes
By TheBestSuperintelligence Editorial TeamUpdated
What is the best AI for Excel?
The best AI for Excel is Copilot in Excel if you already pay for Microsoft 365 Personal, Family or Premium: it edits your workbook directly. For complex financial models, Claude for Excel; for free use in Excel or Google Sheets, ChatGPT for Excel.
☰On this page (10 sections)
- 01.Which AI should you use for Excel?
- 02.Copilot in Excel: best if you already pay for Microsoft 365
- 03.Claude for Excel: best for financial models
- 04.ChatGPT for Excel: best free option, and it works in Google Sheets too
- 05.Gemini in Sheets: best AI for Google Sheets
- 06.Uploading a spreadsheet to ChatGPT for one-off analysis
- 07.AI Excel formula generator: getting one formula right
- 08.How to check a formula an AI wrote
- 09.Limits of this guide
- 10.Sources & Further Reading
Which AI should you use for Excel?
The best AI for Excel is Copilot in Excel for anyone who already pays for Microsoft 365 Personal, Family or Premium. It is built in, opens from the Copilot icon in the lower-right corner of Excel, and can edit your workbook directly rather than only chat about it. You pay nothing extra, and nothing leaves the Microsoft account you already trust with the file.
Two add-ins beat it for specific jobs. Claude for Excel is the stronger pick for complex, multi-tab financial models, because Anthropic built it around cell-level citations and keeping formula relationships intact. ChatGPT for Excel is the one to try first if you do not want to pay, because OpenAI lists it for Free and Go users and it also works in Google Sheets.
| Job | Pick | Why |
|---|---|---|
| Everyday work inside Excel | Copilot in Excel | Included in Personal, Family, Premium |
| Complex financial models | Claude for Excel | Cell citations; keeps formulas linked |
| Free AI in Excel or Sheets | ChatGPT for Excel | Free and Go plans, limited use |
| Google Sheets users | Gemini in Sheets | Built in; =AI() function |
| One-off analysis of a file | Upload to ChatGPT | Runs Python; shows its code |
Our take: do not buy a second subscription for spreadsheet work until you have used the AI you already pay for. Most people asking this question already have one of them.
Copilot in Excel: best if you already pay for Microsoft 365
Copilot in Excel has three modes, according to Microsoft's current help page. Edit is the default and "can edit your workbook directly", including "complex, multi-step tasks". Plan proposes a structured plan for you to approve before it acts. Chat analyses your data "without making changes to your workbook". Edit, chat and plan all work in Excel on Windows, Mac and the web; iPad has chat and plan, iPhone and Android have chat, with edit mode rolling out on iPad and iPhone.
Microsoft announced on 2026-01-27 that this agent mode was generally available on the web, Windows and Mac for commercial Microsoft 365 Copilot licenses and for Microsoft 365 Personal, Family and Premium subscribers. It said you can pick OpenAI's GPT 5.2 or Anthropic's Claude Opus 4.5, or leave it on Auto. The same post said agent mode was "not yet available to customers in the EU or UK"; the current help page lists no region limit, and we could not confirm the status today.
What each US consumer plan costs and includes, from Microsoft's comparison page:
| Plan | Price (US) | Copilot in Excel |
|---|---|---|
| Microsoft 365 Basic | Not listed | "AI features are not available" |
| Microsoft 365 Personal | $9.99/month or $99.99/year | "Higher than free" |
| Microsoft 365 Family | $12.99/month or $129.99/year | "Higher than free", owner only |
| Microsoft 365 Premium | $19.99/month or $199.99/year | "Extensive" |
Microsoft says Personal and Family use an AI credit model, so heavy users hit limits sooner than on Premium. The comparison page also says Copilot in Excel needs the file saved to OneDrive with AutoSave on. We could not load Microsoft's business Copilot pricing page today, so we do not quote a business price.
Claude for Excel: best for financial models
Claude for Excel is an add-in for Excel on the web, on Windows with a Microsoft 365 subscription (build 16.0.13127.20296 or later) and on Mac (16.46 or later). Anthropic lists it as generally available on Pro, Max, Team and Enterprise. Claude's pricing page shows Pro at $20 a month billed monthly or $17 a month billed annually ($200 up front), and marks Claude for Microsoft 365 "No" on the Free plan.
Its design suits models you have to defend. Answers come with cell-level citations you can click; it adjusts assumptions "while keeping formula relationships intact"; it traces errors such as #REF! to the root cause; and it can populate templates or build a model from a description. It works across multi-tab workbooks and can pull data through connectors such as S&P Global, LSEG and Daloopa.
Anthropic is unusually direct about limits. It does not recommend the add-in for final client deliverables without human review or for audit-critical calculations without verification. It does not support data tables, macros or VBA, and it does not run on Excel 2016 or 2019 perpetual licences, iPad or Android. It also warns that downloaded templates and vendor files can carry hidden prompt injections, so use it only on spreadsheets you trust.
Our take: if you build DCFs, LBOs or three-statement models for a living, this is the add-in to trial first. For more on that work, see our guide to AI for financial modeling and investing.
ChatGPT for Excel: best free option, and it works in Google Sheets too
ChatGPT for Excel and Google Sheets is a sidebar add-in from OpenAI. Install it in Excel from Home, then Add-ins, search for ChatGPT; in Sheets, from the Google Workspace Marketplace. OpenAI's help page says it can build sheets from scratch, explain an unfamiliar workbook, fix broken formulas, run scenarios and sensitivity tables, and search the web for data to pull in.
OpenAI lists it for Free, Go, Plus, Pro, Business, Enterprise, Edu and K-12 users. Free and Go get "limited usage access"; Plus and Pro get access "subject to your plan's agentic usage limit", and bigger workbooks use more of it. We could not read ChatGPT's plan prices today: the archived pricing page did not include them.
Two limits matter. Spreadsheet chats are separate from your main ChatGPT history and have no access to ChatGPT memory, and VBA and macros "may not be fully supported". OpenAI's own advice is good: ask for a plan before big edits, name what to preserve, and duplicate the file first.
Gemini in Sheets: best AI for Google Sheets
If your spreadsheets live in Google Sheets, start with Gemini, which is already in the product. Google's help pages list a side panel that can create tables, create formulas, fix formula errors, generate charts and analysis, and perform actions such as pivot tables, filters and conditional formatting. A Build option can create a whole spreadsheet from a prompt and asks clarifying questions before it starts.
All of these need "an eligible Google Workspace or Google AI plan". Google's Workspace pricing page (served to us with euro prices, so we do not quote them) marks Gemini in Sheets as included in Business Standard and Business Plus and "not supported" on Business Starter. Build gives personal accounts limited use, "up to 3 times a month".
Gemini works best on native Sheets files, so convert .xlsx files first. Generated charts do not update when the data changes, and the chat history disappears when you reload, so insert anything you want to keep.
Uploading a spreadsheet to ChatGPT for one-off analysis
For a single question about a file ("what drove the Q3 drop?"), an add-in is overkill. OpenAI's data analysis help page says ChatGPT accepts .xls, .xlsx and .csv files, writes and runs Python in a Jupyter environment, and can draw bar, line, pie and scatter charts. Its Python environment cannot make web requests, and very large or formula-heavy files may not be analysed in full.
Prepare the file: headers in the first row, one record per row, no stacked tables or blank rows splitting the data. Then read the code it ran, not just the answer. Our guide to AI for data analysis and visualization covers tools for bigger datasets.
AI Excel formula generator: getting one formula right
If you only need one formula, you do not need an agent. In Google Sheets, type = in a cell and use the Gemini shortcut to create a formula, or the Fix option on a formula error. In Excel, ask Copilot in chat mode, or ask ChatGPT for Excel to explain an error, as in OpenAI's example prompt: "Why am I getting an error in cell B145? Explain the formula chain and propose a fix."
Google Sheets also has an AI function, written =AI("prompt", range) or =Gemini(), for text jobs across rows: summarising feedback, tagging categories, judging sentiment. Google says it returns text only, cannot see the whole sheet, generates the first 350 selected AI cells per run, and cannot be nested inside other functions. Use it for labels, not numbers.
For tested prompts, see our AI prompts for data analysis.
How to check a formula an AI wrote
Every vendor above tells you to review the output. Here is what that means in practice:
- Trace the inputs. Select the cell and use Formulas, Formula Auditing, Trace Precedents to see which cells feed it, then Trace Dependents to see what it changes downstream.
- Step through it. Formulas, Formula Auditing, Evaluate Formula shows each part of a nested formula in the order Excel calculates it. Microsoft notes that volatile functions such as NOW, INDIRECT and OFFSET can show different results in this tool than in the cell.
- Test a row by hand. Pick two or three rows, including an edge case (a blank, a zero, a negative), and calculate them yourself.
- Check the range. AI-written formulas often stop one row short or use a relative reference where an absolute one ($A$1) is needed. Fill the formula down and look at the last row.
- Ask for a change log. Ask the add-in to list every cell it changed, as OpenAI suggests, and compare that list against a copy of the original file.
Limits of this guide
- Plan names and inclusions change often; Microsoft's and OpenAI's pages describe usage limits without stating numbers.
- Google's and Microsoft's business prices are missing: the pages served us euro prices or failed to load.
- Agent mode availability in the EU and UK could not be confirmed.
Sources & Further Reading
| Claim | Source | Date |
|---|---|---|
| Copilot in Excel edit, plan and chat modes; platform support | Microsoft Support: Get started with Copilot in Excel | Read 2026-11-17 |
| Agent mode GA on web, Windows, Mac; eligible licenses; GPT 5.2 and Claude Opus 4.5; not yet in EU or UK; AI credit model | Microsoft Excel Blog, 2026-01-27 | Read 2026-11-17 |
| Microsoft 365 Personal, Family, Premium US prices; Copilot in Excel levels; no AI in Basic; OneDrive and AutoSave | Microsoft 365: compare all plans | Read 2026-11-17 |
| COPILOT function retired September 14, 2026; #NAME? on recalculation | Microsoft Support: COPILOT function | Read 2026-11-17 |
| Claude for Excel plans, versions, features, limitations, prompt-injection warning | Claude docs: Use Claude for Excel | Read 2026-11-17 |
| Claude Pro $20 monthly or $17 annual; Microsoft 365 not on Free | Claude pricing | Read 2026-11-17 |
| ChatGPT for Excel and Google Sheets: plans, usage, install steps, limitations, example prompts | OpenAI Help: ChatGPT for Excel and Google Sheets (Internet Archive copy of 2026-11-16) | Read 2026-11-17 |
| ChatGPT data analysis: file types, Python, charts, constraints | OpenAI Help: Data analysis with ChatGPT (Internet Archive copy of 2026-11-10) | Read 2026-11-17 |
| ChatGPT pricing page (plan features; prices not in the copy) | ChatGPT pricing (Internet Archive copy of 2026-11-16) | Read 2026-11-17 |
| Gemini in Sheets features and limitations | Google Docs Editors Help: Gemini in Google Sheets | Read 2026-11-17 |
| Build spreadsheets with Gemini; personal accounts up to 3 times a month | Google Docs Editors Help: Build or edit entire spreadsheets | Read 2026-11-17 |
| AI function syntax and limits (350 cells, text only, no nesting) | Google Docs Editors Help: Use the AI function | Read 2026-11-17 |
| Gemini in Sheets by Workspace plan (page served euro prices) | Google Workspace pricing | Read 2026-11-17 |
| Trace Precedents and Trace Dependents | Microsoft Support: Display the relationships between formulas and cells | Read 2026-11-17 |
| Evaluate Formula; volatile functions note | Microsoft Support: Evaluate a nested formula one step at a time | Read 2026-11-17 |
Frequently asked questions
What is the best AI for Excel?
The best AI for Excel is Copilot in Excel if you already pay for Microsoft 365 Personal, Family or Premium: it edits your workbook directly. For complex financial models, Claude for Excel; for free use in Excel or Google Sheets, ChatGPT for Excel.
Is there a free AI for Excel?
Yes, with limits. OpenAI lists ChatGPT for Excel and Google Sheets for Free and Go users with "limited usage access". Copilot in Excel needs a paid Microsoft 365 plan, Microsoft says AI features are not available in Microsoft 365 Basic, and Claude for Microsoft 365 is marked "No" on the Claude Free plan.
What happened to the COPILOT function in Excel?
Microsoft retired it. Its support page says that starting September 14, 2026, the COPILOT function is no longer available in Excel. Existing workbooks keep cached results, but on recalculation the cell returns a #NAME? error. Replace those cells with ordinary formulas or values before you recalculate.
Can I use Copilot in Excel with my work account?
Yes, if your organisation assigns a commercial Microsoft 365 Copilot license. Microsoft announced agent mode for those licenses alongside Personal, Family and Premium. Admins must allow Anthropic models before Claude models appear, and Microsoft says Copilot may be unavailable because of your organisation's settings.
Does the AI function in Google Sheets work on my whole spreadsheet?
No. Google says the AI function cannot see your entire spreadsheet or other Drive files, so you pass it a range. It returns text only, generates the first 350 selected AI cells per run, cannot be nested inside another formula, and has short- and long-term usage limits.
How we sourced this. We read the Microsoft, Anthropic, OpenAI and Google help and pricing pages on 2026-11-17 (OpenAI pages through Internet Archive copies). We did not test the products ourselves. Methodology