Claude in Excel: what it does well and where to check its work
Claude for Excel is Anthropic's add-in for Excel on the web, Windows and Mac, available on the Pro, Max, Team and Enterprise plans. It is good at explaining how a figure was built, with clickable cell citations, at finding the cause of formula errors and at changing an assumption while keeping formulas intact. Check its work by following the citations, looking for hidden rows and typed-over values, and reviewing every change before the file goes to anyone else.
What the add-in is
Claude for Excel runs in a side panel inside Excel and works on the workbook you have open. You install it from the Claude for Microsoft 365 listing on Microsoft AppSource and sign in with your Claude account. Usage counts against the same limits as the rest of your Claude account.
It is a different thing from the Microsoft 365 connector. The connector lets Claude search SharePoint, OneDrive and Outlook from a Claude chat. The add-in works inside one open workbook, and it shares context with the Claude add-ins for PowerPoint, Word and Outlook.
- Supported: Excel on the web, Excel on Windows with a Microsoft 365 subscription (build 16.0.13127.20296 or later) and Excel on Mac (version 16.46 or later).
- Not supported: Excel 2016 and 2019 perpetual or volume licences, Excel on iPad and Excel on Android.
Tasks it does well
- Explaining a figure. Ask how a total or margin is calculated and the answer cites the cells it relies on, which you can click to go to.
- Tracing assumptions. Ask which inputs drive a forecast and where they sit across tabs.
- Finding errors. Ask why a cell shows #REF! or #DIV/0! and Claude looks for the root cause and suggests a fix.
- Changing an assumption. Anthropic says Claude updates the value while keeping formula relationships intact, so dependent cells recalculate.
- Filling a template or building a first model from a description.
- Everyday operations: sorting, filtering, editing pivot tables, conditional formatting and data validation drop-downs.
- House rules. Instructions in the add-in's settings, such as euro amounts with thousand separators, apply to every conversation in Excel.
Where Anthropic says to be careful
- Anthropic does not recommend it for final client deliverables without human review, for audit-critical calculations without verification, or for highly sensitive or regulated data without proper controls.
- Data tables, macros and VBA are not supported.
- Files from outside the business, such as downloaded templates or supplier spreadsheets, can contain hidden instructions. Anthropic advises using the add-in only with trusted spreadsheets.
- Claude warns before overwriting existing data and asks you to confirm risky operations. Read those confirmations rather than clicking through.
Five checking habits
- Follow the citations. Click each cited cell and confirm it holds what the answer says, for the right period and in the right units.
- Check the formula, not just the value. A total that looks right can be a typed number sitting where a formula used to be.
- Look for what is out of sight. Unhide rows and columns, clear filters and check other tabs before you accept a total or an explanation.
- Trace what depends on a change. After an edit, use Excel's own Trace Dependents and check the summary tab, charts and any linked sheet.
- Work on a copy. Anthropic recommends starting from a trusted copy before asking for wide edits, so you can compare before and after.
The same checks apply to any AI tool in a spreadsheet. See did the workbook actually change?
A worked example on made-up figures
A fictional office has a quarterly overheads sheet. The manager asks Claude: 'Why are Q3 overheads higher than Q2? Cite the cells.' The figures are below. Cleaning sits on a hidden row.
| Line | Q2 | Q3 | Change |
|---|---|---|---|
| Rent | €12,600 | €12,600 | €0 |
| Insurance | €1,950 | €1,950 | €0 |
| Software | €3,300 | €3,540 | +€240 |
| Electricity | €2,400 | €2,880 | +€480 |
| Cleaning (hidden row) | €1,170 | €1,170 | €0 |
| Total | €21,420 | €22,140 | +€720 |
What to check in the example
A good answer says the €720 rise comes from software (+€240) and electricity (+€480), and cites those cells. Click both. Then unhide the rows: cleaning is unchanged, so the explanation holds, but the total only reaches €21,420 and €22,140 because the hidden row is included. If someone later copies the visible rows into a report, the figures will not add up.
Next, click the two total cells. If either is a typed number rather than a SUM, the sheet can look consistent today and break next quarter. Finally, if you ask Claude to raise Q4 electricity by 10% on Q3, the new figure should be €3,168. Check that the Q4 total and any summary tab moved with it, then save and reopen the file before you send it.
Setting it up for a team
Administrators can deploy the add-in from the Microsoft 365 admin centre under Settings, Integrated apps, Add-ins, assigned to the whole organisation or to chosen groups. Anthropic notes a known Microsoft issue: deployment fails when the admin role is activated through Entra Privileged Identity Management, so use an account with the role permanently assigned.
On data, Anthropic says inputs and outputs are deleted from its systems within 30 days, while chat history is kept in the browser on that device. The add-in does not follow any custom retention period your organisation has set, and its activity is not included in Enterprise audit logs, although Enterprise organisations using the Compliance API do get its sessions.
Which plan includes the add-in, and what it costs, is set out in Claude pricing in Ireland.
Common questions
Which Claude plans include Claude for Excel?
Anthropic lists it as generally available on Pro, Max, Team and Enterprise. It is not on the free plan.
Does Claude for Excel work with Excel 2019?
No. Anthropic lists Excel 2016 and 2019 perpetual or volume licences as unsupported, along with Excel on iPad and Android. It runs on Excel on the web, Excel for Microsoft 365 on Windows and recent Excel for Mac.
Can Claude run or write macros in Excel?
Not through the add-in. Anthropic lists macros, VBA and data tables as unsupported.
Is Claude for Excel the same as the Microsoft 365 connector?
No. The connector lets Claude search SharePoint, OneDrive, Outlook and Teams from a chat, and needs a Global Administrator's approval. The add-in works inside an open workbook and is installed from Microsoft AppSource or deployed from the Microsoft 365 admin centre.
For help putting this into practice, see Claude implementation and training for Irish businesses.
Sources and product references
Checked 16 November 2026. Features and access can change, so check what your own licence includes.
Editorial guidance informed by Acuity's work with teams. Examples are fictional and client materials stay private. To record who owns an AI use and when it is reviewed, see AI Register.
