How to Use Claude for Excel: Setup, Prompts, and Limits

Two ways Claude shows up in Excel

People search for this as the Claude Excel plugin, Claude in Excel, or Claude for Excel, and those names point at two different things. The first is Anthropic's own Claude for Excel add-in. Microsoft calls these Office add-ins rather than plugins, and this one is a sidebar you sign into with your Claude account.

The second is Claude as a model option inside Microsoft's own Copilot in Excel. That route runs through your Microsoft 365 Copilot setup and depends on your IT admin connecting Anthropic. It is a separate product with separate access and controls.

This guide covers the first path, the Claude for Excel add-in. A comparison section near the end helps you decide between the two.

Check your plan and Excel version first

Is Claude for Excel free? The add-in is included on Pro, Max, Team, and Enterprise plans, so a free Claude account does not qualify. Your use counts against the same usage limits as the rest of your Claude account.

Version matters just as much as plan. Claude for Excel needs a modern Microsoft 365 build, and it is a common reason the add-in never appears.

• Works: Excel on the web
• Works: Excel on Windows with a Microsoft 365 subscription, build 16.0.13127.20296 or later
• Works: Claude for Excel on Mac, version 16.46 or later (build 21011600 or later)
• Does not work: Excel 2016 and 2019 perpetual or volume licenses
• Does not work: Excel on iPad or Excel on Android
• Does not work: older Microsoft 365 builds below the SharedRuntime threshold

Install Claude for Excel from AppSource

The install is a marketplace add-in, not a download you run locally. Individuals can do it in about four steps, and admins can deploy it to a whole organization from the Microsoft 365 Admin Center.

To install it for yourself:

1. 1.Open the Claude for Microsoft 365 listing on Microsoft AppSource.
2. 2.Select Get it now.
3. 3.Open Excel and activate the add-in: Home, then Add-ins on Windows, or Tools, then Add-ins on Mac.
4. 4.Sign in with your Claude account. The Claude sidebar opens next to your workbook.

To deploy it for a team, an admin turns on Let users access the Office Store under Org Settings, User owned apps and services, then goes to Integrated apps, Add-ins, searches for Claude for Microsoft 365, and assigns it to the organization or to specific users and groups.

Set your instructions once before the first prompt

Open Settings in the add-in sidebar and fill in the Instructions field. Whatever you write there applies to every conversation in Excel. It does not carry over to Claude in PowerPoint or Word, which keep their own instructions.

Use it for the conventions you would otherwise repeat in every prompt, such as number formats, currency, and how cautious Claude should be with existing cells. A starting point:

Four jobs Claude for Excel does well inside a workbook

The add-in is strongest when the workbook already exists and the job is to understand it, change it safely, or fix it. Each pattern below pairs a job with a prompt shape you can adapt. Replace the bracketed placeholders with your own cells, tabs, and values.

1. Understand a model you did not build. Answers come with cell-level citations you can click to jump to the referenced cell.

2. Change an assumption without breaking the formulas. Claude updates values while keeping formula relationships intact, so downstream cells recompute.

3. Trace and fix an error. Ask for the root cause first, then the fix, so you can approve the change.

4. Build or populate a model. Claude can fill an existing template or generate a new model from a plain-language description.

It can also handle native Excel operations when you ask directly: sorting, filtering, editing pivot tables, conditional formatting, and data validation dropdowns.

A prompt you can reuse: audit a workbook you inherited

Use this on any workbook you did not build before you touch a single cell. It tells Claude to read and report only, which keeps the first pass safe.

Expected output: a tab-by-tab summary, the five inputs that matter most with their cell locations, a list of formula problems with references, and a ranked list of the three riskiest findings. Nothing in the workbook should change.

Go beyond one sheet with connectors, Skills, and other Office apps

Claude for Excel can pull outside context through connectors such as S&P Global, LSEG, and Daloopa, and it applies enabled Skills automatically while you work. Which connectors you see depends on your plan and your organization's settings, so check the add-in sidebar rather than assuming.

It also shares context with the Claude add-ins for PowerPoint, Word, and Outlook, so one conversation can span a workbook, a deck, a document, and an inbox. Each add-in has to be installed, the files have to be open, and the cross-app setting has to be turned on in each add-in. Claude cannot open or switch files on its own.

If your organization routes AI traffic through Amazon Bedrock, Google Cloud Vertex AI, Azure AI Foundry, or an LLM gateway, your admin can deploy the add-in without individual Claude accounts.

Add-in or Claude app: which one makes the spreadsheet?

Can Claude create Excel files? Yes, in two different places, and they solve different problems. The add-in works inside a workbook you already have open in Excel. The regular Claude app can separately create and edit .xlsx files using code execution and give you a download.

Reach for the add-in when the model already lives in Excel and you want edits in place. Reach for the Claude app when you are starting from raw data, a PDF, or a description and want a finished file out.

Claude in Excel vs Copilot in Excel: how to choose

There is no trustworthy head-to-head benchmark of formula accuracy to cite here, so this comparison covers access, billing, and control instead of declaring a winner. The honest way to decide is to run the audit prompt above on the same workbook in both tools and compare the results yourself.

• Access and billing: the Claude add-in uses your Claude plan. Copilot in Excel runs on a Microsoft 365 Copilot setup, and Claude inside Copilot needs an admin to connect Anthropic.
• Data path: Microsoft says the Claude model used in Copilot is hosted outside Microsoft. The add-in signs into your Claude account and follows the data handling rules in the caution section below.
• Model choice: the add-in offers a curated subset of Claude models chosen for Office tasks. Copilot offers Microsoft's own mix of models, which can include Claude when enabled.
• Best fit, as an editorial call: the Claude add-in suits people who already pay for Claude and want cell citations and safe assumption changes. Copilot suits organizations standardized on Microsoft 365 Copilot that cannot add another vendor sign-in.

Where this breaks down

Anthropic is direct about the limits. Treat them as hard rules for how you use the add-in.

• Unsupported: data tables, and macros or VBA operations. If you need a macro, drafting VBA in the regular Claude app and reviewing it line by line before you run it is a separate workflow from the add-in.
• Not recommended without human review: final client deliverables, audit-critical calculations, and models with highly sensitive or regulated data.
• Prompt injection risk: files from outside sources, such as downloaded templates, vendor files, and data imports, can hide instructions that try to make Claude extract data or change records. Only use the add-in on spreadsheets you trust, and read every confirmation prompt on external files.
• Data handling: inputs and outputs are deleted on the backend within 30 days, chat history is stored locally in your browser, and the add-in does not inherit custom data retention settings your organization may have set. Activity is not included in Enterprise audit logs.

If the add-in does not show up

Most failed installs come down to plan, version, or admin settings rather than the add-in itself. Work through these in order.

• Confirm you are on a paid Claude plan. A free account does not qualify.
• Check your Excel build against the supported versions above. Perpetual Excel 2016 and 2019 cannot run it.
• Search AppSource for Claude for Microsoft 365. You may also see an older listing named Claude by Anthropic for Excel.
• If the Office Store is blocked, an admin needs to turn on Let users access the Office Store, or deploy the add-in with the custom manifest XML file that Anthropic provides.
• If an admin deployment fails and your admin roles are activated through Microsoft Entra PIM, deploy from an account with the role permanently active. Anthropic lists this as a known Microsoft issue, and individual users can still install the add-in themselves.
• Confirm you are signed in to the correct Claude organization inside the add-in.

Before you trust the output

Run this check every time Claude edits a workbook, and always before anything leaves your hands.

• I worked on a copy of the workbook, not the only version
• The file came from a source I trust, with no hidden instructions
• I asked Claude to list every cell it changed and spot-checked at least three
• Calculations are still live formulas, not pasted values
• I read every overwrite warning before confirming
• Key totals reconcile against the source data
• A human reviewed anything client-facing or audit-related

What to try next

Once the audit prompt works on one inherited workbook, add the cross-app step: have Claude turn the findings into a short summary in Word or a slide in PowerPoint. The Microsoft 365 guide walks through that email-to-deliverable workflow end to end.