Claude runs inside Excel now — natively, as a free Microsoft Marketplace add-in. You highlight a data range, ask it to "build a 3-year P&L with these assumptions," and it writes the formulas and wires up the structure without you touching the formula bar. The add-in is free to install; you need a Claude Pro plan ($20/mo) or higher to use it.
The 2026 shift for operators: formula-building, data-scrubbing, and error-hunting are now Claude's job. Your value is auditing the logic, packaging the output, and teaching clients to prompt it correctly.
What Claude actually does inside Excel
Claude for Excel runs in a sidebar panel inside the Excel desktop app (Windows build 16.0.13127.20296+ or Mac version 16.46+; also works on Excel for web and iPad). It reads your entire workbook as a connected system — not just the selected cell — and can reason across sheets, named ranges, and formulas.
Verified capabilities as of 2026:
Formula generation. Describe what you need in plain English. Claude writes the formula — nested IFs, XLOOKUP, INDEX-MATCH, SUMIFS with multiple criteria. It explains each component before applying it. You don't need to know the syntax.
Error diagnosis. Paste a cell reference throwing #REF!, #VALUE!, or a circular reference. Claude identifies the exact source — not "check your ranges" but the specific cell and why — and gives the fix with an explanation of what changed.
Data cleaning. Feed Claude a raw export: client list, invoice log, CRM dump. Tell it what you need: remove duplicates, standardize city names, split "First Last" into two columns, flag rows with blanks in required fields. Claude applies operations directly in the workbook.
Dashboard building. Describe the dashboard in plain language ("monthly revenue by region, bar chart, slicer for product line"). Claude builds the pivot table, applies the chart, and adds conditional formatting. You specify the output; Claude handles the mechanics.
VBA macros. Describe the automation ("save this sheet as a PDF to the Desktop folder, name it with today's date"). Claude writes the VBA code, drops it in a module, and explains how to trigger it. No VBA knowledge required.
Financial modeling. Give Claude assumptions — revenue growth rate, COGS %, headcount ramp — and tell it to build a 3-year P&L. It creates the row structure, wires up the formulas, and can run scenarios against a table of input variables.
How to prompt it so the output is usable on the first try
The operators getting consistent results are prompting Claude like a skilled analyst briefing, not a search query. Three patterns that work:
Specificity over brevity. "Build a COGS model" returns something generic. "Build a COGS model for a 3-person agency billing clients hourly — inputs: hourly rate, hours per week per person, utilization rate — output: gross margin at three utilization scenarios (60%, 75%, 90%)" returns something you can hand to a client.
Show it the column structure first. Before asking for formulas: "Column A is date (MM/DD/YYYY), B is client name, C is invoice amount. Flag any invoice over $5,000 in column D as 'High,' everything else as 'Standard.'" Claude builds the right formula the first time. Without this context, it guesses at your schema.
Ask it to explain before applying. "Explain what this formula does before you change anything." This matters when you inherit a client's spreadsheet — you need to understand the existing logic before Claude rewrites it. It also catches cases where Claude misunderstood the ask.
The service you sell
Most clients are already running Microsoft 365 Business Standard or Premium. The add-in is free. The setup service charges for expertise, not a tool subscription.
The offer: Claude for Excel onboarding — enable the add-in across the team's Microsoft 365 accounts, build 3–5 workbook templates with prompt libraries pre-loaded in a hidden Notes sheet (each row is a task the team will need, written as a ready-to-use Claude prompt), and run a 2-hour live training session plus a recorded Loom walkthrough.
What to charge: $1,500–$2,500 for setup and templates. $300–$500/mo to maintain the templates as the client's workflows change — every new hire or new service line typically needs a template update.
Who needs it most: accounting firms, financial advisors, operations consultants, and any service firm where the team spends more than 5 hours a week in spreadsheets. They're paying for Microsoft 365. They're not using Claude. That gap is billable.
The upsell: the Excel onboarding is the foot in the door for a full Claude platform install — Projects organized per client, a Skills library that encodes their SOPs, and Cowork for larger deliverables. Clients who see Claude work in a tool they already use every day are easy converts. Price the install at $2,500–$5,000; see how to become an AI consultant for the retainer model that follows.
Claude vs. Microsoft Copilot in Excel
Microsoft Copilot uses OpenAI under the hood and runs in the same Excel sidebar. The practical difference in 2026:
| | Claude for Excel | Microsoft Copilot | |---|---|---| | Add-in cost | Free (Microsoft Marketplace) | Requires Microsoft 365 Copilot add-on | | AI subscription required | Claude Pro ($20/mo) or higher | Microsoft 365 Copilot (~$30/user/mo on top of M365 plan) | | Formula explanation quality | Step-by-step logic breakdown | More terse | | VBA generation | Yes | Yes | | Best for | Operators already using Claude as their AI platform | Organizations deep in Microsoft's AI stack |
For a 5-person client team, Copilot adds $150/mo to their Microsoft 365 bill. Claude for Excel costs whatever Claude plan they're on — if they're already on Claude Pro or Team, the add-in is free to enable. That math makes Claude easy to justify.
How to install Claude for Excel
- Open Excel and go to Insert → Add-ins → Get Add-ins
- Search "Claude" in the Microsoft Marketplace
- Click Add — no additional cost at this step
- Sign in with your Claude account (Pro, Max, or Team required)
- The Claude sidebar appears in the right panel — highlight a range and start prompting
Works on: Excel for Windows (Microsoft 365, build 16.0.13127.20296+), Excel for Mac (version 16.46+), Excel on the web, and iPad.
FAQ
Is Claude for Excel free?
The add-in itself is free to install from the Microsoft Marketplace. Using it requires an active Claude subscription — Pro ($20/mo), Max ($100/mo), Team, or Enterprise. If you're already on Claude Pro, enabling the Excel add-in costs nothing extra.
Can Claude write VBA macros in Excel?
Yes. Describe the task in plain English and Claude writes the VBA code with setup instructions. It explains what each section does so you can modify it. Useful for report formatting, bulk exports, date-based triggers, and anything repetitive your clients do manually.
Does Claude for Excel work with Google Sheets?
Not natively. The Microsoft add-in is Excel-specific. For Google Sheets, the fastest workflow is uploading the sheet as a file to the Claude web app or using Claude Desktop with a Google Drive connection, then pasting outputs back. A dedicated Claude for Sheets integration doesn't exist as of mid-2026.
What's the difference between Claude for Excel and Microsoft Copilot?
Both run in the Excel sidebar and can write formulas, analyze data, and build charts. Copilot uses OpenAI's models and requires the Microsoft 365 Copilot add-on (~$30/user/mo extra). Claude for Excel uses Anthropic's Claude and requires a Claude Pro subscription ($20/mo) — the add-in itself is free. For clients already using Claude, enabling it in Excel costs nothing additional.
What Excel plan do I need?
Claude for Excel works with Microsoft 365 consumer and business plans on Windows (build 16.0.13127.20296+), Mac (version 16.46+), Excel on the web, and iPad. It does not work with standalone Excel 2019/2021 licenses (non-subscription). Most business clients on Microsoft 365 Business Standard or Premium qualify.