Claude for Excel: Setup Guide and 10 Workflows

Claude for Excel is Anthropic's add-in that puts Claude in a sidebar inside Excel, where it explains formulas, traces errors, edits cells and pivot tables, and builds models in the workbook you already have open, with answers that cite the exact cells. It is generally available on every paid Claude plan (Pro, Max, Team, and Enterprise) and runs in Excel on Windows, Mac, and the web. The Free plan does not include it, but Free users can still upload an .xlsx file to a Claude chat and get analysis and a new workbook back.

This guide covers the five-minute setup, ten workflows written for people who are not analysts (each with a prompt you can paste into the sidebar), the limits Anthropic documents, and a checklist for letting Claude edit a workbook without breaking it. You will also see the add-in called Claude in Excel: Anthropic's old Claude in Excel help article now redirects to the Claude for Excel docs, so both names refer to the same add-in. Every product fact below links to Anthropic's or Microsoft's own pages, checked in October 2026.

What is Claude for Excel, and which plans include it?

Claude for Excel is an add-in from Anthropic that lets you chat with Claude about the open workbook and have it read and write cells, formulas, formatting, pivot tables, and charts. It is included on the Pro, Max, Team, and Enterprise plans but not on Free, and Anthropic made it generally available on May 7, 2026, together with its Word and PowerPoint add-ins, while the Outlook add-in joined in public beta.

According to Anthropic's Claude for Excel documentation, the add-in can:

• Answer questions about the workbook with cell-level citations you can click to jump to the referenced cell.
• Change an assumption, such as a discount rate or a growth rate, while keeping formula relationships intact, so the cells downstream recalculate correctly.
• Find the root cause of calculation errors such as #REF! and #DIV/0! and suggest a fix.
• Build a new model from a plain-English description or fill in an existing template, across multi-tab workbooks.
• Sort, filter, edit pivot tables, apply conditional formatting, and create data validation dropdowns.
• Pull in outside data through connectors (Anthropic names S&P Global, LSEG, and Daloopa) and apply the Skills you have turned on in Claude.

The cheapest plan that includes Claude for Excel is Pro, at $20 a month billed monthly or $17 a month billed annually ($200 up front), per Anthropic's pricing page. Max starts at $100 a month, and on Team a Standard seat costs $20 a month billed annually or $25 billed monthly. The same page's comparison table marks Claude for Microsoft 365 as not included on Free. Our Claude pricing guide compares every plan, and if you are choosing between the two individual tiers, read Claude Pro vs Max.

The add-in is included in those plans rather than sold separately, and Anthropic says your use of Claude for Excel is tied to your existing Claude account and subject to the same usage limits, so a long modeling session in Excel draws from the same allowance as your chats. Our guide to Claude usage limits explains how that allowance resets. The add-in also shares context with Anthropic's add-ins for PowerPoint, Word, and Outlook, which is what makes workflow 10 below possible.

How to install the Claude for Excel add-in

Install Claude for Excel from the Claude for Microsoft 365 listing on Microsoft AppSource: select Get it now, open Excel, activate the add-in, and sign in with your paid Claude account. Anthropic's announcement says one AppSource listing covers Excel, PowerPoint, and Word, so a single install gives you all three.

The version list, the activation menus, and the steps above all come from Anthropic's setup instructions. On a company laptop, an admin can deploy the add-in from the Microsoft 365 Admin Center under Settings > Integrated apps > Add-ins by searching for Claude for Microsoft 365, and Anthropic provides a manifest file for companies that block the Office Store. On Enterprise plans, the organization's model access settings also decide which Claude models appear in the sidebar. If you are rolling Claude out to a whole team, our Claude Team plan guide covers seats and admin controls.

If you installed the add-in months ago, you may have the older Excel-only listing, Claude by Anthropic for Excel. Moving to the combined listing is safe: Anthropic's data storage docs say every Claude for Microsoft 365 add-in shares one local store, and switching to a different store listing leaves your chat history intact.

The Instructions field in the add-in's Settings applies to every conversation in Excel and is kept separate from the Instructions you set in PowerPoint or Word, which makes it the right place for house rules. Paste this and change the formats to match yours:

House rules for every task in Excel:
- Put new work on a new tab. Never overwrite raw data unless I ask.
- Use live formulas, not pasted values, so every number can be traced.
- Prefer SUMIFS, COUNTIFS and AVERAGEIFS over array formulas, and
  direct cell references over OFFSET or INDIRECT.
- Currency: $#,##0. Percentages: one decimal place.
- Bold the header row of any table you create.
- When you finish, list every cell or range you changed.
- If a request is ambiguous (which column, which period, which tab),
  ask before you change anything.

Skip writing spreadsheet prompts from scratch

• 500+ copy-paste prompts & workflows
• 35 installable Cowork skills
• Role packs for 6 professions
• New prompts & skills every week, forever

See the Vault

The formula rule has a practical reason behind it. Anthropic's performance guide for the add-in recommends SUMIFS, COUNTIFS, and AVERAGEIFS because they calculate much faster than array formulas, and direct references instead of OFFSET and INDIRECT, which recalculate every time the workbook does. Lighter formulas mean shorter waits while Claude works.

10 Claude for Excel workflows for non-analysts

These ten Claude for Excel workflows cover the spreadsheet jobs that non-analysts actually get stuck on: making sense of an inherited workbook, fixing formulas, cleaning exports, summarizing, explaining variances, and building small models. Paste each prompt into the Claude sidebar with the workbook open, and replace the brackets with your own sheet names, columns, and numbers.

Most of the prompts ask Claude to show its plan before it edits anything. That habit catches a wrong guess about which column or period you meant before it touches your data, and it costs one extra message. The example prompts and capabilities quoted below come from Anthropic's Claude for Excel docs. If you want more finance and operations ideas once these are running, our list of Claude AI use cases by job function has twenty-five more, each with a concrete deliverable.

1. Get a guided tour of a workbook you inherited

Start read-only. Anthropic's docs suggest prompts like "Walk me through how the revenue number in cell C42 is calculated," and the answer comes back with citations you can click to jump to each cell. This prompt does the same for the whole file.

Give me a guided tour of this workbook. Don't change anything.
For each tab: what it is for, where the inputs are, where the
outputs are, and which other tabs feed into it.
Then list the 5 cells that drive the most important result, with
one plain-English sentence on what each one does.
Cite every cell you mention.

2. Explain a formula in plain English

When one cell looks wrong, or you just need to know what it does, ask for the formula broken into parts. The hardcoded-number check is the useful part: a typed-in 1.05 buried inside a formula will not change when you update the inputs, so the model quietly stops matching reality.

Explain the formula in [cell] for someone who is not an Excel person:
1. What it calculates, in one sentence
2. Each part of the formula, step by step, citing the cells it reads
3. Anything that could make it return the wrong number: hardcoded
   values, ranges that stop short, mixed units, wrong time period
Don't change anything.

3. Find and fix #REF!, #DIV/0!, and #N/A errors

Claude for Excel traces calculation errors to their root cause and suggests a fix; Anthropic's own example is "Find the source of the #REF! error in the summary tab." Ask for the full list first, so you approve the fixes instead of discovering them later.

Find every error value in this workbook (#REF!, #DIV/0!, #N/A,
#VALUE!). For each one, give me:
- the cell
- the root cause, not just the symptom
- the fix you propose
Show me the full list first and wait for my OK before you change
any cell. After I approve, fix them and list what you changed.

4. Clean a messy export

Exports from a CRM, a bank, or an ad platform arrive with stray spaces, mixed date formats, and duplicate rows. Keep the raw tab untouched and have Claude build a clean copy next to it, so you can always compare the two.

The [tab name] tab is a raw export from [CRM / bank / ad platform].
Leave it untouched. Create a new tab called Clean and on it:
- Trim extra spaces and fix capitalization in name columns
- Split [Full name] into First name and Last name
- Convert every date in [column] to YYYY-MM-DD
- Flag (don't delete) rows that look like duplicates, with a reason
- Add a filter to the header row
Then tell me how many rows you changed and what you could not clean.

Flagging duplicates instead of deleting them keeps the cleanup reversible. If you cannot install the add-in, the same prompt works on an uploaded file in a regular Claude chat, covered further down.

5. Summarize a table with a pivot table

Pivot tables are among the native Excel operations the add-in handles, along with sorting and filtering. Ask for the pivot and a short written read-out of it in the same request, so the summary and the numbers it describes sit side by side.

Using the data on [tab name], build a pivot table on a new tab that
shows [total revenue] by [region] and [month].
Sort regions from highest to lowest total.
Under the pivot, write 3 sentences on what stands out, citing cells.
Keep every number in the pivot itself, not typed into the sentences.

6. Write budget-vs-actual variance commentary

Month-end commentary is mostly arithmetic plus one sentence per line, which suits Claude well. The instruction to write "needs owner input" matters most: Claude can see that travel doubled, but not why, and a confident guess in a variance report is worse than a gap.

Compare Budget and Actual on [tab name] for [month].
1. Add a Variance ($) column and a Variance (%) column, as formulas
2. Highlight lines over budget by more than [10%] with conditional
   formatting
3. For the 5 largest variances, write one line of commentary each:
   what moved, by how much, and the likely driver based on the data.
   Where the data cannot explain it, write "needs owner input"
   instead of guessing.

7. Build a simple model from a description

Claude for Excel can generate a new model from a plain-English description or fill in an existing template; Anthropic's heavier example is building a three-statement model from a trial balance. The non-analyst version is a 12-month cash forecast with every input in one place.

Build a simple 12-month cash forecast.
Put the inputs on a new tab called Assumptions, one per row:
starting cash [$], monthly revenue [$], monthly growth [%],
fixed costs per month [$], variable costs [% of revenue].
On a Forecast tab, calculate monthly revenue, costs, net cash flow
and ending cash, and show the first month ending cash drops below
[$ threshold].
Every number on Forecast must be a formula that points back to
Assumptions. No hardcoded values.

Keeping every input on one Assumptions tab is what makes the next workflow safe to run.

8. Run what-if scenarios without breaking formulas

Claude updates input values while keeping formula relationships intact, so dependent cells recalculate; Anthropic's example is flexing a growth rate from 5% to 10% and showing the impact on terminal value. Asking for a before-and-after table turns that into something you can paste into an email.

Change [input] in [cell] from [5%] to [10%] and let everything that
depends on it update.
Then show me a before/after table for these outputs:
[ending cash in month 12], [lowest cash month], [total net cash flow].
When you're done, put the original value back unless I say to keep
the new one.

9. Turn a list into a tracker with dropdowns and alerts

Data validation dropdowns and conditional formatting are both on Anthropic's list of native operations, so a shared tracker takes one prompt instead of a tour through Excel's menus.

Turn the list on [tab name] into a tracker:
- Add a Status column with a dropdown: Not started, In progress,
  Blocked, Done
- Add an Owner column with a dropdown built from the names in [range]
- Put today's date in one cell at the top using TODAY()
- Highlight a row in red when its Due date is before that cell and
  Status is not Done
Tell me which cells hold the dropdown lists so I can edit them later.

The single TODAY() cell is deliberate. The add-in's performance guide recommends one TODAY cell that other cells refer to, rather than the same function repeated down every row.

10. Send the numbers to a Word memo or a PowerPoint slide

With the Word or PowerPoint add-in also installed and both files open, Claude can read from the workbook and write into the other file in the same conversation. Turn on "Let Claude work across files" in each add-in's Settings first; per Anthropic's cross-app guide, it is on by default on Pro and Max and off by default on Team and Enterprise.

Using the summary on [tab name], draft a one-page update in the open
Word document: 3 headline numbers, what changed since last month,
and the 2 risks to watch.
Then update the chart on slide [3] of the open PowerPoint deck with
the same figures.
Cite the cells you used for every number.

Claude can only work with files that are already open; the same guide says it cannot open, create, or switch files on its own. For the deck itself, our Claude for PowerPoint guide covers templates and slide edits, and the quarterly business review prompt in our Claude prompts for business collection turns the same numbers into a full QBR.

Want help running these on your own spreadsheets?

• 1,300+ non-technical professionals learning together
• Claude, Claude Cowork & Claude Code training
• The full 550+ prompt & skill Vault included with Premium
• A weekly live call to get unstuck

Join the Academy

Can Claude read xlsx files without the add-in?

Yes. On any Claude plan, including Free, you can upload an .xlsx or .csv file to a chat and Claude will read and analyze it. For .xlsx files, Anthropic requires Code execution and file creation to be switched on. According to Anthropic's file creation help page, the setting is on by default for Free, Pro, and Max under Settings > Capabilities, and on Team and Enterprise an Owner controls it in Organization settings > Capabilities.

The difference from the add-in is where the work lands. In chat, Claude works on your file in a private computing environment and hands back a new file: Anthropic says it produces an Excel file "with proper formulas, formatting, and even charts," which you can download or save straight to Google Drive. The add-in, by contrast, edits the workbook you have open, and Anthropic's product page says every edit is reviewable, with the changed cells highlighted in Excel.

A few limits apply to the chat route. Anthropic's list of supported uploads includes XLSX and CSV but not the older .xls format, so re-save old files as .xlsx first. The same page says Claude extracts only text from non-PDF uploads, so images embedded in a workbook will not come through. The file creation page lists a maximum of 30MB per file for uploads and downloads, while the upload page allows chat uploads of up to 500MB per file, so keep a spreadsheet under 30MB to be safe. The file creation page also notes that creating files uses more of your usage limit than a normal chat.

Anthropic also maintains built-in skills for Excel, Word, PowerPoint, and PDF files that Claude uses automatically when a task calls for them, on every plan. Our roundup of the best Claude skills explains what the xlsx skill adds. If your numbers are stuck in PDF reports instead, our Claude PDF skill guide has a prompt that pulls them into a spreadsheet-ready table. For a one-off file, this prompt gets you an analysis and a clean copy in one pass:

I've attached [file name].xlsx.
Before you answer anything:
1. List each sheet with its columns, row count, and date range.
2. Flag data problems: blanks, duplicates, mixed formats, outliers.
Then answer this: [your question].
Finally, give me a cleaned copy as a new .xlsx with a Changes tab
that lists every fix, and keep all calculations as live formulas.

What about Google Sheets?

Google Sheets has two official routes: an add-on that works inside the sheet, and connectors that work from a Claude chat. The add-on is Claude for Google Workspace, in public beta since October 6, 2026, which puts a similar sidebar into Docs, Sheets, and Slides on paid plans. In Sheets it can write formulas, build pivot tables and native Sheets charts, and add new tabs. Per Anthropic's setup guide, it is available on Pro, Max, Team, and Enterprise; you install it from the Google Workspace Marketplace and open it under Extensions > Claude > Open Claude. Its beta limits are worth knowing: it runs in Chrome, Edge, and Safari but not Firefox, the sidebar has to stay open while Claude works, and a single operation can run for up to six minutes before Google stops it.

The connector route starts with the Google Drive connector, which lets Claude read Google Sheets, as well as Excel files stored in Drive, inside a normal chat. When you add a Google Sheet to a private project, Claude receives it as CSV with every tab included, and Google caps those exports at about 10MB. The Drive connector works on the Free plan too: Anthropic says its Google Workspace connectors, Drive included, are available for all users, and connectors are included on the Free plan. To have Claude change a Google Sheet from the chat instead of only reading it, turn on the Google Docs, Sheets, and Slides connectors, also in beta since October 6, 2026: they create and edit Google files from the chat and, on supported setups, open them in a pane beside the conversation.

Claude for Excel limits and a safe-edit checklist

Claude for Excel does not support macros, VBA operations, or Excel data tables, and Anthropic does not recommend it for final client deliverables without human review, for audit-critical calculations without verification, or for highly sensitive or regulated data without proper controls. Treat it as a fast first pass and check the numbers that matter yourself.

Workbook size is the other practical limit. Per Anthropic's performance and limits page, a single read returns at most 2,000 cells with data, so Claude works through a big sheet in several steps. Claude also waits a fixed time for each step: 90 seconds when it runs code, and 5 minutes for other steps such as writing cells on the desktop, or 2 minutes on the web. After that it reports a timeout, even though Office may still be working. The same page says workbooks under 1 million used cells work well, 1 to 5 million is higher risk, and anything over 5 million is at your own risk.

To see where your file sits, use the method from Anthropic's performance page: press Ctrl+End on each sheet to jump to its last cell, multiply the last row number by the last column number, and add the sheets together. A last cell of Z100000 means 26 columns by 100,000 rows, about 2.6 million cells, which already puts the workbook in the higher-risk band. Formatting on empty cells pushes the last cell further out, so a sheet can count as bigger than its data. In Excel for Microsoft 365, Review > Check Performance finds and cleans up those empty-but-formatted cells; Anthropic's page says to save a copy before you run it. When a file lands in the higher band anyway, name the sheet and range in every prompt, or copy the tabs you need into a new workbook first.

The security limit is prompt injection. Anthropic warns that files from outside sources, such as downloaded templates, vendor files, and data imports, can contain hidden instructions that try to trick the add-in into extracting data, modifying records, or performing destructive actions. Use it on spreadsheets you trust, and read the confirmation Claude shows before it runs a risky operation instead of clicking through it. The same page says your Excel chat history is stored in browser storage on your own computer rather than on Anthropic's servers, and that inputs and outputs are deleted from Anthropic's backend within 30 days, with the exceptions listed in its retention policy.

Anthropic's own best-practice list makes the same core points: start from a trusted copy of the workbook, be specific about what you want changed, and review changes before you finalize your work. If you are new to the add-in, begin with workflow 1 on a workbook you inherited and workflow 3 on whatever is throwing errors. Both start read-only, so you learn how Claude cites cells before you let it change any. For how other teams fold this into wider Claude use, see our guide to Claude for business.

Frequently Asked Questions

Is Claude for Excel the same as Copilot in Excel?

No. Claude for Excel is Anthropic's add-in, signed in with your Claude account and counted against your Claude plan's usage limits. Copilot in Excel is Microsoft's assistant, and Microsoft says it supports the latest Anthropic and OpenAI models through a model picker in the Copilot pane; on a commercial Copilot subscription, an admin has to allow Anthropic models first.

Why can't I see my Excel chat on my other computer?

Because Claude for Excel keeps chat history in browser storage on the device you used, and Anthropic does not back it up or sync it between devices. Reinstalling the add-in or switching store listings keeps the history, but rebuilding or wiping the computer deletes it unless it is exported first. The add-in also keeps only your 50 most recent conversations per Office app, and in Excel on the web Anthropic says to treat chat history as temporary, because browsers can clear add-in storage on their own schedule.

Can I talk to Claude in Excel instead of typing?

Yes, in the desktop version of Excel. Click the microphone icon in the chat box and speak; your words appear as you talk, and pressing Enter stops and sends. Per Anthropic's dictation guide, it is not available in Excel on the web, because add-ins running in a browser cannot reach the microphone.

Which Claude model does the Excel add-in use?

Claude for Excel offers a curated subset of Claude models, the ones that work best for Office tasks, so the list in the add-in can be shorter than the one on claude.ai. On Enterprise plans, your organization's model access settings also decide which models you see.

Can Claude for Excel pull data from my other tools?

Yes, through connectors. In the sidebar, click the + button below the chat box and choose Connectors; Anthropic lists S&P Global, LSEG, and Daloopa for financial data, plus any custom connectors your organization has turned on. Skills you have enabled in Claude work in the sidebar too, and typing / shows the ones available in Excel, according to Anthropic's connectors and skills page.