← Back to Blog

Claude for Excel: The Honest Guide to AI in Spreadsheets.

Claude for Excel is Anthropic's Excel add-in. It reads your workbook, fixes formula errors, runs what-if scenarios, and builds models from plain English.

By Tom·

Claude for Excel is an AI add-in from Anthropic that sits inside Microsoft Excel, reads your entire workbook, and helps you interrogate formulas, fix errors, update assumptions, and build financial models without breaking anything. I'm Tom. I've been using Claude as a daily work tool for over a year, and the Excel add-in is one of the more quietly useful things Anthropic has shipped. Below is an honest look at what it does well, what it cannot do, and how to wire it into a real finance or ops workflow.

The "Claude" in this context is the same Claude that powers Claude.ai, Claude Code, and Claude Cowork. This article is specifically about Claude for Excel, the Microsoft Excel add-in. If you've arrived here looking for Claude Cowork, the broader desktop automation product, I'll cover that too since Excel sits inside the Cowork ecosystem. And if you searched for "Claude Sheets," there is no official Google Sheets integration yet. That gap is worth knowing before you go further.

What is Claude for Excel?.

Claude for Excel is a Microsoft Excel add-in built by Anthropic. It gives you a chat panel inside Excel where you can ask questions about any cell, formula, or tab in your workbook. Claude reads the full model, including cross-tab dependencies, and responds with cell-level citations so you can verify the logic.

You install it from the Microsoft AppSource marketplace, open it with Control+Option+C on Mac or Control+Alt+C on Windows, and from that point it stays alongside your spreadsheet as a persistent sidebar. Unlike pasting data into Claude.ai, the add-in has read-write access to your workbook. It can make changes, highlight every change it makes, and explain why. No copying and pasting ranges back and forth.

What is Claude Cowork?.

Claude Cowork is the broader product that Claude for Excel sits within. Cowork is Anthropic's agentic system for knowledge work: it runs on your desktop, connects to local files and applications, and completes multi-step tasks from start to finish. Excel is one of many things it can work with alongside Word, PowerPoint, Slack, Chrome, and your local file system.

The difference between Cowork and regular Claude chat: in chat, Claude responds to messages but cannot touch your files directly. In Cowork, Claude has permission to read, edit, and create files in folders you specify. The Claude for Excel add-in brings that same file-access model directly into your spreadsheet, as a focused single-app integration.

How does Claude for Excel work?.

The add-in reads your full workbook context when you open it, including formula structures, cross-tab references, and named ranges. When you ask a question or request a change, Claude works through the model, shows you a diff of every change it plans to make, and waits for your review before writing anything to the sheet. Transparency is the core design principle.

Formula understanding and cell citations.

Claude parses nested formulas across tabs and responds with explicit cell references. Ask "what drives the Q3 revenue forecast?" and it will trace back through SUMIF, INDEX/MATCH, and lookup tables, citing every cell that contributes to the answer. This is more useful than searching Stack Overflow for formula syntax, because it is explaining your model, not a generic example.

Scenario testing without breaking dependencies.

You can tell Claude to update an assumption, such as "increase revenue growth by 2% and show the impact on terminal value," and it will propagate the change across every dependent cell while preserving formula structure. It highlights each change with an explanation. If the change would break a reference, Claude flags it rather than silently corrupting the model.

Error debugging.

Claude traces #REF!, #VALUE!, and circular reference errors to their source. Give it a broken cell and it explains what went wrong and how to fix it without disrupting the rest of the sheet. This is where most people save the most time, because debugging a cascading #REF! in a 40-tab model manually takes hours.

The 5 things Claude for Excel does well.

Here is where the tool earns its keep for business owners and analysts.

  1. Formula generation with context. Not just "write me a VLOOKUP." You describe what you're trying to calculate in plain English and Claude generates the formula with references to your actual column headers and named ranges. It also explains what the formula does so you understand the logic before accepting it.
  2. Data cleaning on messy imports. When you pull data from a CRM, accounting system, or manual entry sheet, it arrives inconsistent. Claude identifies formatting issues, flags duplicates, standardises date formats, and cleans string fields without you writing a custom macro.
  3. Model-from-prompt for simple structures. Give Claude a brief, for example "build a monthly P&L with rows for revenue, COGS, gross margin, operating expenses, and EBITDA, using assumptions in a separate tab," and it will scaffold the structure. You fill in the numbers. It handles the formulas and cross-references.
  4. Summary tab generation. Claude reads a complex multi-tab model and generates a clean executive summary tab, pulling key metrics with live references back to the source data. The summary updates automatically when inputs change. This is one of the most used workflows in practice.
  5. What-if scenario analysis. You can set up scenario toggles by describing them. "Add a dropdown to this assumptions tab so I can switch between base, bull, and bear cases, and have the rest of the model respond to the selection." Claude builds it, explains every change, and you approve before anything is written.

The 3 things Claude for Excel cannot do.

Honest review means calling out the gaps.

  1. It does not connect to live external data. Claude for Excel reads whatever is already in your workbook. It has no direct access to market data feeds, live API connections, or external databases. If you need live pricing or real-time metrics in your model, you'll need a separate data connector or Claude Cowork with browser access.
  2. It does not write complex VBA macros reliably. Claude can write basic VBA and Power Query M code, but it is not a coding agent. For complex Excel automation, Claude Code in the terminal is the better tool. Claude for Excel is designed for knowledge-work users, not developers.

It is not available for Google Sheets. Despite searches for "Claude Sheets," there is no official Claude add-in for Google Sheets. The add-in is Microsoft Excel-only. There is a separate Google Drive connector for Claude.ai that lets Claude read your Drive files (Sheets, Docs, PDFs) inside chat sessions, but it is read-only and not the same as a live two-way Sheets integration. If your team is Sheets-first, the realistic workflow is Drive-connector reads inside Claude.ai or Claude Cowork with browser access, not a native add-in.

How to install Claude for Excel.

Claude for Excel is available on Claude Pro, Max, Team, and Enterprise plans. Free plan users cannot access it.

Step 1: Confirm your plan.

Log into claude.ai and check you're on Pro ($17/month annual, $20 monthly), Max, Team, or Enterprise. Free plan users need to upgrade first.

Step 2: Install from Microsoft AppSource.

Go to the Claude for Excel page on Microsoft AppSource. Click Install and sign in with your Microsoft account. The add-in will appear in your Excel ribbon.

Step 3: Open Excel and activate.

Open any workbook. Press Control+Option+C on Mac or Control+Alt+C on Windows to open the Claude sidebar. Sign in with your Anthropic account when prompted. Select the workbook to give Claude access, and the conversation panel goes live.

For enterprise deployments, you can also access Claude for Excel through Amazon Bedrock, Google Cloud Vertex AI, or Microsoft Foundry rather than directly through a Claude account.

Claude for Excel vs Microsoft Copilot.

The obvious comparison. Both are AI tools inside Excel, and if your organisation runs Microsoft 365, Copilot may already be available to you at no extra cost.

Copilot is tightly integrated with the Microsoft ecosystem and works well for generating charts, summarising data in the ribbon, and basic formula help. Claude tends to perform better on complex multi-tab financial models where you need precise, traceable reasoning across dependencies. The cell-level citation format and the approval-before-change workflow makes Claude safer to use on models that other people will review.

Claude for Excel vs Copilot is not a clear win for either. If you're already paying for Copilot via Microsoft 365, test it on your actual models before switching. If you're already on a Claude plan and working in Excel regularly, the add-in is a no-brainer add-on at no extra cost.

How to wire Claude for Excel into a real workflow.

This is where the tool earns its value beyond one-off queries. The most useful workflow pattern: a monthly reporting model that your team updates manually. Inputs come from various sources, formulas cascade through the model, and the output is a deck or executive summary. This is painful without AI.

With Claude for Excel, the workflow looks like this. After pulling data into the workbook, open the Claude sidebar and ask it to check for data quality issues: missing values, outliers, formatting inconsistencies. Fix those first. Then ask Claude to update the specific assumption cells with the new period's inputs and verify that downstream formulas updated correctly. Finally, ask Claude to refresh the summary tab with commentary on the period-over-period changes, citing the cells that drove any material movements.

That workflow, which used to take two to three hours of error-prone manual review, takes 30 to 45 minutes with Claude. The remaining time goes to analysis and judgment, not formula tracing.

If you want to go further, Claude Cowork can handle the data pull step: it can check your email, pull the source file from an attachment, save it to the right folder, and trigger the Excel workflow. That's the bridge from "AI inside a spreadsheet" to "AI running your ops." The 30-Day Claude Code Challenge covers how to build these end-to-end pipelines.

Verdict: is Claude for Excel worth it?.

Yes, for analysts, finance teams, and business owners who live in Excel and are already on a Claude paid plan. The formula debugging alone saves enough time to justify the add-in. The scenario testing and model scaffolding are genuine workflow improvements, not demo features.

Who it is not for: free plan users (no access), Google Sheets users (no add-in exists), or developers who need VBA and Power Query automation (Claude Code is the better tool for that).

The honest framing: Claude for Excel is a spreadsheet co-pilot, not an autonomous agent. It asks before it acts, shows you every change, and waits for your approval. That conservative approach is exactly right for financial models where a silent mistake cascades. If you're using the add-in and want to extend that same logic to the rest of your business, the natural next step is Claude Code. The Claude Code guide on this site is the place to start.

Claude for Excel FAQ.

What is Claude for Excel?

Claude for Excel is a Microsoft Excel add-in from Anthropic that lets you ask questions about any cell or formula in your workbook, fix errors, test scenarios, and build models from natural language descriptions. It reads your entire workbook structure and shows you proposed changes before writing anything.

How do I use Claude in Excel?

Install the Claude for Excel add-in from Microsoft AppSource, open Excel, and press Control+Option+C on Mac or Control+Alt+C on Windows to open the Claude sidebar. Sign in with a Claude Pro, Max, Team, or Enterprise account. From there you can ask questions about your model, request formula changes, and run scenario tests.

Is Claude for Excel free?

No. Claude for Excel requires a paid Claude plan: Pro ($17/month on annual billing), Max, Team, or Enterprise. The free Claude plan does not include the Excel add-in.

Does Claude for Excel work with Google Sheets?

No. Claude for Excel is a Microsoft Excel add-in only. There is no official Claude add-in for Google Sheets. The closest equivalent is the Google Drive connector for Claude.ai, which lets Claude read your Drive files (including Sheets) inside chat sessions, but it is read-only access from chat, not a live two-way Sheets integration. Sheets-first teams can also use Claude Cowork with browser access to view and edit their workbook in the browser.

What is the difference between Claude for Excel and Claude Cowork?

Claude for Excel is the specific Microsoft Excel add-in. Claude Cowork is the broader desktop automation product that works across multiple apps including Excel, Word, PowerPoint, Slack, and your browser. The add-in is the focused, spreadsheet-specific entry point. Cowork is the full agentic system for knowledge work.

Can Claude for Excel fix formula errors?

Yes. Claude for Excel traces #REF!, #VALUE!, and circular reference errors to their source and explains what went wrong and how to fix it. You approve the fix before Claude writes anything to the sheet.

What Claude plans include the Excel add-in?

Claude for Excel is available on Pro, Max, Team, and Enterprise plans. It is not available on the free Claude plan. For enterprise deployments it can also run through Amazon Bedrock, Google Cloud Vertex AI, or Microsoft Foundry.

What file formats does Claude for Excel support?

Claude for Excel currently supports .xlsx and .xlsm files. File size limits apply based on your Claude plan. It does not support the older .xls format through the add-in, though you can convert those files first.

Ready to build AI into your operations?.

Claude for Excel is a good starting point. The bigger opportunity is building the systems that feed it. Grab the free Claude Code Blueprint for the foundation every AI operator needs before they start automating. And if you want to understand how to wire Claude into multi-step agentic pipelines, the Claude Agent SDK guide covers exactly that.

Free · 60 Minutes · No coding required

The Claude Code Blueprint.

Five interactive lessons. Install Claude Code, build your first automation, and deploy it live on the internet — all in under an hour. Free, no coding required.

Grab the Blueprint