Claude for Excel: Install the Add-in and Meet Your Sidebar Analyst
After this, you'll be able to install the Claude for Excel add-in from Microsoft Marketplace, open a workbook, and have Claude explain a formula and suggest an improvement, all without leaving Excel.
Before you start
Before diving in, complete Claude.ai Web App: AI Spreadsheet Help With Zero Setup so you're familiar with how Claude reasons about spreadsheet data. The add-in builds on that foundation.
The idea
The Claude for Excel add-in reads your open workbook from the sidebar, cites cells, highlights changes, and leaves review with you before saving. Claude for Excel is a native add-in that lives inside the Excel sidebar. You type a question, Claude reads your open workbook, highlights referenced cells, and responds in plain English. The core workflow is ask, review the highlighted changes, then verify the workbook before you save or share it.
Here is the before and after: Without the add-in, you inherit a workbook with a formula like =IF(AND(D12>0,C12<>""),SUMPRODUCT((B2:B100=B12)(C2:C100=C12)D2:D100)/SUMIF(C2:C100,C12,D2:D100),"") and spend 20 minutes reverse-engineering it. With the add-in, you click cell E12 and type "explain this formula." Claude responds: "This calculates each product's percentage of category sales. The outer IF prevents errors when quantity or category is blank, but if column C ever has a blank in the denominator, you'll get a division error. Here's an IFERROR fix." Copilot might auto-fix faster; Claude tells you what was wrong so you don't repeat it.
Now try it: install the Claude for Excel add-in from Microsoft Marketplace (requires Pro, Max, Team, or Enterprise plan), open any workbook with a formula you don't fully understand, click that cell, and type "explain this formula in plain English and tell me if anything could break." Review the highlighted cells and verify the workbook before saving.
Try it (20 min)
Watch out for
- Installing the add-in but not seeing it in the ribbon. Check Add-ins > My Add-ins in the Insert tab; it may need to be pinned to the ribbon
- Trying to use Claude to read or modify a VBA macro. The add-in will tell you this is unsupported; use the web app for VBA tasks
- Treating local add-in history as permanent project memory. Current Excel add-in history is local to the add-in surface, user, and organization, so record final assumptions in the workbook or handoff notes
- Accepting a batch of proposed changes without reviewing them. Claude highlights changes for a reason; review especially when it's modifying formulas you didn't ask it to touch
- Assuming free-tier access works. Claude for Excel requires a paid plan (Pro, Max, Team, or Enterprise); confirm your subscription before spending time troubleshooting
Paste this into Claude
Install the Claude for Excel add-in from Microsoft Marketplace (search "Claude by Anthropic for Excel"). Sign in with your Claude account. Create a new Excel workbook with this data starting in A1: | SKU | Product Name | Units on Hand | Reorder Point | Supplier | |-----|-------------|---------------|---------------|----------| | SKU-001 | Stainless Travel Mug | 145 | 50 | Pacific Goods | | SKU-002 | Laptop Stand Adj | 12 | 30 | ErgoDesk Inc | | SKU-003 | USB-C Hub 7-Port | 8 | 25 | TechLink | | SKU-004 | Bamboo Cutting Board | 67 | 20 | Green Kitchen | | SKU-005 | LED Desk Lamp | 3 | 15 | BrightWork | Open the Claude sidebar (Add-ins > Claude for Excel). Then ask it each of these in sequence: 1. "Describe what this spreadsheet contains and what the columns mean." 2. "Which products need to be reordered? List them by name." 3. "Add a column called Reorder Status with the value ORDER NOW for items below their reorder point, and OK for items that are fine."
What good looks like
- The add-in sidebar is open and you are signed in (you can see the Claude chat interface inside Excel)
- Claude correctly identified all column names and described the spreadsheet's purpose
- Claude identified SKU-002, SKU-003, and SKU-005 as below their reorder points
- The Reorder Status column was added with Claude highlighting which cells it changed
- You reviewed the highlighted changes and verified the workbook before saving
When this breaks
- Breaks on any workbook that depends on VBA macros, because the add-in is architecturally unable to read, write, or trigger macros. For macro-heavy automation, the wrong-modality choice is the failure, not Claude itself.
- Degrades when local add-in history is treated as the record of truth, because history is scoped to the add-in surface, user, and organization. Record final assumptions in the workbook or handoff notes.
- Degrades when proposed changes are applied in bulk without review, because highlighted changes are the safety mechanism. Skipping review converts a careful sidebar analyst into something closer to a black-box auto-editor.
AI can help with this
Use the native Excel AI surface your organization supports: Copilot in Excel, Claude for Excel if installed, or another approved add-in. Ask the assistant to explain the active formula, then verify one cell by hand.
You can now
You can complete the lesson outcome on a real or realistic spreadsheet sample.
- You can verify that the add-in sidebar is open and you are signed in (you can see the the spreadsheet assistant chat interface inside Excel).
- You can verify that the spreadsheet assistant correctly identified all column names and described the spreadsheet's purpose.
- You can verify that the spreadsheet assistant identified SKU-002, SKU-003, and SKU-005 as below their reorder points.
- You can verify that the Reorder Status column was added with the spreadsheet assistant highlighting which cells it changed.
Key takeaways
The Claude for Excel add-in puts an AI analyst in your sidebar. It reads your open workbook, explains formulas in plain English, and highlights changes you verify before saving.
- The add-in puts Claude in the Excel sidebar, reading your live workbook with no copy-paste required.
- Every change needs review. Claude highlights workbook changes, and you verify them before saving.
- The add-in cannot touch VBA. For macros, the web app is still the right modality. Choose by capability, not by convenience.
- History is local to the add-in surface, user, and organization. Record final assumptions in the workbook.
- Available on Pro, Max, Team, and Enterprise plans only. Verify your subscription before troubleshooting install issues.