Claude in Excel: setup and what it can do

Claude works inside Excel through an official Anthropic add-in: a sidebar that reads your workbook, explains what it finds, edits cells and formulas on request, and builds new analysis in place. This guide covers the setup, what it is actually good at, and the limits to know before you rely on it.

What you need

A paid Claude plan: the Excel add-in is available on Pro, Max, Team, and Enterprise.
Excel 2016 or later on Windows or Mac, or Excel on the web.

Install the add-in

In Excel, go to Insert, then Get Add-ins.
Search for "Claude by Anthropic" and add the official add-in. (It is also listed on Microsoft AppSource if your organization installs add-ins centrally.)
Open the add-in from the ribbon and sign in with the same account you use on claude.ai.

Once installed, the shortcut to summon the sidebar is Ctrl+Alt+C on Windows and Ctrl+Option+C on Mac.

If the add-in does not appear, your Microsoft 365 admin may need to allow it: centralized deployment policies commonly block marketplace add-ins, and that is an admin-console fix, not a local one.

What it is good at

Explaining inherited spreadsheets. Point it at a workbook you did not build and ask how it works; it traces formulas and dependencies and explains them in plain language. This is the single most popular use.
Formula work. Writing, fixing, and refactoring formulas, including the gnarly nested ones, with the change applied directly to the cell.
Building analysis in place. Summaries, pivots, scenario tables, and new tabs built from your existing data.
Debugging. "Why is this column returning #N/A" with the workbook open beats pasting fragments into a chat window.

The add-in operates with visibility into your workbook's structure, so its answers are grounded in the actual sheet rather than your description of it.

Current limits

It is workbook-focused: it works on the file you have open, not across your whole drive.
Plan limits apply: heavy sessions count against your Claude plan's usage like any other Claude use.
Organization policies can restrict what the add-in may read; Enterprise admins control data handling.
As with every AI-in-spreadsheet tool: review edits before they ship. Claude shows what it changed, which makes review practical; skipping it is on you.

How this fits the bigger Claude picture

The Excel add-in is part of Anthropic's broader Office push, with Claude also available for PowerPoint and Word, sharing context between them on recent versions. If your workflow is more code than spreadsheet, Claude Code is the deeper tool, and the two compose: analysts increasingly prep data with Claude in Excel and automate the pipeline around it with Claude Code. For account questions, what Claude Code costs covers the plan tiers from the developer side.

Source: Use Claude for Excel (Claude Help Center), checked June 2026.