Claude for Excel: Setup and Uses for Accountants 2026
Adding Claude to Excel? See how the add-in installs, what it reads in a client workbook and which accounting tasks suit it before you rely on it.
- Published
- Updated
Claude for Excel puts Anthropic’s AI in a sidebar where it can explain formulas and edit an open workbook. Start with a fictional workbook.
What Claude for Excel Does in a Workbook
The add-in reads cells and formulas across tabs. Ask it how the balance on a summary sheet was calculated and follow its cell references back to the source.
Claude can trace a broken reference, summarise a sheet or build a model from your assumptions. It can change values and formulas in the workbook. Ask it to explain its proposed changes before you let it edit.
You decide which entries reconcile and which accounting treatment applies. Anthropic’s Excel instructions also list macros and VBA operations as unsupported.
How to Add Claude to Excel
Install Claude for Microsoft 365 from Microsoft Marketplace, then activate it in Excel.
Anthropic supports Excel on the web. The minimum desktop builds are 16.0.13127.20296 for Microsoft 365 Excel on Windows and 21011600 (version 16.46) for Excel on Mac.
- Open the Claude for Microsoft 365 listing and select Get it now.
- Open a fictional workbook. On Windows or the web, look under Home > Add-ins. On Mac, check Tools > Add-ins. Open the Claude add-in to display its sidebar.
- For direct Claude sign-in, use the Claude account on your practice’s plan. If you belong to several Claude workspaces, select the practice workspace.
- Put 17 and 23 in A1 and A2. Ask Claude to total A1:A2 and identify the cells it used. The expected result is 40.
In a managed Microsoft 365 organisation, the admin can allow Office Store access for staff installs. For central deployment, open Settings > Integrated apps > Add-ins, find Claude for Microsoft 365 and assign it to the approved users or groups.
If Office Store access stays off, Anthropic documents central deployment using its Excel manifest. Staff need access to the practice’s Claude plan when signing in directly to Anthropic.
Admins can also deploy through a supported third-party platform. That setup can work without individual Claude accounts.
- If the listing is missing or installation is blocked, ask your Microsoft 365 admin to check Store access or deploy the add-in to your group.
- If the admin deployed it but the pane is missing, check that Excel is signed in to the assigned work account. Reopen Excel after the assignment appears in the admin centre.
- Update Excel if your desktop build is too old. You can also use Excel on the web.
- For direct Claude sign-in, check your account has a paid plan or a seat in the practice workspace if the pane opens but sign-in fails.
Plans, Price and Free Access
Anthropic’s plan comparison includes the add-in on Pro, Max and Ultra for individuals. Max and Ultra have higher usage allowances. Team and Enterprise include the add-in through the practice’s workspace. Excel use draws on the plan’s existing limits.
The same comparison excludes the add-in from Claude Free. The Free plan can work with a spreadsheet uploaded to a Claude chat. For the cost of Claude for Excel, see Anthropic’s current plans and prices.
Client Workbooks and What Claude Can Read
When you connect directly to Anthropic, the add-in sends your conversation, workbook content Claude reads and any attached files. Naming a range in a prompt focuses the task. Approve the workbook as a whole before opening the add-in.
Anthropic says it deletes add-in inputs and outputs from its servers within 30 days, subject to exceptions. The browser keeps a local chat history. Clearing that history only clears the local copy.
Claude for Excel does not inherit your organisation’s custom Claude retention settings.
Check the storage rules for the add-in alongside your plan terms. With an individual plan, check the Model Improvement setting and the consumer terms on feedback and safety review. On Team and Enterprise, the commercial terms govern training.
Anthropic says it excludes commercial inputs and outputs from model training by default. It can use data you submit as feedback or explicitly permit it to use.
Record whether staff can use the assistant for each workbook. Before opening the add-in, make a copy and remove tax file numbers (TFNs), bank details and other identifying information. Check hidden sheets and comments.
The Tax Practitioners Board says registered tax practitioners need client permission before disclosing client information to a third party, unless a legal duty requires disclosure. That can include using an AI tool. Read the Board’s AI guidance.
The same principle of limiting what reaches a model applies to client forms. Tax Genie removes every TFN from submitted forms before its AI review.
Accounting Tasks and Prompts for Claude in Excel
Try these prompts on fictional data. Name the sheet and cell range so the person reviewing the result can reproduce the check.
| Job | Prompt | Check by Hand |
|---|---|---|
| Explain an inherited formula | Explain Summary!F12. Trace inputs from Detail!B2:E30 and list the cells that feed F12. Leave cells unchanged. | Open F12, trace its precedents and check whether the cited rows match its formula. |
| Reconcile two ledgers | Match LedgerA!A2:D50 to LedgerB!A2:D50 by reference and amount. Report unmatched rows and duplicate references in chat. | Check one matched pair against both sheets and confirm a duplicate was kept for review. |
| Find unusual period movements | Compare period amounts in PnL!B2:C30. In chat, list each account with an absolute movement above $1,000 and show the difference. | Subtract prior period from current for a flagged account. Check the sign and test a row exactly at the threshold. |
| Draft a workpaper note | Read Rec!A2:D12 and draft a note on what was reconciled and which differences remain. Cite the rows. | Tie each figure to its row and replace any unsupported explanation with the evidence available. |
| Build a depreciation schedule | Read cost in Assets!B2, residual value in C2 and useful life in D2. Build a straight-line schedule in Schedule!A2:D6 for five full years. | For fictional inputs of $12,000 cost, $2,000 residual value and five years, check that the annual charge is $2,000 and the closing value is $2,000. |
Check Formulas and Figures Before They Reach a Client File
Keep the original workbook untouched and make changes on a copy. Ask Claude to list each changed cell. Read every changed cell against the original, including any formulas downstream of a changed assumption.
Recompute one line by hand from the source data. If it differs, trace the discrepancy before copying anything back. Check that totals and unchanged ranges still match what you expect.
Record the source and review in your workpapers. The practitioner signing the work owns the tax treatment and the figures sent to the client.
Claude for Excel Versus Copilot and ChatGPT
All three products can edit a workbook. For a practice already licensed for Microsoft 365 Copilot, start with the built-in tool. If your practice already pays for Claude and has approved it for spreadsheets, use its existing plan allowance.
| Product | What It Reads | What It Changes | Licence | Where Data Goes |
|---|---|---|---|---|
| Claude for Excel | Cells and formulas across the open workbook | Values, formulas and model sections | Paid Claude plan for direct sign-in, or supported third-party deployment | Workbook content read, messages and attachments go to Anthropic on a direct connection. |
| Copilot in Excel | Workbook data and, for supported requests, work files you can access | Formulas, tables and worksheet content in editing mode | Eligible Microsoft 365 plan or Copilot subscription | Microsoft processes work prompts and responses under its Microsoft 365 commercial data terms. |
| ChatGPT for Excel | Relevant workbook context, your prompt and attachments | Can create or update spreadsheet content in the sidebar | Free and Go have limited access. Other plans have plan usage or credit limits. | OpenAI processes the request. Microsoft may also be able to read workbook content under its Marketplace terms. |
For mode and licence details, see how to use Copilot in Excel. If your practice uses OpenAI, see ChatGPT for Excel’s data handling terms.
Other Ways Claude Works With Excel Files
Yes, Claude can read an Excel file uploaded to chat. Ask it to analyse the upload or create a revised file to download. The add-in works directly on the workbook already open in Excel.
Claude Code is Anthropic’s coding tool. Use it to write and run a script that checks the same columns in a folder of ledger exports.
Claude Cowork is for multi-step work across files and tools you make available. For example, it can gather figures from documents into a new workbook. Anthropic is moving these capabilities into the main Claude experience.
A Claude skill is a set of reusable instructions. A practice could give it the steps for checking a reconciliation and the format to return. Enabled skills can also run inside the add-in.
One client form. One finished return.
Your client completes one guided form. Tax Genie checks it, chases mistakes and sends the details to your engagement letter and tax software.
Made for Australian accounting firms