Uncover AIGuides
  1. Guides
  2. Best of
  3. AI for Excel
Best of · Spreadsheets

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.

Founder, Uncover AI
Updated 6 tools, facts from vendor help pages

Nobody paid to appear on this page, and we earn nothing from the links on it.

Logos are trademarks of their owners. Initials stand in where no logo is available to us.

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.

Where each tool runs and what you need, from vendor help pages, checked 23 Oct 2026.
ToolExcelGoogle SheetsPlan you needAsks before editing
ChatGPTYes, desktop and webYesAny ChatGPT plan; Free and Go are limited 7Yes 6
ClaudeYes: web, Windows, MacYes, separate add-on in beta 9Claude Pro, Max, Team or Enterprise 8Confirms risky operations; warns before overwriting
CopilotYes: Windows, Mac, web; chat only on phonesNoMicrosoft 365 Premium, Personal or Family with AI credits, or a business Copilot license 2Plan mode proposes first 1
GeminiNoYesWorkspace Standard or higher, or a Google AI plan 12Action preview card first 11
JuliusUpload filesGoogle Drive connectorFree, or Plus at $20 13Does 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.

  1. Describe the result, not the formulaSay what you want the column to show and which columns feed it. The tool picks the function.
  2. Name the rangePoint to the sheet and columns. ChatGPT lets you @-mention specific sheets to focus the request 7.
  3. 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.
  4. 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.

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.

15 of 15runs perfect, Claude Opus 5.5
12 of 15runs perfect, GPT-6 Sol
$2.68 vs $16.72total cost of Sol's 15 runs vs Opus 5.5's

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.

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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-rounder

One 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 models

Claude 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
Co

Copilot in Excel

Best if you pay for Microsoft 365

Copilot 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.

Personal
Microsoft 365 Personal $9.99 a month or $99.99 a year; Premium $19.99 a month 4
Business
Copilot Business add-on $21 per user a month, paid yearly; $18 for the first year on orders through 31 Dec 2026 5
Requires
On personal plans, files saved to OneDrive with AutoSave on 4

Gemini in Google Sheets

Best for running a prompt down a column

Gemini 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.

Workspace
Gemini in Sheets on Business Standard, Plus and Enterprise; not on Starter 12
Personal
Google AI Pro and Ultra include help in Docs and Sheets 15
Limits
=AI() returns text only, 350 cells per run, and cannot be nested

Claude for Google Workspace

Best for building a Sheets report

Launched 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
Ju

Julius

Best for files outside a spreadsheet

Julius 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 situationPickWhy
Excel, already on Microsoft 365 with CopilotCopilot in ExcelAlready paid for; Plan mode before edits
Excel and Sheets, one tool for bothChatGPT for ExcelSame add-in in both apps, every ChatGPT plan
Financial models where numbers must holdClaude for ExcelCell citations; keeps formula links intact
Tagging or summarizing 300 rows of textGemini =AI()One prompt across a column
Client report in Google Sheets each monthClaude for Google WorkspaceBuilds tabs, pivots and charts with approval
Loose CSVs and database exportsJuliusUpload, 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.

About the authorFounder, Uncover AI

Anthony Chebat is the founder of Uncover AI and writes the Uncovering AI newsletter, read by more than 195,000 people. He has written about AI tools in the newsletter since 2023. Every guide here is checked against the vendors' own pricing and help pages and updated when plans or models change.

Anthony on LinkedIn

Sources

  1. Microsoft Support: Get started with Copilot in Excel
  2. Microsoft Support: Copilot in Excel FAQ
  3. Microsoft Support: COPILOT function
  4. Microsoft 365 plans compared (consumer)
  5. Microsoft 365 Copilot for business pricing
  6. OpenAI: Introducing ChatGPT for Excel (with May 2026 update)
  7. OpenAI Help: ChatGPT for Excel and Google Sheets
  8. Claude docs: Use Claude for Excel
  9. Anthropic: Claude now works with Google Docs, Sheets and Slides (6 Oct 2026)
  10. Google Sheets Help: the AI function
  11. Google Sheets Help: Collaborate with Gemini in Sheets
  12. Google Workspace pricing
  13. Julius pricing
  14. The New Stack: GPT-6 Sol vs Claude Opus 5.5
  15. Google AI plans