Claude for Excel: What It Does, Cost, Mac and Setup (2026)

Claude for Excel is Anthropic's official add-in that puts Claude in a sidebar inside Excel. It reads your workbook, answers questions with links to the exact cells it used, writes and fixes formulas, cleans data, builds pivot tables and charts, and can build a full model from scratch. The add-in itself is a free install, but you need a paid Claude plan to use it: Pro, Max, Team or Enterprise. The cheapest option is Claude Pro at $20 a month. It works in Excel on the web, Excel for Windows with a Microsoft 365 subscription, and Excel for Mac version 16.46 or later. It became generally available on May 7, 2026. This guide covers what it can do, real prompts to try, its limits, and how it compares to the other ways of using Claude with spreadsheets, as of October 2026.

TL;DR

A quick note on the name

You'll see this product called a few different things, and they all mean the same add-in:

• Claude for Excel is the name most people search for, and the name on Anthropic's Excel docs page (opens in a new tab).
• Claude for Microsoft 365 is the current official name. When Anthropic made it generally available, it became one add-in that covers Excel, PowerPoint and Word (Anthropic's announcement (opens in a new tab)). Outlook has its own separate listing, still in beta.
• Claude by Anthropic for Excel is how some older articles and listings referred to it.
• Claude Excel plugin, extension or download all mean this same thing too. It's an Office add-in. It isn't a browser extension, and there's no separate app to download. You add it inside Excel.

One thing that is not the same: "Claude in Excel" through Microsoft Copilot. Microsoft lets some Copilot users pick Anthropic's models inside Copilot. That's a Microsoft product with Microsoft licensing. We compare the two further down.

How to install Claude for Excel in 3 steps

1. Open the Claude for Microsoft 365 listing on Microsoft AppSource (opens in a new tab) and select Get it now.
2. Open Excel and find the add-in. On Windows it's under Home > Add-ins. On a Mac it's under Tools > Add-ins.
3. Open the Claude sidebar and sign in with your Claude account (Pro or higher).

That's it for most people. If you're on a work computer, your IT admin may need to allow Office Store add-ins or deploy it for you. For admin steps, screenshots and fixes for when the add-in won't show up, read the full guide: how to install Claude for Excel.

Tip: once it's installed, open the sidebar's Settings and fill in the Instructions field. Anything you put there (your company's number format, "always put assumptions on a separate tab," your fiscal year start) gets applied every time. These instructions are Excel-only, separate from the ones you set in PowerPoint or Word.

What can Claude do in Excel?

According to Anthropic's overview (opens in a new tab), Claude can "read and write cells, formulas, formatting, pivot tables, and charts." In practice, that breaks down into a few big jobs:

• Answer questions about your workbook with clickable citations that jump you to the exact cell it used.
• Change assumptions while keeping the formulas connected, so everything that depends on them recalculates.
• Find and fix errors like #REF! and #DIV/0!, and trace them back to the cause.
• Build new models or fill in a template you already have, across multiple tabs.
• Do the native Excel chores: sort, filter, edit pivot tables, add conditional formatting and set up dropdown lists with data validation.

It also has a couple of safety features worth knowing about. It warns you before it overwrites data that's already there, and it asks you to confirm before risky changes. And if you use Claude for PowerPoint or Word too, they share the same conversation, so you can build a chart in Excel and then ask Claude to drop the numbers into a slide.

Here are eight real jobs with prompts you can copy. Swap the bracketed parts for your own details.

1. Clean up a messy export

Bank exports, CRM downloads and anything from accounting software tend to arrive with extra spaces, mixed date formats and duplicates.

Look at the [Sales Export] sheet. Clean it up on a new tab called
"Clean": trim extra spaces, make all dates the same format, split the
"Name" column into First and Last, and flag (don't delete) any rows
that look like duplicates. Then tell me what you changed and how many
rows were affected.

Asking it to flag instead of delete keeps you in control. You can delete them yourself once you've looked.

2. Explain a workbook you inherited

Someone left, and now you own their 14-tab spreadsheet. This is where the cell citations really pay off.

I just inherited this workbook. Walk me through it: what each tab is
for, where the inputs live, which cells are hardcoded numbers versus
formulas, and how the tabs feed into each other. Point me to the
cells you're describing so I can check them.

Follow up with questions like "where does the number in Summary!C12 come from?" and click the citations to see for yourself.

3. Build a simple model from scratch

Anthropic's own examples include building a three-statement model from a trial balance and filling an LBO template. You don't need to be a finance person to use the same approach for something simpler.

Build a 12-month cash flow forecast for a small business on a new tab.
Put all assumptions (starting cash, monthly revenue, growth rate,
fixed costs, variable cost %) in a clearly labeled block at the top
so I can change them. Use formulas that reference the assumptions,
not typed-in numbers. Add a row that shows the lowest cash month.

If you work in finance, Claude for finance covers the DCF, comps and three-statement workflows in more depth. For a household budget, see Claude for personal finance.

4. Trace a #REF! or #DIV/0! error to the source

Errors in Excel spread. One broken cell can turn a whole summary tab into #REF!. Claude can follow the chain back to the first bad cell.

The Summary tab is showing #REF! in several cells. Trace the errors
back to their root cause, tell me which cell started it and why it
broke (for example, a deleted row or column), and suggest a fix. Don't
change anything until I say so.

5. Make a pivot table and a chart

From the [Orders] sheet, make a pivot table on a new tab showing total
revenue by region and month. Then add a clustered column chart of
revenue by region. Give the chart a clear title and label the axes.

Because Claude builds a real pivot table and a real Excel chart, you can keep editing them the normal way afterward.

6. Run what-if scenarios

Claude can change your inputs and keep everything linked, which makes it handy for quick scenario thinking.

Using the assumptions on the Inputs tab, set up three scenarios on a
new tab: base case, a downside where revenue growth is half of base,
and an upside where it's 1.5x. Show net profit and ending cash for
each side by side. Don't overwrite my current inputs.

Note: Excel's built-in What-If data tables aren't supported by the add-in. Claude builds scenarios with regular formulas instead, which is usually easier to read anyway.

7. Write or fix a formula

In column F, I need the total sales for each rep in column A, but only
for orders in column C marked "Closed" and dated this quarter. Write
the formula, explain each part in plain English, and fill it down.

For one-off formulas like a quick lookup or a conditional sum, our free Excel formula generator is faster. Pick the task, fill in your ranges and copy the formula. Save Claude for the jobs that need it to look at your actual workbook.

8. Add dropdowns and highlight problems

On the Tracker tab, add a dropdown in the Status column with the
options Not started, In progress, Done and Blocked. Then add
conditional formatting that turns the row light red when Status is
Blocked or when the Due Date has passed and Status isn't Done.

Using skills and connectors

If you've turned on skills in your Claude account, they work in the add-in too. Type / in the sidebar to pick one. Connectors you've enabled also carry over. Anthropic names financial data sources like S&P Global, LSEG and Daloopa as examples. If you haven't set those up yet, start with our guide to Claude connectors.

Limits and what to verify

Claude for Excel is good, but it isn't an auditor. Here's what Anthropic says it can't do or shouldn't be trusted with, from its Excel docs (opens in a new tab) and performance guide (opens in a new tab):

• No macros or VBA. It won't write, run or edit them.
• No What-If data tables. Use regular formula-based scenarios instead.
• It reads big sheets in pieces. Each read pulls up to 2,000 cells with data, so on large sheets it works step by step. Anthropic says it works well under about 1 million used cells, gets riskier between 1 and 5 million, and above 5 million is "use at your own risk."
• Long steps can time out. If Excel seems to hang, wait rather than clicking repeatedly. If a step times out, save your file and ask for a smaller piece of the job.
• Only use trusted spreadsheets. A file from a stranger could contain hidden text meant to steer Claude. Anthropic's own advice is to stick to spreadsheets you trust.
• Not a substitute for review. Anthropic doesn't recommend it for final client deliverables without review, for audit-critical calculations without checking, or for sensitive or regulated data without proper controls.
• Chat history stays on that device. Conversations are stored locally in your browser, not synced, so a chat on your work laptop won't show up on your home computer.

What to check every time:

1. Click the citations. If Claude says revenue grew 12%, click through and confirm the cells it used are the right ones.
2. Spot-check a few formulas by hand. Pick two or three cells and make sure the logic matches what you asked for.
3. Look for hardcoded numbers. Ask "are there any typed-in numbers in this model that should be formulas?"
4. Save a copy first before you let it make big changes. It warns before overwriting, but a backup costs nothing.

Speed tips for big files: tell Claude exactly which sheet or range to look at, split large jobs into smaller asks, and for heavy formula edits set calculation to Manual, then press F9 when it's done.

Claude for Excel vs Copilot vs claude.ai vs Google Sheets

There are four common ways to get Claude's help with a spreadsheet. They're different products, and the right one depends on which tools and licenses you already have.

Claude for Excel vs Copilot

Both are solid choices, and both can use Claude models. The difference is whose product you're using.

Microsoft Copilot in Excel lets you choose a model, including the latest Anthropic and OpenAI models, from a picker that defaults to "Auto" (Microsoft Support (opens in a new tab)). It needs a commercial Copilot subscription, and an admin has to enable Anthropic models for your organization. Your model choice only lasts for that session. Its advantages: it's built into Microsoft's own tools, it's covered by your existing Microsoft agreement, and it runs on iPad, which the Anthropic add-in doesn't.

Claude for Excel is Anthropic's own add-in. You sign in with a Claude account, it counts against your Claude plan's usage, and you get Anthropic's features: clickable cell citations, your Claude skills and connectors, and one shared conversation across Excel, PowerPoint and Word.

A simple way to decide: if your company already pays for Copilot and wants everything under Microsoft's terms, ask your admin to turn on the Anthropic models. If you already pay for Claude, or you're a small team without Copilot, the Anthropic add-in is the direct route.

Can Claude read Excel files without the add-in?

Yes. On claude.ai (opens in a new tab) you can upload an .xlsx file and ask questions about it, as long as Code execution and file creation is turned on under Settings > Capabilities. Anthropic says you must have it on to upload XLSX files (upload files to Claude (opens in a new tab)). It's on by default for Free, Pro and Max. On Team and Enterprise, the workspace owner controls it.

Claude can also create Excel files with working formulas that you download (create and edit files (opens in a new tab)). Anthropic's help pages list a few different file size limits, so keep spreadsheets under 30MB to be safe. Two catches: Claude only reads the text and numbers, not images embedded in the sheet, and file creation uses more of your usage limit than regular chat.

This route works on the free plan, which makes it the cheapest way to try Claude on a spreadsheet. The trade-off is all the uploading and downloading. You can't watch it work inside your live workbook.

What about Google Sheets?

Anthropic launched Claude for Google Workspace in public beta on October 6, 2026, for paid plans (Anthropic (opens in a new tab)). One install covers Docs, Sheets and Slides. In Sheets it can build models, write and fix formulas, clean data, and make pivot tables and charts. It only works on Google files, so you'd convert an Excel file first, and it doesn't work in Firefox. Since it's still in beta, expect some rough edges.

Who gets the most out of Claude for Excel

• Owners and operators who run the business out of spreadsheets: forecasts, pricing sheets, job costing, inventory.
• Finance and accounting teams building models, reconciling exports or checking someone else's work.
• Anyone who inherits spreadsheets they didn't build and needs to understand them fast.
• Ops and admin people who spend hours cleaning exports every week.

If you only touch Excel once a month to write one formula, you probably don't need a paid plan for this. The free formula generator or a quick chat on claude.ai will cover it.

Frequently asked questions

How much does Claude for Excel cost?

The add-in is free to install, but it only works with a paid Claude plan: Pro, Max, Team or Enterprise. Claude Pro is the cheapest at $20 a month, or $17 a month billed yearly. There's no extra charge for the add-in itself. Your Excel work counts against your normal Claude usage limits.

Does Claude for Excel work on Mac?

Yes. It works in Excel for Mac version 16.46 or later, Excel for Windows with a Microsoft 365 subscription, and Excel on the web. It doesn't work in Excel 2016 or 2019, on iPad or on Android. After installing on a Mac, you'll find it under Tools > Add-ins.

Can I use Claude for Excel on the free plan?

No. Claude for Excel needs a Pro, Max, Team or Enterprise plan. On the free plan you can still upload an Excel file to claude.ai and ask Claude about it, as long as code execution and file creation is turned on in your settings.

Can Claude read Excel files?

Yes. Inside Excel, the add-in reads the open workbook directly. On claude.ai, you can upload .xlsx files once the code execution and file creation setting is on, and Claude can create new Excel files with working formulas for you to download. Keep uploads under 30MB to be safe, and note that images inside the spreadsheet aren't read.

What's the difference between Claude for Excel and Copilot?

Claude for Excel is Anthropic's add-in. You sign in with a paid Claude account and get Claude's skills, connectors and cell citations. Microsoft Copilot in Excel is Microsoft's assistant, which can use Anthropic models if your admin turns them on, and it requires a commercial Copilot license. Pick based on which subscription your company already has.

Get more out of Claude

Claude for Excel is one piece of a bigger toolkit. If you want to learn how to set Claude up so it actually knows your business, with Projects, skills, connectors and file work across all your apps, our free Claude Cowork course walks you through it step by step, no technical background needed.

Next steps:

• How to install Claude for Excel, with admin deployment and troubleshooting
• Claude for finance, for DCFs, comps and financial models
• Claude for personal finance, for budgets and household spreadsheets
• Free Excel formula generator, for quick one-off formulas

Clarence