Claude for Excel is an Anthropic add-in that explains formulas and edits the workbook you have open in Excel. If you inherit a commission workbook, you can trace a trail total back to its source cells before you touch the formula. Try it on a copy with invented figures so you can check its work without sharing client records.
What Claude for Excel Does
Claude for Excel opens a sidebar beside your worksheet. It can read across tabs and explain which cells feed a total. Its answers can include clickable cell references, so you can go straight to the formula or value it used.
You can also ask Claude to build a table, add formulas or change inputs in the open workbook. Scope a request to the sheet and range you expect to change. Review the edits in Excel before saving, especially if the workbook feeds a broker’s commission report.
How to Install Claude in Excel
Install the Claude add-in from Microsoft AppSource, then sign in with your paid Claude account. Anthropic supports Excel on the web, Microsoft 365 Excel for Windows from build 16.0.13127.20296 and Excel for Mac from version 16.46 (build 21011600). The add-in excludes Excel on iPad and Android and perpetual or volume-licensed Excel 2016 and 2019.
- Open Claude for Microsoft 365 in Microsoft Marketplace. Select Get it now.
- Open Excel and activate Claude from Add-ins. On Mac, find Add-ins under Tools. On Windows, look under Home.
- Sign in to Claude in the sidebar. Open a scratch workbook with a known value in A1, then ask Claude to identify the value and cite its cell.
If Claude is missing from Add-ins on a work account, ask your Microsoft 365 administrator whether the Office Store is blocked or the add-in needs to be assigned to you. If the sidebar opens but you can’t start a chat, check that you’re signed in to the account with the paid plan.
Use Claude on a Commission Workbook
Use Claude for Excel to trace an inherited workbook before asking it to change any figures. In this hypothetical example, an Expected sheet lists forecast trail by loan. A Statement sheet lists what the aggregator paid. A Recon sheet brings the two amounts together.
- Ask what feeds
Recon!B2(expected trail) andRecon!C2(paid trail), with cell citations and no edits. Follow each citation and confirm both amounts use the same loan reference and statement period. - Suppose C2 shows a reference error because its formula points to a deleted column. Ask Claude to locate the invalid reference and propose a replacement. Check that the replacement points to the paid-trail column on
Statementand matches the loan reference before applying it. - Ask Claude to add a variance column in D that subtracts expected trail from paid trail, starting with
=C2-B2. Review the changed cells and spot-check the results against the source rows. Clone the formula down only once the first result agrees.
If the invented loan L-01 had $120 expected and $105 paid, the variance should be negative $15. For a second row with $90 expected and $90 paid, it should be zero. Leave a missing statement match visible for review so it stays distinct from a confirmed zero payment. See the guide to tracking trail commissions for the monthly reconciliation process.
Keep Client Data Out of the Add-In
Use a fresh, de-identified copy because the add-in sends prompts and workbook content it reads to Anthropic when you connect directly with a Claude account. Keep the formulas you need and replace loan references, names and financial figures with invented values. Check hidden sheets, comments and links to other workbooks for information left behind. Start a new chat so the copy doesn’t pick up an earlier conversation.
Training and retention have separate controls. For a personal Claude account, look in Settings under Privacy for Help Improve our AI models. Anthropic says it excludes Team and Enterprise content from model training by default.
Anthropic’s Excel data-handling guidance gives a backend deletion window of 30 days for add-in inputs and outputs, subject to exceptions. The add-in has its own retention rules even if your organisation sets a custom Claude retention period. Clearing its chat history removes the local copy. Use the Claude safety guide to check what your brokerage can share before using real records.
Claude for Excel Pricing and Plans
Claude for Excel requires a paid Claude plan for the standard account sign-in. Anthropic’s plan comparison lists Microsoft 365 add-in access on Pro, Max and Ultra for individuals and on Team and Enterprise for organisations.
Individual subscriptions differ in included usage. Team bills by seat, with standard and premium seats and a choice of monthly or annual billing. Enterprise combines a seat fee with metered usage, so the model and the amount of work affect cost. Add-in work counts towards the Claude account’s usage limits. Budget separately for Microsoft 365 if your Excel setup requires it.
Claude for Excel vs Copilot and ChatGPT
Claude for Excel and Copilot in Excel both work in the open workbook. ChatGPT file analysis starts with a spreadsheet you attach to a chat. That distinction decides which copy of your figures the assistant can see and where edits land.
| Tool | Workbook access and edits | Data controls |
|---|---|---|
| Claude for Excel | Reads the open workbook across tabs and can write formulas or values in place. | Anthropic’s add-in retention rules apply when you connect directly. |
| Copilot in Excel | Works from Excel’s own Copilot pane and can make changes to the open workbook. | Microsoft’s commercial Copilot policy excludes prompts, responses and data accessed through Microsoft Graph from foundation model training. |
| ChatGPT for Excel workflows | In file analysis, ChatGPT uses the copy you attach. Review any returned file or apply the suggested edits yourself. OpenAI also has a separate Excel add-in for in-place editing. | Personal ChatGPT accounts have an Improve the model for everyone setting. OpenAI excludes Business and Enterprise workspace content from training by default. |
Claude Code is a coding tool that can help you write and run a script to process spreadsheet files. Claude Cowork can work across multiple files from folders you connect through the desktop app. When you need to trace a single figure as you inspect its cells, start in the Excel sidebar with a test copy.


