Claude in Excel (Claude for Excel) is the official add-in that brings Claude into Microsoft Excel. Instead of switching windows, you open Claude in a sidebar inside Excel: it reads your workbook, answers with cell-level citations, updates assumptions while preserving formula dependencies, and debugs errors. It is built especially for professionals who live in spreadsheets — financial analysis and modeling. This guide covers plan requirements, installation, key features, safety guardrails, and limitations, based on the official Anthropic help article. (As of June 2026)
What makes it different
Unlike pasting a spreadsheet into a chatbot, Claude in Excel reads the open workbook itself — cell values, formulas, tab structure, and cross-tab dependencies. Ask "what assumptions drive the Q3 revenue forecast?" and it answers with clickable citations that jump to the referenced cells. When it edits values, it preserves formulas and dependencies, and every changed cell is highlighted with an explanatory note.
Per the official docs, the headline capabilities are: workbook Q&A with cell-level citations, updating assumptions while keeping formula dependencies intact, debugging errors (#REF!, #VALUE!, circular references), building new models or filling existing templates, navigating complex multi-tab workbooks, and pulling in context from other tools via connectors.
Requirements — plans and supported versions
Claude in Excel is available on the Pro, Max, Team, and Enterprise plans (not on the Free plan). Usage is not billed separately — it shares your existing Claude account limits. See our Claude pricing guide for plan differences.
Supported versions per the official docs: Excel for the web, Excel for Windows (Microsoft 365 subscription, build 16.0.13127.20296+), Excel for Mac (version 16.46+), and Excel for iPad (version 2.51+). Perpetual-license Excel 2016/2019 and Excel on Android are not supported.
How to install
Individuals: open the "Claude for Microsoft 365 (Excel, PowerPoint, and Word)" listing on the Microsoft Marketplace, click "Get it now", enable the add-in in Excel, and sign in with your Claude account. Claude then appears in the Home ribbon.
Admins: deploy "Claude by Anthropic for Excel" from AppSource via the Microsoft 365 admin center (Integrated apps) to the whole org or specific users. Organizations that block the Office Store can instead upload the manifest XML file Anthropic provides. There is also an officially supported path for routing through an internal LLM gateway connected to Amazon Bedrock, Google Vertex AI, or Microsoft Azure — no Claude account required in that setup.
Key features
① Read and explain models — ask about any cell, formula, or section; Claude navigates across tabs and cites the referenced cells. ② Update assumptions safely — "increase the growth rate by 2 points and show the impact on terminal value" changes values while preserving dependencies, with changes highlighted. ③ Debug errors — traces root causes of #REF!, #VALUE!, and circular references and proposes fixes. ④ Build models and fill templates — create a three-statement model from scratch or populate an existing template from uploaded documents (e.g. a PDF). ⑤ Native Excel actions — sorting and filtering, editing pivot tables and charts, conditional formatting, data validation (dropdowns), and print preparation, performed directly. ⑥ Connectors, Skills, and Instructions — connectors (MCP) and Skills from your Claude settings work in the add-in (type / in the sidebar to pick a skill), and a persistent Instructions field holds standing rules like "blue inputs, black formulas". Excel instructions are separate from PowerPoint's.
Guardrails — protecting your sheets
Because one wrong cell can break a whole model, the docs spell out several protections. Change tracking: every modified cell is highlighted and annotated. Overwrite protection: Claude warns before overwriting existing data. Session logging: an optional "Claude log" tab records what Claude did each turn. Confirmation popups for risky functions: external-connection and dynamic-reference functions such as WEBSERVICE, INDIRECT, and DDE require your approval when triggered. Excel's standard undo also reverses any change.
Chat history is handled differently from regular Claude: conversations are stored locally in your browser (IndexedDB), not on Anthropic's servers, and do not sync across devices. Backend inputs and outputs are automatically deleted within 30 days, with stated exceptions.
Limitations and cautions
The docs list data tables, macros, and VBA as unsupported. They also state Claude for Excel is not recommended for: final client deliverables without human review, audit-critical calculations without verification, replacing your financial judgment and expertise, or highly sensitive/regulated data without proper controls.
The most emphasized security risk is prompt injection: spreadsheets from untrusted sources (downloaded templates, vendor files) can hide malicious instructions in cells, formulas, or comments that Claude might mistake for your request. The official guidance is to use it only with trusted spreadsheets. We covered the same security design for the browser agent in our Claude in Chrome guide.
Example prompts to try
High-utility examples from the official docs: "Find all #REF and #VALUE errors in this workbook", "Compare actuals vs. budget and explain the largest variances", "Convert all dates to YYYY-MM-DD", "Add a downside scenario assuming revenue drops 15%", "Extract the financial tables from this PDF into my template", "Format this model using IB conventions (blue inputs, black formulas)", "Check that the balance sheet balances in all periods". For Claude's features across other surfaces, see our Claude features overview.
Note: This article is based on Anthropic's official help documentation (accessed June 2026). Supported versions, feature scope, and plan requirements may change. This site is not affiliated with Anthropic.