Claude in Excel: How it Works, MCP Connectors & Security
Erwin Berkouwer
Discover how Claude in Excel works, which MCP connectors are available, and how to manage prompt injection and context limits. Business and technical overview.
Companies that don't use AI in Excel lose on average 3 to 5 hours per week to manual research, debugging, and explaining complex workbooks to colleagues. Claude in Excel is an add-in from Anthropic that brings Claude directly into Microsoft Excel: you ask questions about your workbook, get formulas explained or adjusted, and can access external data sources via MCP connectors. This article describes how it works, available connectors, business value, and security aspects that are often missing from reviews.
The Problem: Complex Workbooks Without Insight into Logic
Legacy workbooks with dozens of tabs, hidden assumptions, and hardcoded numbers are difficult to understand. Tracing errors like #REF! or #VALUE! back to their source takes hours. Meanwhile, the organization expects quick answers. Generic AI tools that only see plain text or screenshots miss the structure of formulas and cell references. The need is clear: AI that understands the workbook and can provide targeted explanations or changes, with clear source references.
What Claude in Excel Does: Read, Explain, Modify
Claude in Excel is an add-in that runs in a side panel next to your workbook. You open one workbook; Claude reads its contents (cells, formulas, table structure) from that file. You can ask questions in plain language about specific cells, ranges, or the entire model.
Core functionality:
- Answer questions about your workbook, with cell references in the response.
- Modify assumptions while keeping formulas and dependencies intact.
- Debug errors and point out root causes.
- Set up new models or templates or populate existing ones.
- Navigate through multiple tabs and explain connections.
- Use connectors to pull context from external tools (market data, research) into your spreadsheet.
Only the workbook you have open in Excel is visible to Claude. There is no access to other files unless you explicitly upload files or use connectors.
Expert tip: Start with explanations and tracing before making changes. For example, ask: "Which cells determine the Q3 revenue forecast?" or "Walk me through how the WACC calculation flows through the DCF model." This way you first build a mental model of the file.
Technical Architecture: Add-in, Context & MCP Connectors
The add-in communicates with Excel via the available object model: cells, ranges, formulas, and worksheets are read and can be modified (with your approval). Supported file formats are .xlsx and .xlsm. Formulas, dependencies, and existing formatting are preserved where possible.
The role of MCP connectors is an aspect missing from many reviews. Claude in Excel can use the same connectors as in your Claude settings. Via the Model Context Protocol (MCP), Claude can fetch context from external sources such as S&P Global, LSEG, Daloopa, Pitchbook, Moody's, and FactSet. The data flow is roughly: (1) workbook content + optional connector context → (2) model → (3) tool calls back to Excel (e.g., change cell, write formula). For financial models or due diligence, you can thus in one conversation involve both your spreadsheet and live market or company data.
| Connector Type | Examples | Typical Use Case |
|---|---|---|
| Market Data | LSEG, S&P | Prices, macro data, estimates in models |
| Research / Credit | Moody's, Aiera, Third Bridge | Credit analysis, earnings, expert interviews |
| Deal / Portfolio | Pitchbook, Daloopa, Chronograph | M&A, due diligence, portfolio monitoring |
| Internal | Egnyte (data rooms) | Search approved documents and models |
You configure connectors via Claude settings; if they're there, they also work in Excel. Custom connectors can carry extra risks; assess them according to guidelines for custom/remote MCP before deploying.
Business Value: Understand Faster, Make Fewer Mistakes
The value isn't in "automating everything," but in compressing time: from hours to minutes to understand a workbook, trace errors, or safely adjust assumptions. That reduces meeting stress and increases confidence in numbers.
- Model review: Understand legacy models in minutes instead of 30–60 minutes of manual tracing.
- Debugging: Have #REF!, #VALUE!, or circular reference errors explained and get targeted fixes proposed (which you still approve).
- Scenarios and assumptions: "Increase the growth assumption by 2% and show the impact on terminal value" without breaking formulas.
- Documentation: Generate a brief summary per tab or model for handover or governance.
Want to go further than Excel and automate other business processes too? Check out our AI agents for SMB — smart assistants that can drive multiple systems at once and relieve your team.
Claude doesn't replace domain expertise: you remain responsible for the outcomes. It's a tool for understanding and maintenance, not for unguided automation.
Implementation: Installation & First Steps
- Go to the Claude in Excel page in Microsoft AppSource and click "Get it now" to install the add-in.
- Open Excel, enable the add-in via Home > Add-ins (Windows) or Tools > Add-ins (Mac).
- Sign in with your Claude account (Pro, Max, Team, or Enterprise; the free tier does not support Claude in Excel).
- Open an existing workbook and start by asking questions about structure and formulas before making changes.
Keyboard shortcut to open the Claude panel: Ctrl+Option+C (Mac) or Ctrl+Alt+C (Windows).
For organizations: manage and roll out via Microsoft 365 Admin Center, under Settings > Integrated apps > Add-ins; search for "Claude by Anthropic for Excel". Also check our real-world examples of AI in business processes for inspiration on how other SMBs use AI in their daily work.
Security & Prompt Injection: What Most Articles Miss
Claude in Excel only changes things after your explicit approval. Every proposed change is shown; you can accept or refuse. Still, Anthropic warns of prompt injection via the spreadsheet itself: malicious or unintended instructions in cells, formulas, or comments can make the model perform unwanted actions (e.g., export or modify data). That's why it's important to only use workbooks you trust (your own files, approved templates, internal models).
Functions that carry extra risk and may trigger a confirmation popup include: WEBSERVICE, STOCKHISTORY, IMPORTDATA, IMPORTXML, INDIRECT, DDE, CALL, EVALUATE, FORMULA, IMAGE, FILES, FOPEN, FWRITE, REGISTER.ID, RTD, INFO. They can fetch external data, access files, or execute code.
Expert tip: Don't use Claude in Excel on workbooks from unknown or external sources (downloads, vendors, shared templates). For sensitive or regulated data, follow your organization's policy and maintain human oversight over all changes.
Context & Sessions: Auto-Compaction & When to Start a New Conversation
Longer conversations are automatically compressed to stay within context limits. That means older parts of the conversation are no longer fully available to the model.
- With very large workbooks (many tabs, thousands of formulas) or long modeling sessions, context can fill up. Start a new conversation for a new task or a new part of the model.
- The optional "Claude Log" tab records which actions Claude performed in the sheet. That helps with review and audit, especially in team environments.
- Chat history is not retained between sessions; each time you open the add-in, you start a new conversation. So plan your questions per session and save important explanations or findings yourself if you'll need them later.
By being intentional about session length and workbook size, you prevent unexpected context switches or incomplete answers.
Limitations & Recommended Use
Claude in Excel does not support data tables, macros, or VBA. Power Query and Power Pivot are not explained or modified by the add-in. For audit-critical calculations or final customer deliverables, human review is essential. Anthropic advises against using it for final deliverables without review or for models with highly sensitive data without appropriate controls.
Frequently Asked Questions
What exactly is Claude in Excel?
Claude in Excel is an official Microsoft add-in from Anthropic. It runs next to your workbook and answers questions about cells, formulas, and structure. You don't need to write code — asking in plain language is enough. Available for Pro, Max, Team, and Enterprise subscribers of Claude.
Which MCP connectors are available for Excel?
Connectors you've set up in Claude — such as S&P Global, LSEG, Pitchbook, Moody's, and Egnyte — automatically work in Excel too. You configure them once in your Claude account settings. That way Claude can access both your spreadsheet and external market or company data in one conversation.
Is Claude in Excel safe for sensitive business data?
Claude only changes things after your explicit approval. Watch out for prompt injection: don't use the add-in on workbooks from external or unknown sources. For regulated data, follow your organization's policy. Team and Enterprise accounts offer additional security settings for governance and compliance.
Does Claude in Excel support macros and VBA?
No. Claude works with cells, formulas, and table structure in .xlsx and .xlsm, but doesn't read or modify VBA code or macros. For automated scripts, you'll stick with classic Excel/VBA or Power Query workflows.
Is my chat history in Claude in Excel saved?
No. Each session starts a new conversation; chat history is not retained between sessions. You must save important explanations or conclusions yourself. Team and Enterprise plans may have different data retention settings — check with your administrator.
Getting Started with AI in Your Workflows
Claude in Excel brings Claude right next to your workbook: read, explain, adjust assumptions, trace errors, and use connectors to access external context. The added value is faster understanding and fewer error-prone changes — not complete automation.
Want to discover how AI agents can speed up other processes in your company? Unify AI helps SMEs select and implement AI solutions. Get in touch for a no-obligation conversation about what's possible for your organization.
