10 min read
Most people meet claude for excel twice: once when they read what it can do, and once when the add-in refuses to appear in their ribbon. This guide covers both, and it leads with the second, because that is where nearly everyone gets stuck.
The short answer
You need a paid Claude plan. Pro ($20/month) is the cheapest that works. A free Claude account will not run it.
You need a Microsoft 365 subscription build. Excel 2016 and 2019 perpetual licences cannot load it, and neither can iPad or Android.
It cannot do macros or VBA. Anthropic lists both as unsupported. So are data tables.
If the add-in installed but will not sign in, that is usually the plan, the Excel build, or your Microsoft account — in that order.
That is the practical summary. Below is what Anthropic actually documents, the limits it publishes but most coverage skips, and one requirement the guides flatly contradict each other on.
What Claude for Excel Actually Is
It is an add-in, not a chatbot you paste cells into. Anthropic’s documentation introduces it in two sentences: “Claude for Excel is an add-in that brings Claude into Excel. Ask questions about open workbooks, adjust assumptions while preserving formula relationships, debug errors, and build or populate models, all without leaving Excel.”
That distinction matters more than it sounds, and it is the single most common source of confusion in older articles. Plenty of “Claude vs Copilot for Excel” comparisons were written before the add-in existed, when using Claude for spreadsheet work meant copying data into the chat window and pasting formulas back. Those pieces are comparing a different product. Check the date on anything you read about the Claude for Excel add-in — if it predates late 2025, it is probably not describing the add-in at all.
Which Plans Include Claude for Excel
Anthropic’s documentation states it is “generally available to Pro, Max, Team, and Enterprise plans.” The free tier is not on that list.
| Plan | Price | Runs the add-in? |
|---|---|---|
| Free | — | No |
| Pro | $20/month, or $17/month billed annually ($200 up front) | Yes — cheapest option |
| Max | From $100/month | Yes |
| Team | Standard seat $20 per seat/month billed annually ($25 monthly); premium seats $100/$125 | Yes |
| Enterprise | $20/seat plus usage at API rates | Yes |
Prices are from Anthropic’s own pricing page. If you only want the spreadsheet add-in, Pro at $20 is the entry point and nothing cheaper unlocks it.
One correction worth making, because it is still repeated: earlier coverage described Claude for Excel as a research preview limited to Max, Team and Enterprise. That was accurate when written. It is not accurate now — Pro is included, and the product is generally available rather than in preview.
The Excel Versions That Cannot Run It
This is where most failed installs come from, and Anthropic publishes the list plainly. Supported builds are Excel on the web, Excel on Windows with a Microsoft 365 subscription on build 16.0.13127.20296 or later, and Excel on Mac, version 16.46 or later, build 21011600 or later.
The unsupported list is the useful half:
- Excel 2016 and 2019 perpetual or volume licence. A one-off purchase of Office will not run it, however current your Excel feels.
- Excel on iPad. Anthropic explains why: “The add-in requires SharedRuntime support, which iPad does not provide.”
- Excel on Android.
- Older Microsoft 365 builds below the SharedRuntime threshold.
If you bought Office once rather than subscribing, that is almost certainly your answer, and no amount of reinstalling will change it.
A one-off purchase of Office will not run the add-in, however current your Excel feels.
The Microsoft Account Question Nobody Agrees On
Here the sources genuinely conflict, and we would rather say so than pick a side.
A community moderator answering an installation failure on Microsoft Q&A in April 2026 wrote: “Claude installs only when Excel is signed into a personal Microsoft 365 account, not a leftover work or school account, which can silently block Office Store add-ins.”
A troubleshooting guide on aiawareness.ai, published in July 2026, says the opposite — that you need a work or school Microsoft 365 account and that personal Outlook.com addresses will not do.
Anthropic’s own documentation does not resolve it. It specifies Excel builds and Claude plans, and says nothing about which type of Microsoft account you must be signed in with.
What both sources agree on is the underlying mechanism, and that is the part you can act on: Office Store access can be silently blocked by the account Excel is signed into. If your install is failing and your plan and build both check out, sign out of Excel entirely and sign back in with your other Microsoft account. Which one is “correct” appears to depend on how your organisation is configured, which is exactly why the guides disagree.
What Claude for Excel Cannot Do
Anthropic publishes a limitations section, and it is short enough that leaving it out of a review is a choice rather than an oversight.
Unsupported outright: data tables, and macros and VBA operations.
That second one deserves emphasis. If your workbook’s real logic lives in VBA, the add-in cannot touch the part that matters.
One clarification, because the terms are easy to confuse. The unsupported item is Excel’s Data tables — the What-If Analysis feature — not pivot tables. Pivot tables are explicitly supported: Anthropic lists editing them among the native operations Claude can perform.
A specialist Excel consultancy writing during the earlier research-preview period made a related but softer point, about review rather than capability: “Complex or specialised models may still require full manual oversight, especially those reliant on macros, PivotTables and VBA (Visual Basic for Applications).” That is advice to check the output carefully, not a second source confirming what the add-in cannot operate on.
Not recommended for, in Anthropic’s own framing: final client deliverables without human review, audit-critical calculations without verification, and models containing highly sensitive or regulated data without proper controls.
Anthropic publishes no row limit or file size cap, and we could not find an official figure anywhere. One practitioner guide advises “Don’t drop 50,000 rows into a prompt. Give samples, then apply formulas locally” — sensible practice, but it is a recommendation rather than a documented threshold, and we found no official figure for either.
The Security Warning Most Reviews Skip
Anthropic ships a prompt-injection warning with this product, and it is unusually direct: “Only use Claude for Excel with trusted spreadsheets. Files from external sources can contain hidden instructions that manipulate the add-in into extracting data, modifying records, or performing destructive actions.”
This is not hypothetical hand-waving. The documentation states that “Testing has identified scenarios where Claude for Excel can be manipulated to extract sensitive information, modify critical data, or perform destructive actions if allowed to act without verification.”
The practical rule: a downloaded template, a vendor file or a data import is untrusted input. Claude asks you to confirm risky operations — read those confirmations rather than clicking through them, particularly on files you did not create.
What It Is Genuinely Good At
The capability list is real, and the cell-level citations are the feature that distinguishes it from pasting data into a chat window. Anthropic documents that answers “include cell-level citations you can click to navigate to the referenced cell” — so you can audit where a number came from instead of trusting a summary.
The documented strengths worth knowing:
- Tracing a model you did not build. Asking how the figure in a given cell was derived, and following the citation back.
- Changing assumptions without breaking formulas. Updating values so dependent cells recompute correctly.
- Debugging. Finding the root cause of a
#REF!or#DIV/0!rather than just flagging it. - Native operations. Sorting, filtering, editing pivot tables, conditional formatting and data validation dropdowns.
It also handles long sessions with auto-compaction, and warns before overwriting existing data.
Installing Claude for Excel
For an individual, Anthropic’s documented route is three steps: open the Claude for Microsoft 365 listing on Microsoft AppSource, select “Get it now” to install, then open Excel, activate the add-in, and sign in with your Claude account.
For organisations, an admin deploys it through the Microsoft 365 Admin Center, and Office Store access must be enabled first under Settings, Org Settings, User owned apps and services.
There is one documented gotcha for admins that is easy to lose hours to. If your organisation uses Microsoft Entra Privileged Identity Management, Anthropic notes that “the Integrated apps page does not recognize roles activated through PIM, so deployment fails.” It is a known Microsoft issue with a tracking ID, and the workaround is to deploy from an account whose role is permanently active rather than PIM-eligible.
Claude for Excel FAQ
Is Claude for Excel free?+
No. The add-in requires a paid plan — Pro, Max, Team or Enterprise. Claude Pro at $20 per month (or $17 per month billed annually) is the cheapest tier that runs it. A free account is not on Anthropic’s supported-plan list, and a community moderator on Microsoft Q&A reports that such accounts may install the add-in but then fail to activate properly.
Why is Claude for Excel not showing up in my ribbon?+
Three causes account for most cases, in order of likelihood: you are on a free Claude plan, you are running a perpetual Excel licence such as 2016 or 2019 rather than a Microsoft 365 subscription build, or Excel is signed into a Microsoft account whose settings block Office Store add-ins. Check them in that order before reinstalling.
Does Claude for Excel work with macros and VBA?+
No. Anthropic lists macros and VBA operations as unsupported, along with data tables. If the logic you need help with lives in VBA, this add-in cannot reach it.
Does it work on iPad?+
No, and the reason is technical rather than temporary. Anthropic states the add-in requires SharedRuntime support, which iPad does not provide. Excel on Android is unsupported too. Excel on the web does work.
Is there a row or file size limit?+
Anthropic publishes no row limit or file size cap for the Claude for Excel add-in, and we could not find an official figure. Practitioner guidance suggests working from samples rather than pasting tens of thousands of rows into a prompt, but treat that as practical advice rather than a documented threshold.
Is it safe to use on spreadsheets I downloaded?+
Treat those as untrusted. Anthropic warns that files from external sources can carry hidden instructions that manipulate the add-in, and says its own testing found scenarios where it could be pushed into extracting or destroying data if allowed to act without verification. Review every confirmation prompt on files you did not create.
Claude for Excel or Copilot for Excel?+
They are priced and positioned differently, and much of the published comparison is out of date because it predates the add-in. Copilot is built into Excel by Microsoft; Claude arrives as an add-in on a paid Claude plan. If your work depends on macros, VBA or data tables, note that Claude documents those as unsupported.
Your Next Step
Before you buy anything, check two things that cost nothing: whether your Excel is a Microsoft 365 subscription build rather than a perpetual licence, and whether your workbook’s real logic sits in VBA. Those two facts decide whether the add-in can help you at all, and both are knowable in about a minute.
If you clear both, Claude Pro at $20 is the cheapest way in, and Excel on the web is the fastest place to test it without touching your desktop install.
For how Anthropic’s tools compare elsewhere, see our AI coding tools hub and our guide to the best AI for coding. Anthropic’s own Claude for Excel documentation is the primary source for the plans, supported builds and limitations quoted above.
Continue reading
