How do I install Claude for Excel?

In Excel, open Insert then Get Add-ins (on some builds it is Home then Add-ins), search for 'Claude by Anthropic', and choose Add. You can also install it from the Microsoft Marketplace listing 'Claude by Anthropic for Excel'. Open the side panel and sign in with the same account you use on claude.ai. It runs in Excel 2016 or later on Windows and Mac, and in Excel on the web, and you can open it with Ctrl+Alt+C on Windows or Ctrl+Option+C on Mac.

Can Claude for Excel run VBA macros?

No. The add-in supports .xlsm files and can read and explain their structure and formulas, but it cannot execute or modify VBA macros. If you want Claude to write VBA you paste in yourself, use the normal chat workflow rather than the add-in.

What can Claude for Excel see and which files does it support?

Claude for Excel reads only the workbook you currently have open — its cells, formulas, and tab structure — not your wider drive. It works with .xlsx and .xlsm files but not the legacy .xls format, and it cannot work with Excel Data Tables. Anthropic also advises using it only on spreadsheets you trust.

Claude + Excel

How to Install and Use Claude for Excel (2026 Guide)

Q: Is Claude for Excel free?

No. The Claude for Excel add-in requires a paid plan — Claude Pro, Max, Team, or Enterprise. Pro subscribers ($20/month) gained access in January 2026; before that it was a beta limited to Max and Enterprise. The free tier can still use Claude for Excel formulas through the normal chat window by copy-and-paste, but the in-workbook add-in is paid only.

By Sagnik Bhattacharya27 Jun 202612 min read

Coding Liquids blog cover featuring Sagnik Bhattacharya for How to Install and Use Claude for Excel (2026 Guide), with Claude add-in panels, cited formula suggestions, and workbook cells with review markers.

For a long time, using Claude on a spreadsheet meant copying rows into a chat window and pasting formulas back. Claude for Excel removes that round-trip. It's an official Anthropic add-in that sits in a side panel inside Excel, reads the workbook you have open, and answers questions or writes formulas straight into the cells — with clickable citations back to the exact cells it used.

I teach Flutter and Excel with AI — explore my courses if you want structured learning.

If you only need Claude to write a formula that you paste in yourself, that free chat workflow is covered in using Claude AI to write Excel formulas. This guide is about the paid add-in: what it costs, how to install it, and — just as importantly — what it can and can't do inside the workbook.

What Is Claude for Excel?

Claude for Excel is a side-panel add-in from Anthropic. Once installed, it reads the content of your currently open workbook — the cells, formulas, and tab structure — and works alongside you without leaving Excel. Because it reads every tab, you can ask it about data spread across sheets without pasting anything in.

Its standout feature is cell-level citations: when Claude explains a number or a formula, it includes clickable references that jump you straight to the cells it used. That turns "trust me" into "here's my working", which matters a great deal when the spreadsheet feeds a real decision. The add-in launched in beta in October 2025 for Max and Enterprise users, and became generally available to Claude Pro subscribers in January 2026.

What It Costs

The add-in is paid only. You need a Claude Pro, Max, Team, or Enterprise plan — it isn't on the free tier. Pro (currently $20/month) gained access in January 2026; before that it was a beta limited to Max and Enterprise. You sign in with the same Claude account you already use on claude.ai, so there's no separate subscription to buy for Excel specifically.

If you're on the free plan, you don't miss out entirely — you can still get Claude to write, explain, and debug formulas in the normal chat window and paste them in. The add-in simply removes the copy-and-paste step and lets Claude see and edit the live workbook.

How to Install Claude for Excel

The whole process takes a couple of minutes:

Check your Excel version. The add-in runs in Excel 2016 or later on Windows and Mac, and in Excel on the web.
Open the add-ins gallery. In Excel, go to Insert → Get Add-ins (on some builds this lives under Home → Add-ins).
Search and add. Search for Claude by Anthropic and choose Add. You can also install it from the Microsoft Marketplace listing, Claude by Anthropic for Excel, by selecting Get it now.
Sign in. Open the side panel and sign in with the same Claude account you use on claude.ai.
Learn the shortcut. Open or focus Claude any time with Ctrl+Alt+C on Windows or Ctrl+Option+C on Mac.

Can't see the add-in after installing? Close and reopen Excel, then look under Insert → My Add-ins. On a managed work device, your admin may need to approve the add-in before it appears. Because the desktop and web versions share the same Microsoft account, installing it once usually surfaces it everywhere you use Excel.

Your First In-Workbook Task

Open a workbook, select the cell where you want a result, and describe what you need. For example, ask: "Write a formula in D2 that gives a 10% bonus when C2 is above ₹50,000, otherwise 5%." Claude drops the formula straight into the cell and cites the input it used:

=IF(C2>50000, C2*0.1, C2*0.05)

The real advantage shows up with multi-tab work. Because Claude reads the whole open workbook, you can ask cross-sheet questions without pasting anything: "Reconcile the totals on the Summary tab against the Transactions tab and tell me where they differ." The answer comes back with clickable citations, so you can click through to each cell it's referring to and verify the logic yourself.

A Real Workflow: Reconciling Two Tabs

Here's the kind of task the add-in is built for. Say you have a Summary tab with month-end totals and a Transactions tab with the raw line items, and the two don't agree. With the panel open, you'd work through it like this:

Frame the problem. "The Net Revenue in Summary!B7 doesn't match the sum of Transactions. Find the difference and show me where it comes from." Claude reads both tabs and replies with the exact gap, plus a citation to Summary!B7 you can click straight to.
Drill in. "List the transactions that aren't included in the Summary total." It returns the offending rows with a link to each cell, instead of a vague "check your ranges".
Fix it in place. "Rewrite Summary!B7 so it always covers the whole Transactions table, even when new rows are added." Claude writes a structured-reference SUM into the cell:
```
=SUM(Transactions[Amount])
```
Guard against the next break. "Add a check cell that turns red if Summary and Transactions ever diverge again." It builds the comparison formula and the conditional-formatting rule for you.

The whole exchange stays inside Excel, every claim is cited, and you finish with a fix rather than just an explanation — that's the real gap between this and pasting snippets into a chat window.

What Claude Can Do Inside Excel

Write and edit formulas in place — then ask it to fill the column or adjust the logic.
Apply Excel-native operations — sort and filter data, build or edit pivot tables and charts, set conditional formatting and data validation, and prepare a sheet for printing.
Adjust assumptions while preserving dependencies — change an input and the dependent formulas update, with Claude explaining the knock-on effects rather than silently overwriting them.
Debug and explain with citations — it traces an error or a calculation back to the exact cells, so you can audit its reasoning. (For a deeper error-fixing routine, see fixing Excel formula errors with Claude.)
Build or populate models — describe the structure you want and let Claude lay it out, then refine it tab by tab.

Limits and Cautions

The add-in is genuinely useful, but it isn't magic — and knowing the edges keeps you out of trouble:

It only sees the open workbook. Claude can't reach across your drive or read other files unless you upload them into the chat.
File-type limits. It works with .xlsx and .xlsm files but not the legacy .xls format, and it can't work with Excel Data Tables.
No VBA execution. It supports .xlsm files and can read and explain their structure, but it cannot run or modify VBA macros. To have Claude write VBA you paste in yourself, use the chat workflow in Claude AI for Excel macros and VBA.
Trust matters. Anthropic advises using the add-in only on spreadsheets you trust — a workbook from an unknown source could contain hidden text designed to misdirect the model.
Always verify. Treat the output like a capable junior's draft. Spot-check it, especially on anything that feeds a decision — see how to review AI-generated formulas before you trust them.

Claude for Excel at a Glance

Can do	Can't do
Read every tab in the open workbook	Read other files on your drive
Write and edit formulas directly in the cells	Run or modify VBA macros
Build pivot tables, charts, and formatting	Work with Excel Data Tables
Cite the exact cells behind every answer	Open legacy `.xls` files (`.xlsx`/`.xlsm` only)
Run on Windows, Mac, and the web (Excel 2016+)	Work on the free Claude tier

Add-in, Chat, or Copilot — Which Should You Use?

They're complementary, not rivals:

The add-in wins when the work spans several sheets, or when you want answers written and cited inside the live file.
Free chat wins for a quick one-off formula, for learning how something works, or when you're happy to paste a few sample rows — that's the formula-writing guide.
Microsoft Copilot is the native option if your whole team lives in Microsoft 365; weigh the trade-offs in ChatGPT vs Claude vs Copilot vs Gemini for Excel.

For the wider Excel-with-AI picture — formulas, cleaning data, dashboards, and more — start at the Excel formulas guide.

Frequently Asked Questions

Is Claude for Excel free? No — it needs a Pro, Max, Team, or Enterprise plan. Pro got access in January 2026 at $20/month. The free tier can still use Claude for formulas through ordinary chat by copy-and-paste.

Does it work on Mac and the web? Yes. It runs in Excel 2016 or later on both Windows and Mac, and in Excel on the web.

Can it run my macros? No. It reads and explains .xlsm structure but can't execute or change VBA. Use the chat workflow to generate macro code you paste in yourself.

Wrapping Up

Claude for Excel is the cleanest way to put Claude's reasoning where your data already lives — reading the whole workbook, writing cited formulas in place, and explaining its working as it goes. If you're on a paid plan and you spend real time in spreadsheets, it's worth the few minutes to install. If you're on free Claude, the chat-based formula workflow still does most of the job. Either way, if you want to go deeper, my courses walk through Excel-with-AI end to end.