AI for Excel
Which AI tools work inside Excel and Google Sheets, what each is best at, and a self-checking workflow for the monthly close.
Nobody paid to appear on this page, and we earn nothing from the links on it.
Quick picks
AI inside Excel and Sheets
You no longer need to copy a table into a chat window. ChatGPT, Claude, Copilot and Gemini all now run in a sidebar inside the spreadsheet, read the open file, and edit it with your approval. Which one to use depends mostly on which spreadsheet app and which AI subscription you already have.
| Tool | Excel | Google Sheets | Plan you need | Asks before editing |
|---|---|---|---|---|
| ChatGPT | Yes, desktop and web | Yes | Any ChatGPT plan; Free and Go are limited 7 | Yes 6 |
| Claude | Yes: web, Windows, Mac | Yes, separate add-on in beta 9 | Claude Pro, Max, Team or Enterprise 8 | Confirms risky operations; warns before overwriting |
| Copilot | Yes: Windows, Mac, web; chat only on phones | No | Microsoft 365 Premium, Personal or Family with AI credits, or a business Copilot license 2 | Plan mode proposes first 1 |
| Gemini | No | Yes | Workspace Standard or higher, or a Google AI plan 12 | Action preview card first 11 |
| Julius | Upload files | Google Drive connector | Free, or Plus at $20 13 | Does not edit your workbook |
One change to know about: Microsoft retired the COPILOT worksheet function on 14 September 2026. Cells that used it keep their last results, but recalculating returns #NAME?. Microsoft points users to the Copilot pane instead 3.
Writing formulas
Every tool here writes formulas from a plain-English request. The useful difference is whether it also explains and fixes the formulas you already have.
- Describe the result, not the formulaSay what you want the column to show and which columns feed it. The tool picks the function.
- Name the rangePoint to the sheet and columns. ChatGPT lets you @-mention specific sheets to focus the request 7.
- Ask it to explain before you acceptClaude for Excel answers with cell-level citations you can click to jump to the cell 8. Read the explanation, then apply.
- Test on one row by handCheck one result against the source before you fill the formula down.
Prompts that work in any of the sidebars:
In a new column F on the Orders tab, show the order total in USD. Use the rate on the Rates tab that matches the order date in column B. If no rate exists for that date, leave the cell blank and highlight it.
Explain how the total in H42 is calculated, step by step, and list any hardcoded numbers in its formula chain.
Find out why the lookup on the Summary tab returns #N/A for some rows and fix it without changing any other formula.
Running a prompt down a whole column in Sheets
For text jobs across many rows, such as categorizing feedback or tagging leads, Google Sheets has an AI function. Type =AI() or =Gemini() with a prompt and an optional range, select the cells, and click Generate and Insert 10. Google's own example:
=AI("Generate slogan for event in 10 words or less", A2)
It generates the first 350 selected cells at a time, returns text only, and cannot sit inside another formula such as IF. It also sees only the range you pass, not the rest of your spreadsheet 10.
Analyzing data
For questions about data already in a workbook, use the sidebar in the app you work in. For loose CSVs, exports and PDFs, a separate analysis tool is faster.
- Copilot in Excel answers questions about your data, sorts, filters, applies conditional formatting, and builds charts and PivotTables with editable links to the source. It can also pull data from other workbooks on OneDrive, SharePoint or your computer 1.
- ChatGPT for Excel and Sheets summarizes trends across tabs, runs scenarios and sensitivity tables, and can search the web for data to pull in. Its help page asks you to review changed cells and duplicate important files before big edits 7.
- Claude for Excel traces assumptions through a model and flexes inputs while keeping formula links intact, so dependent cells recompute. It also edits pivot tables and adds data validation 8.
- Gemini in Sheets builds tables, formulas, charts and pivot tables from the side panel. Its charts do not update when the source data changes, and it works best on native Google Sheets files, not uploaded Excel files 11.
- Julius takes uploaded files or connected sources, answers questions with charts, and builds reports and dashboards from the results 13.
Tip: start every new workbook with read-only questions on a file where you already know the answers, such as last month's report. You find out how the tool reads your work before you let it change anything.
A self-checking monthly close
Drafting and sorting are jobs where a person reads the output anyway. Adding up last month's revenue is different: a total nobody traces back to the bank statement is a total nobody checks. This workflow makes every number point to its source, so checking takes minutes instead of an afternoon. It takes about twenty minutes the first time and needs no code.
Why consistency matters more than price here: in The New Stack's test, each model ran three hard business and coding tasks five times 14.
Sol's misses were the quiet kind: two runs left the same customer off a refund list, and one counted 27 failed checkouts instead of 28 14. In a close, those are exactly the errors that get through. Use the most consistent model you have for this job, and keep the trace column whichever you use.
- Pick one number you act onRevenue is the easiest start. Choose a figure where a 4% error would change a decision and you would not notice it.
- Export the sourcesLast month's bank statement, payment processor payouts and invoice list, as CSV. Delete account numbers and anything you would not want outside your computer.
- Ask for a three-tab reconciliationOpen a fresh chat or an empty workbook with Claude, ChatGPT or Copilot, attach the files, and paste the prompt below.
- Trace five numbers by handPick five figures on the summary tab and follow each back to the row in the original file. This is the real check. If one does not match, you caught it before it cost anything.
- Read the exceptions tabA payout that lands a day after the sale is a normal timing gap. An invoice with no matching payment is money someone owes you.
- Run it again from scratchRepeat the same request in a new chat. Same totals and same exceptions mean you have a monthly process. Different results mean your request left room for interpretation; tighten it and run both again.
Reconcile [month] revenue across the attached files and build a workbook with three tabs. Tab 1, Matched: one row per matched transaction, with columns that name the source file and row number for each side. Tab 2, Exceptions: every item found in one file but not another, with the most likely reason. Tab 3, Summary: one page of totals where every figure is a formula pointing to Tab 1 or Tab 2. Never estimate or fill in a missing value. Put it on Tab 2 instead.
Once the close repeats cleanly, write three standing rules into your instructions so every month starts the same way: every number names its file and row; anything that does not reconcile goes on the exceptions list, never forced to fit; missing data is flagged, never estimated. Claude for Excel has an Instructions field in its settings that applies to every conversation in Excel 8; in ChatGPT, a Skill can hold the same playbook 7.
Keep a person on it: anything that touches money stays supervised, even after months of clean runs. Anthropic itself says Claude for Excel is not recommended for audit-critical calculations without verification 8, and OpenAI says ChatGPT is not a financial, legal or tax advisor 7.
Tools compared
ChatGPT for Excel and Google Sheets
Best all-rounderOne add-in for both spreadsheet apps, on every ChatGPT plan. It builds budgets and trackers from scratch, explains unfamiliar models, fixes broken formulas and runs scenario tabs, and it asks permission before changing the workbook. It went generally available on 5 May 2026 6. On desktop, Codex in the ChatGPT app can also work with an open Excel workbook through the add-in.
- Plans
- Free and Go with limited use; Plus and Pro within the agentic usage limit; Business and Enterprise on credits 7
- Install
- Excel: Home, Add-ins, search ChatGPT. Sheets: Google Workspace Marketplace, then Extensions
- Limits
- No ChatGPT memory; VBA and macros may not be fully supported
Claude for Excel
Best for checking modelsClaude for Excel is built for model work: it explains how a number was derived with clickable cell citations, updates assumptions while keeping formula relationships intact, and finds the root cause of #REF! and #DIV/0! errors. It shares context with Claude for Word, PowerPoint and Outlook. Anthropic warns that files from outside sources can carry hidden instructions, so use it on trusted workbooks.
- Plans
- Claude Pro, Max, Team and Enterprise; generally available 8
- Runs on
- Excel on the web, Windows (Microsoft 365) and Mac; not iPad or Android
- Limits
- No data tables, macros or VBA
Copilot in Excel
Best if you pay for Microsoft 365Copilot is already in Excel for many Microsoft 365 subscribers. It has three modes: Allow editing for multi-step changes, Plan to propose changes for your approval, and Chat only for analysis without edits. It builds charts and PivotTables, imports data from other workbooks, and supports custom skills for repeat tasks 1. Editing needs calculation set to Automatic 2.
Gemini in Google Sheets
Best for running a prompt down a columnGemini works two ways in Sheets: the side panel builds tables, formulas, charts and pivot tables and applies edits through a preview card you approve 11, and the =AI() function runs a prompt across many rows 10. Side-panel history disappears when you reload, and its charts do not follow later data changes.
Claude for Google Workspace
Best for building a Sheets reportLaunched in public beta on 6 October 2026, this add-on puts Claude in a sidebar in Sheets, Docs and Slides. In Sheets it writes formulas, builds pivot tables and native charts, adds tabs, and for joins or cleanup pulls a range into Python and writes the results back. The default mode shows each change as an approval card; "Accept all edits" runs the whole task without stopping 9.
- Plans
- All paid Claude plans, in beta
- Access
- Matches your existing Google sharing permissions
- Best for
- Monthly client reports rebuilt from raw exports
Julius
Best for files outside a spreadsheetJulius is a separate AI workspace for data: upload spreadsheets and files, ask questions, and get charts, reports and presentations back. Paid plans use top models such as GPT-6.1 Sol and Claude Opus 5.5, and Business adds connectors for Postgres, BigQuery and Snowflake. Use it when the data lives in exports and warehouses rather than one workbook.
- Free plan
- Daily credits on Julius Lite models
- Price
- Plus $20 a month, 2,000 credits; Pro $45; Business $450 13
- Connectors
- Google Drive, OneDrive and SharePoint on every plan
Which one for your situation
| Your situation | Pick | Why |
|---|---|---|
| Excel, already on Microsoft 365 with Copilot | Copilot in Excel | Already paid for; Plan mode before edits |
| Excel and Sheets, one tool for both | ChatGPT for Excel | Same add-in in both apps, every ChatGPT plan |
| Financial models where numbers must hold | Claude for Excel | Cell citations; keeps formula links intact |
| Tagging or summarizing 300 rows of text | Gemini =AI() | One prompt across a column |
| Client report in Google Sheets each month | Claude for Google Workspace | Builds tabs, pivots and charts with approval |
| Loose CSVs and database exports | Julius | Upload, ask, chart |
To choose between the two chat apps behind these add-ins, see ChatGPT vs Claude. For more on the Claude side, see how to use Claude; for Google's, how to use Gemini.
How we chose
We included tools that work inside Excel or Google Sheets, plus one standalone analysis tool for data that does not live in a workbook. We compared them on where they run, which plan you need, whether they ask before editing, and their known limits. Every fact comes from Microsoft's, OpenAI's, Anthropic's, Google's and Julius's own help, pricing and announcement pages, opened on 23 October 2026; the accuracy figures come from The New Stack's published test. The monthly close workflow and prompts are the ones we have taught newsletter readers. We have not run our own side-by-side accuracy test of the add-ins, so this page does not rank them on accuracy.
Questions people ask
Can ChatGPT work in Excel?
Yes. ChatGPT for Excel is an add-in that runs in a sidebar in Excel on desktop and web, and a version exists for Google Sheets. It is available on every ChatGPT plan, with limited use on Free and Go.
What is the best AI for Excel?
If your company already pays for Copilot, start there. Otherwise ChatGPT for Excel is the broadest option, and Claude for Excel is the stronger pick for checking and updating financial models, because its answers cite the exact cells.
Is there a free AI for Excel?
ChatGPT for Excel works on the Free plan with limited use. Julius has a free plan for uploaded files. Copilot in Excel and Claude for Excel need paid plans.
Can AI write Excel formulas?
Yes. All the tools here write formulas from a plain-English description, and ChatGPT, Claude and Copilot also explain and fix existing ones. Check one row by hand before you fill a formula down.
Does Google Sheets have AI?
Yes. Gemini in Sheets builds tables, formulas and charts from a side panel, and the =AI() function runs a prompt across many cells. Both need an eligible Workspace or Google AI plan.
Related
Know when your stack changes
195,000 readers get Uncover AI's practical AI briefing. We flag new tools, price changes and the deals worth taking.
Sources
- Microsoft Support: Get started with Copilot in Excel
- Microsoft Support: Copilot in Excel FAQ
- Microsoft Support: COPILOT function
- Microsoft 365 plans compared (consumer)
- Microsoft 365 Copilot for business pricing
- OpenAI: Introducing ChatGPT for Excel (with May 2026 update)
- OpenAI Help: ChatGPT for Excel and Google Sheets
- Claude docs: Use Claude for Excel
- Anthropic: Claude now works with Google Docs, Sheets and Slides (6 Oct 2026)
- Google Sheets Help: the AI function
- Google Sheets Help: Collaborate with Gemini in Sheets
- Google Workspace pricing
- Julius pricing
- The New Stack: GPT-6 Sol vs Claude Opus 5.5
- Google AI plans