Claude for Excel: how to use it on a spreadsheet you inherited

A spark mark standing for an AI helper reading a spreadsheet

Someone leaves, and their spreadsheet becomes yours. Twelve tabs, a summary sheet nobody dares touch, and one number at the bottom that the whole team quotes in meetings. You did not build it. You are now expected to update it by Friday.

The flashy Claude for Excel demo is “build me a model from scratch”. The useful one is “tell me what this thing does before I break it”. This guide walks through that second job, in order.

A note before we start: Mentus AI builds on Anthropic’s Claude models, so we have a commercial relationship with the company whose tool this is. We have tried to describe what the add-in is documented to do and where Anthropic itself says not to trust it.

Why reading comes before editing

Ray Panko summed up the research on spreadsheet mistakes in a paper for the 2015 EuSpRIG conference, a gathering of people who study spreadsheet risk. Errors are rare in any single cell, he wrote, but a large spreadsheet is very likely to contain at least one wrong bottom-line value. They are hard to find. And the people who build spreadsheets are overconfident that theirs are right.

So the workbook you inherited probably has a mistake in it, and its author probably did not know. If you start changing values before you understand the plumbing, you add your errors to theirs. An assistant that can read every formula and point at the cells it is talking about is a good fit for that problem, as long as you keep checking it.

Step 1: check you can run it

Anthropic made Claude for Excel generally available on 7 May 2026, alongside Word and PowerPoint, with Outlook in beta. According to Anthropic’s documentation, you need:

  • A paid Claude plan: Pro, Max, Team or Enterprise.
  • Excel on the web, Excel on Windows with a Microsoft 365 subscription, or Excel on Mac (version 16.46 or later).

It does not run on Excel 2016 or 2019 bought as a one-off licence, on the iPad or on Android. If your company already pays for Microsoft 365 Copilot, Anthropic says Copilot customers can also work with Claude models in Excel, so ask your IT team which route you have before paying for anything.

Step 2: install it and sign in

  1. Go to Microsoft’s AppSource store and find the listing called Claude for Microsoft 365, then select Get it now. If you would rather stay inside Excel, Microsoft’s own route for any add-in is Home > Add-ins > More Add-ins, then the Store tab and its search box.
  2. Open Excel and activate the add-in. On Windows it sits under Home > Add-ins; on a Mac, Tools > Add-ins.
  3. Sign in with your Claude account. A sidebar opens beside your sheet.

If the store is blocked on a work laptop, your administrator can deploy it for you.

Step 3: work on a copy

Save a copy of the workbook and open that one. Anthropic’s own best-practice list says to start with a trusted copy before asking Claude to edit widely, and it is the cheapest insurance you will ever buy.

While you are at it, ask yourself where the file came from. Anthropic warns that files from outside sources, such as downloaded templates and vendor files, can contain hidden instructions that try to manipulate the add-in into pulling out data or changing records. Its advice is blunt: only use it with trusted spreadsheets.

Step 4: ask for the map, then trace one number

Start broad. Type something like:

“Explain what each tab in this workbook does and how they feed into the Summary tab.”

Anthropic says answers come with cell-level citations you can click to jump to the cell being discussed. Click them. That is how you check the explanation against the sheet, rather than taking it on trust.

Then go narrow, to the one number everybody quotes. Anthropic’s own example prompt is the right shape:

“Walk me through how the revenue number in cell C42 is calculated.”

Swap in your cell. You want the chain: which inputs, which formulas, which tabs. Follow two or three of the citations yourself. If the explanation and the cells disagree, believe the cells. A language model can describe a formula confidently and still get it wrong, for reasons we explain in why ChatGPT makes things up.

[[photo:1]]

Step 5: hunt the errors

Now ask about what is broken or suspicious. Anthropic’s documentation gives prompts like:

“Find the source of the #REF! error in the summary tab.”

“Trace why cell H15 is returning #DIV/0.”

The quiet errors matter more, so also ask it to list formulas that do not match their neighbours, or hard-typed numbers sitting where a formula should be. Treat whatever it finds as a list of places to look, not a verdict.

Step 6: only then, change something

Once you understand the plumbing, make your Friday update. The documented pattern is to name the change and ask for the knock-on effects:

“Change the discount rate to 8% and update dependent calculations.”

Anthropic says Claude keeps formula relationships intact so downstream cells recompute, warns you before overwriting existing data, and asks you to confirm before it runs anything it judges risky. Read those confirmations properly. Then compare the new bottom line with the old one and ask yourself whether the size of the change makes sense.

Where to stop trusting it

Anthropic is unusually direct about the limits. It says the add-in is not recommended for final client deliverables without human review, for audit-critical calculations without verification, or for highly sensitive or regulated data without proper controls. It cannot handle data tables, macros or VBA, so a workbook that leans on macros will only be partly visible to it.

On data: the documentation says chat history is stored locally in your browser rather than on Anthropic’s servers, and that inputs and outputs are deleted from Anthropic’s backend within 30 days, with some exceptions set out in its privacy pages. If your employer has rules about what can leave the building, check them first.

If you already use Gemini in Google Sheets, the same habit carries over; our Google Sheets budget walkthrough covers the other side of the fence. The move worth keeping, whichever tool you use, is the order: map it, trace one number, find what is broken, and only then touch anything. Do it once on the inherited file this week and you will know that spreadsheet better than the person who built it.

Was this useful?

Sources

  1. Use Claude for Excel · Anthropic (Claude documentation)
  2. Collaborate with Claude across Excel, PowerPoint, Word and Outlook · Anthropic
  3. Get an Office Add-in for Excel · Microsoft Support
  4. What We Don't Know About Spreadsheet Errors Today: The Facts, Why We Don't Believe Them, and What We Need to Do · Ray Panko, EuSpRIG 2015 Proceedings (arXiv)