BonoficiGrade your business
Menu
Guide11 min read

Claude for Excel: a practical guide for finance and operations

What Claude for Excel does, how to install it, seven prompts for finance and ops work, how it compares with Copilot and ChatGPT, and where it stops.

Claude for Excel is Anthropic’s add-in that puts Claude in a sidebar inside Excel, where it can read the open workbook, explain formulas with links to the cells it used, fix errors, sort, filter, edit pivot tables and build or fill in models. It is included with paid Claude plans and installs from Microsoft’s add-in store. It works on the workbook in front of you, not on your ERP or accounting system, so every change still needs a human check.

Product details here are as of November 2026, from the vendors’ own help pages. They change monthly, so check the linked pages before you roll anything out.

What Claude for Excel is

It is an Office add-in. You open a sidebar, type a request in plain language, and Claude reads the sheets, answers, or makes the change in the cells. Anthropic’s help page lists what it can do:

  • Answer questions about the workbook, with clickable references to the cells behind the answer.
  • Change an assumption while keeping formulas intact, so dependent cells recalculate.
  • Find the root cause of errors such as #REF! or #DIV/0! and suggest fixes.
  • Build a new model, or fill in a template you already use, across several tabs.
  • Sort, filter, edit pivot tables, apply conditional formatting and add drop-down lists.
  • Use Skills (saved instructions for a task) and connectors to outside data sources.

It also shares context with Claude for Word, PowerPoint and Outlook (Outlook is in beta), so one conversation can take figures from a workbook into a report or an email draft. It does not handle data tables (the what-if kind), macros or VBA.

How to install it

Anthropic says the add-in is generally available on the Pro, Max, Team and Enterprise plans; the free plan does not include it. Use counts against the same usage limits as the rest of your Claude account. Plans and limits change, so check Claude’s plan page before you buy seats.

  1. Check your Excel version. Supported: Excel on the web, Excel for Windows with a Microsoft 365 subscription (build 16.0.13127.20296 or later) and Excel for Mac (16.46 or later). Not supported: Excel 2016 and 2019 bought outright, Excel on iPad and Excel on Android.
  2. Open the Claude for Microsoft 365 listing on Microsoft’s marketplace and select “Get it now”.
  3. Open Excel, activate the add-in and sign in with your Claude account.

If your company blocks add-ins, IT can deploy it for everyone or for chosen groups from the Microsoft 365 admin centre (Settings, Integrated apps), or upload Anthropic’s manifest file where the Office Store is switched off. Companies that already buy Claude through Amazon Bedrock, Google Cloud Vertex AI or Microsoft’s Azure AI Foundry can connect the add-in through those instead of individual Claude accounts.

One setting worth five minutes: the Instructions field in the add-in’s Settings. Whatever you put there applies to every Excel conversation, such as “dates as DD/MM/YYYY”, “amounts in GBP with thousand separators” or “never overwrite a column; add a new one next to it”.

Seven finance and operations tasks, with prompts

These are the jobs operations and finance teams tend to do by hand every week. The prompts are examples; change the sheet and column names to yours. Work on a copy of the file until you trust the result.

1. Reconcile two exports

Say the bank export is on one tab and the Xero or QuickBooks payments export on another.

“Match the rows on Bank to the rows on Ledger by amount and date (allow 3 days’ difference). Put matched pairs on a new tab called Matched, and everything unmatched on a tab called To check, with a column saying why it did not match. Don’t change the original tabs.”

2. Clean and deduplicate a supplier list

“Find likely duplicate suppliers on the Suppliers tab: same VAT number, or names that differ only by Ltd/Limited, punctuation or case. List each group with the row numbers and which record looks most complete. Don’t delete anything.”

Asking for a list rather than a deletion matters: two suppliers with similar names can be two legal entities with different bank details.

3. Build a pivot of late deliveries

“Add a column Days late = Received date minus Promised date, zero if negative. Then build a pivot table of late order lines by supplier and month, with count and average days late, sorted by count.”

4. Explain a formula someone left behind

“Explain what the formula in Summary!F12 does, step by step, and which cells it depends on. Flag any hard-coded numbers and any references to other workbooks.”

The cell references let you click through and check each step rather than trust the explanation.

5. Update a price list with rules

“On Prices, add a New price column: raise category A by 4% and category B by 2.5%, leave C unchanged, round to the nearest 0.05, and never go below Cost × 1.15. Highlight every row where the floor rule applied.”

6. Prepare month-end checks

“Using the trial balance on TB and last month on TB prior, list accounts that moved by more than 10% and more than £5,000, accounts with an unexpected sign, and suspense or clearing accounts that are not zero. One row per finding, with the figures.”

7. Check a supplier invoice export against POs

“Compare Invoices with Open POs by PO number and line. Flag price differences over 2%, quantities invoiced above quantities received, and invoices with no PO.” That is a manual version of a three-way match; useful for a one-off review, not as your payment control.

Claude for Excel, Copilot in Excel and ChatGPT compared

All three now work inside the workbook. The differences are in licensing, admin control and what each cannot do yet.

Claude for ExcelCopilot in ExcelChatGPT for Excel
Who makes itAnthropic, as an add-inMicrosoft, built into ExcelOpenAI, as an add-in (also for Google Sheets)
Which plansPaid Claude plans (Pro, Max, Team, Enterprise)Depends on your Microsoft 365 subscription and tenant settings; Microsoft lists the eligible onesAll ChatGPT plans, with limited use on Free and Go
Edits the workbookYes, warns before overwriting dataYes, in edit mode; plan and chat-only modes tooYes, asks permission before changes
Reusable instructionsSkills and persistent instructionsCustom skills, including recorded from a demonstrationSkills, including default finance ones
Stated gapsNo data tables, macros or VBAEdits only with calculation set to AutomaticPower Query, data model and VBA not (fully) supported

A few points that matter more than the table. Copilot in Excel can run on Claude or GPT models, according to Microsoft’s FAQ, once an enterprise admin has enabled Anthropic as a sub-processor, so “Claude or Copilot” is partly a question of which contract and admin console you prefer. Copilot sits inside your existing Microsoft agreement, which makes it the easier first choice if your IT team already manages Microsoft 365 Copilot. OpenAI’s help article says its add-in keeps spreadsheet chats separate from your main ChatGPT history and memory, and on Enterprise workspaces an admin has to switch it on.

The older route still works: upload the file to a ChatGPT or Claude chat. ChatGPT then analyses it by writing and running Python code and answers with tables and charts. That is fine for a one-off analysis, but you are working on a copy: nothing lands back in your live workbook. If your team works in Google Sheets, Anthropic has a separate Claude for Google Workspace add-on, in beta, that only works on native Google files.

For the wider choice of assistant for a whole team, see Claude vs ChatGPT for business.

Where it stops

  • It works on the workbook, not your systems. It can tell you which invoices don’t match, but it does not post anything to Sage, NetSuite or SAP, and it has no approval trail there. The export it reads is already out of date when you open it.
  • Outputs need checking. Anthropic itself says not to use it for final client deliverables without review or for audit-critical calculations without verification. Tie totals back to the source before and after every change: row counts, sum of amounts, number of suppliers.
  • Large and messy files. Long conversations are compacted automatically into new ones, and OpenAI warns that very large workbooks may not fit in its add-in’s context and can give partial results. Expect the same from any assistant: split the job by tab or by month rather than asking for everything at once.
  • Files from outside. Anthropic warns that downloaded templates and supplier files can hide instructions that trick the add-in into extracting or changing data. Use it on workbooks you trust, and read the confirmation before a risky operation runs.
  • Exceptions. It applies the rule you gave it. The credit note booked as a negative invoice, the supplier who invoices in kilos: if those are not in the prompt, they end up wrong or silently skipped. Our lesson on documenting the exceptions is the list to bring.

Data and privacy

When you sign in with a Claude account, the add-in sends your conversation to Anthropic, including what Claude reads from the workbook. Anthropic’s page says inputs and outputs are deleted from its systems within 30 days, with exceptions set out in its privacy centre, and that chat history is kept locally in your browser. For Enterprise admins it notes that the add-in does not follow custom retention settings and is not in the Enterprise audit log, though it is covered by the Compliance API.

  • Business or personal plan. Pro and Max are consumer plans: whether your chats help train models depends on a privacy setting. On commercial plans (Team, Enterprise, API) Anthropic says it does not train on your inputs and outputs by default. Staff using a personal account on a company file is the case to rule out.
  • What not to paste or open. Payroll, employee health or disciplinary data, customer bank details and card numbers. Delete columns the task does not need first.
  • GDPR. If the sheet holds personal data of people in the EU or UK, the usual rules apply: a reason to process it, a data processing agreement with the vendor, and knowing where data is processed. Check the vendor’s terms with whoever handles data protection.

If you don’t have a written rule for this yet, our AI acceptable use policy template covers which data may go into which tools.

A prompt sheet for repeatable tasks

Keep one row per repeated task in a shared workbook. It stops five people writing five versions of the same prompt, and it is the draft of a Skill.

Prompt sheet: repeatable Excel tasks

Task name: e.g. Weekly bank-to-ledger reconciliation

Owner: the role that runs it and answers questions about it

When: trigger and frequency, e.g. every Monday after the bank export

Input files and tabs: names, where they come from, which columns matter

Columns to remove first: anything personal or not needed

Prompt: the exact wording, including “don’t change the original tabs”

Rules: matching keys, tolerances, rounding, date formats

Known exceptions: each one, and what to do with it

Expected output: new tab names, columns, and what “done” looks like

Checks: control totals to compare (row count, sum, count by status)

Who reviews: role, and what they sign off before the result is used

Last tested: date, and the case that last went wrong

When a spreadsheet task should become a workflow

An assistant in Excel is the right tool when a person is in the loop anyway and the result is a file. It is the wrong tool when the same task runs every day, the output has to be keyed into another system, or a mistake costs money before anyone looks. Signs you have crossed that line:

  • Someone exports, prompts, copies the result back into the ERP and does it again tomorrow.
  • The prompt sheet row for the task has more exceptions than rules.
  • Two teams run the same task and get different answers, because each has its own version of the rule.
  • You need an audit trail of who approved what, not a chat history in one person’s browser.

At that point the job belongs in software that reads and writes your systems directly, with approvals, and the spreadsheet goes back to being a place to look at numbers. Our guide to AI for ERP covers the options.

If you want to see which of your processes would gain most from that, the free Bonofici grader reads your company’s public pages and shows where to start.

Start with what your team already knows.

Book a 30‑minute call.We come back with the first three tools worth building, in writing.

Not ready for a call?

See where your company stands and which jobs are worth the most, from your public pages.