Since May 2026, Claude has been available as an official add-in for Microsoft Excel — installed directly from the Microsoft Marketplace, working inside your spreadsheet as a sidebar, without needing to copy and paste data into a separate chat window. Here's what you need to know to get it running and use it well.
What you need
- A paid Claude plan — Pro ($20/month), Max, Team, or Enterprise. The free Claude tier doesn't include the Office add-ins.
- Microsoft 365 with Excel on Windows, Mac, or the web. The add-in works across all three platforms.
- A reasonably recent build of Office — if you're on Microsoft 365 and keep it updated, you're fine.
There is no additional charge beyond your Claude subscription. You don't need a separate Microsoft 365 Copilot licence to use Claude in Excel.
How to install it
- Open Excel (desktop or web)
- Go to Insert > Add-ins (desktop) or the Add-ins icon in the toolbar (web)
- Search for "Claude by Anthropic" in the Office Add-ins marketplace
- Click Add
- Once installed, find Claude in your Home tab or Add-ins panel and sign in with your Claude account
The process takes about five minutes. On Mac: same steps — Insert > Get Add-ins, search "Claude by Anthropic." On web: use the Add-ins icon in the toolbar. Once installed, Claude appears as a sidebar panel that stays open while you work in the sheet. Open it with Ctrl+Alt+C on Windows or Ctrl+Option+C on Mac.
Enterprise/work accounts: if your organization manages Microsoft 365 centrally, your IT admin may need to approve and deploy the add-in via the Microsoft 365 Admin Center before it's available to you. If you search and don't see it, check with IT first.
What Claude can do in Excel
Read and analyze your spreadsheet
Unlike using Claude in a browser tab where you'd have to paste data in, the add-in can see your open workbook directly — including multiple tabs. This is a meaningful difference from Copilot in Excel, which can't navigate across sheets. Claude can read data from other tabs and reference them in its responses, with clickable citations that take you directly to the referenced cells.
Generate and explain formulas
Describe what you want a formula to do in plain English, and Claude writes it. Paste in a formula you don't understand, and Claude explains each component. For complex nested formulas — XLOOKUP inside IF inside IFERROR — this is genuinely faster than trying to decode it yourself or searching documentation.
Identify and fix errors
Paste a formula throwing #REF!, #VALUE!, or a circular reference error and ask Claude what's wrong. It identifies the source and suggests a fix that maintains your spreadsheet's existing structure and dependencies — it doesn't just suggest rewriting the formula from scratch.
Data analysis and summaries
Ask questions about your data in plain English — "which region had the highest revenue in Q2?", "summarize the trend in this column" — and Claude responds without you needing to build a PivotTable first. Useful for quick reads before deciding whether deeper analysis is worth the effort.
Data cleaning
Ask Claude to find inconsistencies, flag missing values, or standardize formats across a range. It highlights what it finds and explains what it changed before applying anything.
What makes it different from Copilot
The two most meaningful differences in practice:
- Cross-tab awareness: Claude can read data from other sheets in your workbook and reference them in formulas and analysis. Copilot's native Excel features are largely limited to the active sheet.
- No separate Microsoft 365 Copilot licence needed: Claude runs on your Claude subscription. If your company hasn't paid for Microsoft 365 Copilot (~$30/user/month) but you have a personal Claude Pro plan, you can use Claude in Excel independently.
Copilot has its own advantages — deeper integration with the rest of Microsoft 365 (Teams, Outlook, SharePoint) and no additional subscription if your company already pays for it. See our Copilot vs ChatGPT comparison for more on choosing between them.
Cross-app workflows (Excel + Word + PowerPoint + Outlook)
One of Claude's more distinctive features since May 2026: the add-in carries context across Microsoft 365 apps within the same session. If you've been analyzing a financial model in Excel and switch to PowerPoint, Claude already knows what the model contains — you don't have to re-explain it. You can ask it to build a presentation from the Excel analysis, or draft a Word summary memo, without copying and pasting data between apps. Requires the Claude add-in installed in each app you want to use it in.
Practical prompts to start with
Summarize what this workbook is trackingWrite a formula that calculates profit margin using the Revenue and Cost columnsExplain what this formula is doing: [paste formula]Find any rows where the value in column D is missing or zeroWhat are the top 5 products by total revenue in this dataset?This formula is returning #VALUE! — what's wrong? [paste formula]
The bottom line
If you already pay for a Claude Pro plan, installing the Excel add-in is worth the five minutes — it removes the copy-paste friction of using Claude in a browser tab and adds cross-tab awareness that Copilot doesn't currently match. If you don't have Claude Pro and your company pays for Microsoft 365 Copilot, stick with what you have. If you're choosing between them from scratch, the Claude add-in is the stronger tool specifically for spreadsheet work; Copilot wins on broader Microsoft 365 ecosystem integration.