Claude in Excel
“AI inside Excel” — an assistant that leaves your formulas alone
What is Claude in Excel?
Claude in Excel is an official Anthropic add-in that installs inside Excel. It reads the workbook you have open, answers with cell references as evidence, and changes values while keeping formula relationships intact. Its official name is Claude for Excel.
- 1Ask questions and make fixes with Excel still open
- 2Answers include cell-level sources, so you can verify them
- 3Macros and VBA are not supported
What sets it apart
These are the differences we found by running the same material through several tools in our training sessions.
Answers come with cell references
The official documentation says answers about a workbook include cell-level citations that you can click to jump straight to the cell. Ask "Where did this number come from?" and it points to the source cell, so you can check the math.
Changes values while preserving formula relationships
Ask it to change an assumption, and it edits while keeping formula relationships intact so linked cells recalculate, with a warning before it overwrites existing content. You can run sensitivity checks without breaking the model, just by talking to it.
Work with Excel features by just asking
The official docs say you can ask for sorting, filtering, pivot table edits, conditional formatting, and data validation lists in plain sentences. You don’t need to know the feature name. Just describe what you want, and you spend less time hunting through menus.
⚖️ The weaknesses are clear, too
Macros and VBA are not supported, and data tables are out of scope too. It does not work on the 2016 or 2019 perpetual-license versions or on Excel for iPad and Android, and it is not available on the free plan. The official documentation also states plainly: do not hand off audit-relevant calculations without verification.
💡 In plain EnglishIt is like having an assistant who knows Excel inside out sitting next to you. The person who signs off on the final number is still you.
The end product of finance and planning work is a single workbook file. If you can ask questions and make edits with that file still open, the step of copying data out disappears entirely, which reduces both security exposure and mistakes.
Same job, different approach
One total in the quarterly results file doesn’t add up
The old way
- Opening tabs one by one and tracing formulas by hand
- Jumping between screens to find cells with tangled references
- You make yet another copy, afraid that fixing one formula will break others
- In the end, you phone the file’s owner
With Claude in Excel
- With the file open, ask “how did this total come about?”
- Click a cell reference in an answer to jump straight to its source
- Ask it to find the cause of a broken reference
- Review the proposed changes, then a person signs off
Common uses
Understand an inherited file
Open a multi-tab workbook a former colleague left behind and have Claude explain the assumptions and calculation flow. Follow the cell citations to verify.
Test what-if scenarios
Ask it to change a growth rate or discount rate, and the linked calculations update with it. It’s safer to try this on a copy first.
Find the cause of errors
Have it trace the cause of cells that show calculation errors. Accept its suggested fixes, but apply them only after you've checked them.
Who it’s for
Best for
- ✓Finance and planning staff who often work with multi-tab workbooks
- ✓Anyone who inherits Excel files built by someone else
- ✓People already on a paid Claude plan
Better served by other tools
- –Anyone whose work centers on macros and VBA automation
- –Anyone who only uses the 2016 or 2019 perpetual-license version of Excel
- –Anyone who uses Excel on an iPad or Android device
Can we use it at work?
The questions that adoption leads and security teams ask first.
Note: organizations with compliance requirements should re-check the Compliance API coverage and retention policy in the official documentation.
10-minute quick start
- 1
Get a paid Claude account (Pro, Max, Team, or Enterprise).
- 2
Find the “Claude for Microsoft 365” add-in on Microsoft AppSource and install it. The add-in itself is free to install.
- 3
Open Excel, turn on Claude from Add-ins on the Home tab, and log in with your Claude account.
- 4
For important files, make a copy and test on that first. Start with questions; edits come after.
Copy-and-paste prompts
Replace only the [bracketed] parts, then paste it in.
Explain step by step what calculations produced the number in [cell address]. Point out the source cells it relies on.
Change [assumption] to [new value] and update all linked calculations. Show me the list of items that will change first, then apply it.
Find the cause of the error in the cell on the [sheet name] tab. Suggest a fix, but don’t change anything until I’ve checked.
Sort the table in [range] by [criteria], and add conditional formatting to rows that meet [condition]. Don’t change the original values.
Scan the tabs in this workbook and create a new summary sheet for executive reporting. For each figure, show which cell on which sheet it came from.
Using it with other tools
Linking two or three tools changes your work more than any single tool does.
Numbers in Excel, prose in Claude
Results table to slides
Before you start
- Don’t run it on your original file. It’s safer to get into the habit of trying it on a copy first.
- Files containing macros are out of scope. The official documentation explicitly states that VBA is not supported.
- Files from outside your organization may contain hidden instructions. Read every confirmation prompt before you click.
- Have a person re-verify any calculation used for audits or approvals. The official documentation draws the same line.
Pricing: personal use and work use
Plans that individuals pay for are different from plans that organizations contract for by member.
For individual use
Claude in Excel is not included in the free plan
Includes Claude in Excel — a good starting plan for beginners
Includes Claude in Excel · 5x and 20x the usage of Pro
Using it at work
Includes Claude in Excel · More usage than Pro, with member and billing management in one place
Includes Claude in Excel · 5x the usage of Standard, plus Claude Code and Claude Cowork
Includes Claude in Excel · SCIM, audit logs, custom data retention, role-based access control
Checked on 21 Sep 2026 · Claude in Excel is not priced separately. It is included in Claude plans (except the free plan). The amounts below are what Claude’s official pricing page shows, in US dollars, when accessed from Korea. Whether tax is included depends on your country, so they may differ from US prices. Prices change without notice, so check the official page before you pay. Claude official pricing ↗ · Claude for Excel official docs ↗
Agentic AI — the version that does the work itself
It doesn’t just answer questions. This add-in works through multiple steps on its own inside the workbook, editing values and building tables.
Claude for Excel add-in
It reads the open workbook and answers with cell-level citations. It changes values or fills in new models while preserving formula relationships, and it also handles sorting, filtering, PivotTables, and conditional formatting.
- Install from the marketplace — find the “Claude for Microsoft 365” listing on Microsoft AppSource and click Get
- Enable the add-in in Excel and sign in with your Claude account
- Organization rollout — admins assign it to users or groups under Integrated Apps in the Microsoft 365 admin center
Setup steps and requirements are based on the official documentation. Claude for Excel official docs ↗ · Claude official pricing ↗
Where Claude in Excel falls short
We don’t just list the positives. Here is what fell short when we used it.
- It slows down on large tables
The larger the sheet and the more tangled the formulas, the longer you wait for a response. Sending only the range you need is faster than handing over a ledger with tens of thousands of rows.
- You end up recounting the results yourself
The formulas it writes are mostly right, but one cell is sometimes off, so you end up checking totals separately. Some days that means you don’t save much time.
- Installation may require approval
Because it’s an add-in, company policy may require administrator approval before it will open. That makes it hard to install on the day of training, so request approval in advance.
Tools to compare
FAQ
Last updated 22 Sep 2026 · The ratings on this page come from John Kim, CEO of Nanum Consulting, who has used these tools firsthand in training and real work.
Claude in Excel as an organization-wide skill
Send us a message and we’ll reply within 24 hours. We’ll propose a curriculum tailored to your industry and job roles.