What is Claude for Excel, and what does it do?
Claude for Excel, also called Claude in Excel or the Claude Excel add in, is a sidebar that lets Claude read your open workbook and answer in the grid. Paste this into it and fill the brackets.

Read the workbook I have open. On the [sheet name] tab, explain how [cell, such as C42] is calculated. List every cell it depends on, say which are typed numbers and which are formulas, and cite each cell. Don't change anything. Then name the three assumptions that move it most and what I should check by hand before I rely on it.
Anthropic's own page says you can ask questions about a workbook and get answers with cell level citations, adjust assumptions while keeping formula relationships intact, find and resolve errors, generate new models or populate templates, work across tabs, and pull outside data through connectors such as S&P Global, LSEG and Daloopa. It also applies Skills you have switched on. Our guide to Claude Skills covers those.
Three smaller features matter in daily use. A Settings field lets you set persistent instructions for Excel, such as number formats or always bolding headers. Claude warns you before overwriting existing data, and long chats are compacted automatically. It also shares context with Claude for PowerPoint, Word and Outlook, so one conversation can span a workbook and a deck.
It isn't a different model from the one in the Claude app. Anthropic says the add in offers a curated subset of Claude models, the ones that work best for Office tasks, so the list can be shorter than in the app.
Which Claude plans include Claude for Excel?
Claude for Excel is generally available to Pro, Max, Team and Enterprise plans, and the Free plan does not include it, as of November 2026. Anthropic's Excel page states the first part, and its pricing page shows Claude for Microsoft 365 as No on Free and Yes on Pro and Max.
The add in launched on 27 October 2025, when Anthropic wrote that it was "in beta as a research preview for Max, Enterprise, and Teams users". Guides written that winter often repeat that. Today's page says generally available, and DataCamp's January 2026 guide still calls it beta and names only Pro and Max, so trust the vendor page over a dated summary.
Cost is the plan, not the add in. Anthropic lists Pro at $20 a month, or $17 a month billed annually at $200 up front, and Max at $100 a month. Your use of the add in counts against the same usage limits as your Claude account. Team standard seats are $20 a seat a month billed annually, or $25 billed monthly. Enterprise starts at $20 a seat a month billed annually with a 20 seat minimum, plus usage at API rates.
How do you install Claude for Excel?
You install it from Microsoft AppSource, then sign in with your Claude account. Anthropic's page gives three steps for yourself: open the Claude for Microsoft 365 listing on AppSource, select Get it now, then open Excel, activate the add in and sign in.
The versions it supports are Excel on the web, Excel on Windows with a Microsoft 365 subscription (build 16.0.13127.20296 or later) and Excel on Mac, version 16.46 or later. That answers the Mac question: yes, on a recent build. After install, open it from Tools, Add ins on Mac or Home, Add ins on Windows.
It doesn't run on Excel 2016 or 2019 perpetual or volume licences, Excel on iPad, Excel on Android, or older Microsoft 365 builds. Anthropic gives the iPad reason: the add in needs SharedRuntime support, which iPad lacks. Google Sheets is not on the supported list either.
Admins can deploy it to a whole organisation from the Microsoft 365 Admin Center. Anthropic also documents a custom manifest for tenants where the Office Store is turned off, and a route through Amazon Bedrock, Google Cloud Vertex AI, Azure AI Foundry or an LLM gateway that needs no individual Claude accounts.
What are three real jobs for Claude for Excel?
These three examples were written for this page. They show the prompt and what a good answer must contain, not a tested output from any model.
- Trace an inherited number. Prompt: "On the Summary tab, walk me through how the revenue figure in C42 is calculated. Cite every cell it uses and flag anything typed in by hand instead of calculated." A good answer names each upstream cell with a clickable citation, separates formulas from hardcoded values, and notes any cell on another tab. If it names a cell that is empty, it misread the file.
- Flex an assumption. Prompt: "Change the discount rate in Assumptions!B4 from 10% to 8%. Keep every formula. Then tell me which output cells changed and by how much." A good answer edits only B4, leaves the formulas alone, and lists the before and after for the outputs that moved. Anthropic says Claude updates values while keeping formula relationships intact, so a changed formula is a red flag.
- Find an error. Prompt: "The Summary tab shows #REF! in H15. Find the root cause, explain it in two sentences and propose the fix before you apply it." A good answer points to the deleted or moved reference, says what it was pointing at, and waits for you to approve the change. Anthropic's own example for this job is "Find the source of the #REF! error in the summary tab."
What are the best prompts for Claude for Excel?
A good prompt names the tab, the range and the outcome, and tells Claude what it must not touch. These twelve are grouped by job, and each works as written once you fill the brackets. The first is the template above.
Understand a model:
- "Summarise what the [tab name] tab is for in five lines, then list which other tabs feed it."
- "Which assumptions drive the gross margin forecast on [tab]? Rank them and cite the cells."
- "Explain the formula in [cell] in plain English, one clause per function."
Change it safely:
- "Flex the growth rate in [cell] from [x]% to [y]% in steps of one point. Show the effect on [output cell] in a small table on a new tab. Leave the original untouched."
- "Add a column to [range] that flags rows where [condition]. Use a formula, not typed values, and show me one example row first."
Fix and clean:
- "List every error value on [tab], group them by cause and propose one fix per group. Don't apply anything yet."
- "Find rows in [range] with a duplicate [column]. Mark them with a helper column. Don't delete."
- "Standardise the date format in [column] to [format] and tell me which cells were not valid dates."
Build:
- "Build a monthly budget on a new tab with categories [list], an income line of [amount] and a variance column. Use formulas throughout."
- "Using the trial balance on [tab], set up the layout of a simple income statement. Label every line and show which accounts feed it."
Present and document:
- "Add conditional formatting to [range] so values below [number] show in red. Tell me the rule you created."
- "Write a short note for the next person who opens this file: the tabs, the inputs, the outputs and the three cells they should never overwrite."
Is Claude for Excel better than Copilot or ChatGPT in Excel?
No tool wins on every job, and the tools differ most on what they cost and where they run. The table lists what each vendor states on its own page, read on 22 November 2026, with the Free Claude plan and Whizi added for readers who don't have a paid add in.
| Tool | Free use | Paid price | Where it runs | Best at |
|---|---|---|---|---|
| Claude for Excel | None, the pricing page marks it No on Free | Pro $20 a month, or $17 billed annually; Max $100 a month; Team $20 a seat annual or $25 monthly; Enterprise $20 a seat annual, 20 seat minimum plus API rate usage | Excel on the web, Windows and Mac | Tracing and editing a workbook with cell citations |
| Claude Free, no add in | Search the web, create files and run code | $0 | The Claude app | Making a new .xlsx file from a description |
| ChatGPT for Excel | Free and Go include "limited usage access" | Not stated on the help page | Excel on desktop or the web | Building trackers and templates, with web search |
| Copilot in Excel | Not stated | Business add on $18 a user a month paid yearly, or $25.20 monthly | Inside Microsoft 365 apps | Everyday work in the grid |
| Whizi | 10 messages a day on Whizi AI, Auto and Claude Haiku, no card | Pro $29.99 a month | A browser chat, not inside Excel | Reading an uploaded .xlsx and making a new one in chat |
Whizi loses on the main point. It has no sidebar inside Excel, so it can't edit your open workbook in place and keep the formulas live. Claude for Excel and ChatGPT for Excel can. The Copilot figure is the Business add on from Microsoft's pricing page, which footnotes a first year discount on the yearly price between 1 July and 31 December 2026, and the same page says Copilot in Microsoft 365 apps comes with a Personal or Family subscription without giving a price.
OpenAI's help page says ChatGPT for Excel is available to Free, Go, Plus, Pro, Business, Enterprise, Edu and K-12 users, with Plus and Pro "subject to your plan's agentic usage limit". For a closer look at that add in, read ChatGPT for Excel. For the wider field, see Excel AI.
DataCamp's January 2026 comparison frames Claude as the better fit for explaining logic and Copilot as the quicker inline helper. That is one site's opinion, not a benchmark.
Why is Claude for Excel not working?
The most common causes are a plan without access, an unsupported Excel build, and a Microsoft 365 update that wiped local history. Check them in that order.
- You are on the Free plan. Anthropic lists the add in for Pro, Max, Team and Enterprise only. Sign in with an eligible account.
- Your Excel is too old or on the wrong device. Excel 2016 and 2019, iPad and Android are unsupported, and Windows needs build 16.0.13127.20296 or later.
- The add in is blocked at work. Admins can control it through the Microsoft 365 Admin Center, and a tenant that disables the Office Store needs the custom manifest instead.
- Your chat history or uploaded skills vanished. Anthropic's page says that after the September and October 2026 Microsoft 365 updates on Windows, some users are missing chat history and uploaded skills, and that Anthropic is working with Microsoft on it.
- An admin used Privileged Identity Management. Anthropic notes that deployment fails for PIM activated roles, a known Microsoft issue, and the workaround is an admin account with the role permanently active. Individual users can still install it themselves.
Chat history is stored locally in your browser (IndexedDB), not in your account. Anthropic says it isn't synced across devices, and clearing it removes only the local copy, not what Anthropic keeps.
What mistakes ruin results in Claude for Excel?
Four mistakes cause most bad edits, and each has a quick fix.
- Asking for a vague change on a big workbook. The fix: name the tab, the cell and the outcome, and say what not to touch.
- Letting it edit before you understand it. The fix: ask it to explain first, click the cell citations, and only then approve a change.
- Opening a file from a stranger. The fix: don't. Anthropic warns that external files can carry hidden instructions that manipulate the add in into extracting data, changing records or doing something destructive.
- Trusting a number you didn't rebuild. The fix: recompute one output by hand. The data analysis newsletter Data Analysis Journal said in April 2026 that the tool can overcomplicate formulas and be inconsistent on multi step requests, which is why a spot check matters.
A fifth is expecting it to run macros. Anthropic lists macros and VBA operations as unsupported, and data tables too. If the workbook depends on them, do that part yourself.
What can Claude for Excel not do?
It can't do data tables, macros or VBA, and Anthropic says not to rely on it alone for final client deliverables, audit critical calculations or highly sensitive data. Those are the vendor's own words: it is "not recommended for" final client deliverables without human review, audit critical calculations without verification, and models containing highly sensitive or regulated data without proper controls.
The security warning is blunt: "Only use Claude for Excel with trusted spreadsheets." Anthropic says its testing found cases where the add in could be manipulated into extracting sensitive information, modifying critical data or performing destructive actions if allowed to act without verification. It asks you to confirm risky operations, so read those prompts.
Your data does leave the workbook. When you sign in directly, the add in sends your conversation to Anthropic, including the content Claude reads from your workbook and any files you attach, and inputs and outputs are deleted on the backend within 30 days, with exceptions. It also doesn't inherit custom retention settings your organisation has set, and its activity isn't in Enterprise audit logs.
On PivotTables, sources disagree. Anthropic says Claude can edit pivot tables. DataCamp's January 2026 guide says it can guide you through making one but does not create one itself. Ask for the specific change you want and check the result.
Where does Whizi fit if you want Claude and Excel?
Whizi is one app instead of a pile of single purpose tools, and it fits when you want Claude on a spreadsheet without installing an add in. You can upload an .xlsx and ask about it, and Whizi reads Word, Excel and PDF uploads, with a vision pass for scanned PDFs. Older .xls files need a re save as .xlsx first.
Excel files made in chat have no plan gate, so a free account can ask for a budget or a tracker and download a real .xlsx. The free plan gives you 10 messages a day on Whizi AI, Auto and Claude Haiku, with no card. Pro carries Claude, GPT and Gemini in one app, its first week is $1.99, and side by side Compare puts two models on one prompt. Web search is on by default per chat.
It is a different job from Claude for Excel. Whizi won't trace precedents inside your live workbook or edit your open file in place. Use it to draft a model, check a formula you paste in, or ask a second model whether it agrees. See Whizi pricing for what each plan holds.
- Confirm your Claude plan is Pro, Max, Team or Enterprise before you install
- Check your Excel build against the supported versions, and skip iPad and Android
- Work on a saved copy of the workbook, never your only version
- Open only trusted files, because external ones can carry hidden instructions
- Rebuild one output by hand before you rely on the result
Frequently asked questions
Is Claude for Excel free?
No. Anthropic lists Claude for Excel for Pro, Max, Team and Enterprise plans, and its pricing page marks Claude for Microsoft 365 as No on Free, as of November 2026. Pro costs $20 a month, or $17 a month billed annually. The Free plan can still create files and run code in the Claude app.
How do I add Claude to Excel?
Install Claude for Microsoft 365 from Microsoft AppSource, then open Excel, activate the add in and sign in with your Claude account. It needs Excel on the web, Windows build 16.0.13127.20296 or later, or Mac version 16.46 or later. iPad and Android are not supported.
Does Claude for Excel work on a Mac?
Yes, on Excel for Mac version 16.46 or later, build 21011600 or later, according to Anthropic's Excel page. Open it from Tools, Add ins after you install it from AppSource. Excel for iPad and Android are the unsupported devices.
Can Claude for Excel run macros or VBA?
No. Anthropic lists macros and VBA operations as unsupported, along with data tables. It can sort, filter, edit pivot tables, apply conditional formatting and create dropdowns. Test a copy of any workbook that depends on macros before you rely on the add in.