Claude for Excel: Setup, What It Does and Its Limits
Claude for Excel is Anthropic's add-in that puts Claude in a sidebar inside Excel, where it reads your workbook, explains formulas, fixes errors and builds models with you. It is now part of one add-in called Claude for Microsoft 365, which also covers PowerPoint, Word and Outlook.
Claude for Excel is generally available on paid Claude plans (Pro, Max, Team and Enterprise), not the free plan. Install Claude for Microsoft 365 from Microsoft Marketplace, open Excel, activate it and sign in. It works on Excel on the web, Windows and Mac, cites the cells it uses, and does not run macros, VBA or data tables.
Every fact below comes from Anthropic's Claude for Excel docs and Microsoft 365 page, checked on November 20, 2026.
What Claude for Excel does
Excel
PowerPoint
Word
Anthropic's docs list what it does inside a workbook:
- Answers with cell citations. Ask a question and the answer links to the exact cells it used. Click one and Excel jumps there.
- Explains formulas. "Walk me through how the revenue number in cell C42 is calculated" gets you the chain of assumptions behind it.
- Changes assumptions without breaking formulas. It updates values while keeping formula relationships intact, and marks the cells it changed.
- Finds and fixes errors. It traces a
#REF!or a wrong total back to the root cause. - Builds models and fills templates. Anthropic's own example: build a three-statement model from a trial balance.
- Uses Excel's own tools. Sort, filter, edit pivot tables, apply conditional formatting and create dropdowns.
- Warns before overwriting. It checks before writing over existing data.
You can also drop a PDF or document into the sidebar, such as a supplier price list, and ask Claude to work it into the sheet. And because the add-in is shared across Microsoft 365, one conversation can carry from Excel into a PowerPoint deck or a Word report.
How to install Claude for Excel
- Check your plan. You need a paid Claude plan: Pro, Max, Ultra, Team or Enterprise.
- Check your Excel. Excel on the web, Excel on Windows with a Microsoft 365 subscription, or Excel on Mac (version 16.46 or later).
- Get the add-in. Open the Claude for Microsoft 365 listing on Microsoft Marketplace and select "Get it now".
- Open Excel and activate it. The Claude panel opens on the side of the workbook.
- Sign in with your Claude account.
On a company Microsoft 365 account, an admin may have to deploy it from the Microsoft 365 admin center under Integrated apps. If you cannot install it yourself, that is usually why.
It does not work on Excel 2016 or 2019 bought as a one-time license, Excel on iPad, or Excel on Android.
What it costs
There is no separate price. Claude for Excel comes with every paid Claude plan and uses the same usage limits as the rest of your account. Per Anthropic's pricing page, Pro is $20 a month or $17 a month billed yearly, Max is $100 a month and Ultra is $200 a month. Team starts at $20 a seat billed yearly. The free plan does not include it.
Six jobs to try first
Start with a copy of a real workbook, not the live one.
| Job | What to ask |
|---|---|
| Understand an inherited sheet | "Explain what this workbook does, tab by tab, and where the inputs are." |
| Fix a broken total | "Find why the total in F20 is wrong and show me the cell causing it." |
| Monthly numbers | "Build a summary tab with revenue, costs and margin by month from the Sales and Expenses tabs." |
| Clean a data export | "Remove duplicates, fix the date formats in column B and flag rows with missing emails." |
| What-if pricing | "If I raise prices 8% and lose 5% of customers, what happens to gross profit?" |
| Quote or budget template | "Turn this into a reusable template with input cells in yellow and everything else locked by formula." |
For every one, read the cells it cites before you trust the answer. Anthropic itself says not to use it for final client deliverables or audit-critical numbers without a person checking.
Limits to know before you rely on it
- No macros or VBA. It will not run or write macro operations.
- No data tables. Excel's what-if data tables are not supported.
- Trusted files only. Anthropic warns to use it only with spreadsheets you trust, because a file can carry hidden instructions.
- Chat history stays in your browser. It is stored locally and does not sync across devices.
- Your data on Anthropic's side is deleted within 30 days, with exceptions listed in the docs. On Enterprise it does not follow your organisation's custom retention settings and is not in the audit logs.
- Fewer models. The add-in offers a smaller set of models than claude.ai.
Claude for Excel, Claude Code or Google Sheets?
Use Claude for Excel when the work lives in one workbook and you want to stay in Excel. Use Claude Code when the job spans many files, such as a folder of monthly exports that need merging into one report every week, or when you want the same steps to run the same way every time. If your team runs on Google Sheets instead, read Claude Code for Google Sheets.
Bookkeepers and anyone who closes the month should also read Claude Code for bookkeepers. For the bigger picture of Claude in a small business, start with Claude for small business.
Claude for Excel: FAQ
Is Claude for Excel free?
Claude for Excel is not on the free Claude plan. It is included in every paid plan, starting with Pro at $20 a month ($17 a month billed yearly), and it uses the same usage limits as the rest of your Claude account.
How do I add Claude to Excel?
Install the Claude for Microsoft 365 add-in from Microsoft Marketplace, open Excel, activate the add-in and sign in with a paid Claude account. On a work account your Microsoft 365 admin may need to deploy it for you.
Does Claude for Excel work on Mac?
Claude for Excel works on Excel for Mac version 16.46 or later, on Excel on Windows with a Microsoft 365 subscription, and on Excel on the web. It does not work on Excel for iPad or Android.
Can Claude write Excel formulas?
Claude can write, explain and fix Excel formulas, and it changes assumptions while keeping formula relationships intact. It cannot run macros or VBA, and it does not support Excel data tables.
Is Claude for Excel safe for client data?
Anthropic deletes Claude for Excel data on its side within 30 days, with exceptions, and recommends against using it on sensitive or regulated data without proper controls. Check your plan's terms and your company's rules before using client files.
Is Claude better than Copilot in Excel?
The two take different approaches, and the right one depends on which subscription your team already pays for. Claude for Excel cites the cells behind each answer and shares one conversation across Excel, PowerPoint, Word and Outlook. Test both on the same copy of a real workbook before deciding.
Put Claude to work on the whole business
The AI Operator Kit gives you five ready systems for content, leads, outreach, sales and building, plus 107 prompts sorted by job, so your work in Excel becomes one part of a business that runs on Claude.