Hizmedia Intelligence, home

Features

Claude for Excel: what it does and how to use it safely

By Hizmedia Intelligence3 min readUpdated

Spreadsheets are where a lot of business thinking happens, and where a lot of time goes. Claude for Excel brings Claude into the workbook itself, so you can ask how a number was calculated, change an assumption or chase down an error without leaving Excel. Here is what it does, how to set it up and how to use it safely.1

What Claude for Excel is

Claude for Excel is an add-in that brings Claude into Excel on the web, Windows (with a Microsoft 365 subscription) and Mac. Anthropic lists it as generally available on its Pro, Max, Team and Enterprise plans, and it uses your existing Claude account and its usage limits.1

What it can do

  • Answer questions about an open workbook, with citations you can click to jump to the cells it used.
  • Change assumptions while keeping formula relationships intact, so dependent cells recalculate correctly.
  • Find the root cause of errors such as #REF! or #DIV/0!, and suggest fixes.
  • Build a new model from a description, or fill in an existing template.
  • Work across multi-tab workbooks, and handle everyday tasks like sorting, filtering, pivot tables, conditional formatting and dropdowns.1

Good first prompts are simple and specific:

  • Walk me through how the total in cell C42 is calculated.
  • What assumptions drive the margin forecast on the Summary tab?
  • Change the growth rate to 5% and show me what changes.
  • Find the source of the #REF! error on the Summary tab.

Setting it up for your team

  1. Individuals can install the Claude for Microsoft 365 add-in from Microsoft AppSource and sign in with their Claude account.
  2. For the whole organisation, a Microsoft 365 admin can deploy it from the Admin Center under Integrated apps, to everyone or to chosen groups.
  3. Set persistent instructions in the add-in, such as number formats and currency, so every conversation follows your conventions.1

Limits and data handling

Anthropic says Claude for Excel is not recommended for final client deliverables without human review, audit-critical calculations without verification, or models containing highly sensitive or regulated data without proper controls. It does not support Excel data tables, macros or VBA.1

Conversations, including the content Claude reads from your workbook, are sent to Anthropic. Inputs and outputs are deleted from Anthropic's systems within 30 days, with stated exceptions, and chat history is kept locally in your browser. On Enterprise plans, the add-in does not inherit custom retention settings and its activity does not appear in audit logs, so check how it fits your policies.12

Use it safely

  • Only use it with trusted spreadsheets. Anthropic warns that files from outside sources can contain hidden instructions that try to manipulate the add-in.
  • Work on a copy of an important workbook before asking for wide changes.
  • Read every confirmation before you approve a change, and check results against your own judgement.
  • Keep personal and sensitive data out. Anonymise figures where you can; most analysis works just as well without names.1

Sources

Links checked

  1. 1Claude Docs. Use Claude for Excelclaude.com ↗
  2. 2Anthropic Privacy Center. How long do you store my organization's data?privacy.claude.com ↗
  3. 3Claude Help Center. Enable and use the Microsoft 365 connectorsupport.claude.com ↗

Want help with this?

Claude implementation, done properly.

We roll Claude out across your business: Claude Team or Enterprise setup, workspaces, access, data settings and connectors to your tools. UK and US.

Claude is a trademark of Anthropic, PBC. Plans and features change over time, so check Anthropic's current documentation for the latest details. This guide is general information, not legal advice.

Questions

Good questions.

Something else on your mind? Ask us directly.

Is Claude for Excel free?

It is included with Claude's Pro, Max, Team and Enterprise plans and uses your plan's usage limits. Check Anthropic's current pricing for your plan.

Can Claude for Excel run macros?

No. Anthropic lists macros, VBA and Excel data tables as unsupported.

Does Claude for Excel work on Mac?

Yes, on recent versions of Excel for Mac, as well as Excel on the web and on Windows with a Microsoft 365 subscription. It does not run on older perpetual-licence versions or on iPad.

From AI curious to AI capable

Find out what AI can do for your business.

Start with an audit. You will know exactly where AI fits, what to do first and what it should give back. Your report looks something like this.