How to Set Up Claude in Excel (2026 Guide)

What Claude for Excel Does

Claude for Excel is an Anthropic-published add-in that opens a persistent sidebar inside Microsoft Excel on Windows, macOS, and Excel for the Web. You type instructions in plain English and Claude responds directly in the sidebar, referencing the cells and ranges in your active workbook.

The add-in does not send your spreadsheet to a third-party scraping service. It reads only the data you reference in your prompt, and all processing runs through Anthropic's API. The model is aware of your workbook structure: it can navigate multi-tab files, identify named ranges, and apply formula changes while preserving existing formula dependencies.

As of January 24, 2026, the add-in is available on all Claude Pro plans ($20 per month). It was initially released in beta in October 2025 for Max and Enterprise subscribers only.

Requirements Before You Start

You need a Claude account on a Pro, Max, Team, or Enterprise plan. A free Claude account does not include add-in access. You also need Microsoft Excel — either the desktop application (Microsoft 365 subscription or Excel 2019 and later) or Excel for the Web at office.com. Excel for iPad and mobile are not currently supported.

If you are on a corporate IT-managed machine, your Microsoft 365 administrator may need to allowlist the Claude add-in before the install steps below will work. This is done in the Microsoft 365 admin center under Settings, then Integrated Apps.

How to Install Claude for Excel

Open any Excel workbook and click the Insert tab in the ribbon. In the Add-ins button group, click "Get Add-ins" on Windows or "Add-ins" on Mac and Excel for the Web.

In the Office Add-ins dialog, type "Claude" in the search bar. The result "Claude by Anthropic" will appear with Anthropic's logo. Click "Add." Installation takes roughly 30 seconds.

After installation, a Claude icon appears in the Excel ribbon under the Home or Add-ins tab. Click it to open the sidebar panel on the right side of your spreadsheet. The sidebar will prompt you to sign in with the same email and password you use at claude.ai. Once authenticated, the sidebar is active and ready to use.

The entire process takes under two minutes on a standard Microsoft 365 subscription.

What You Can Do with Claude in Excel

Formula help. Type "write a formula that counts unique values in column B" or "explain what this XLOOKUP is doing" and Claude returns a plain-English explanation or a ready-to-paste formula. For debugging, paste the formula into the chat and describe the error — Claude identifies the issue and suggests a fix.

Data cleaning. Describe a cleaning task directly: "these dates are in mixed formats, write a helper column formula to normalize them to YYYY-MM-DD." Claude handles common dirty-data problems including duplicate rows, inconsistent capitalization, phone number formats, and leading or trailing whitespace.

Analysis from natural language. Highlight a table and ask "what is driving the drop in Q3 revenue?" Claude reads the visible data, identifies likely contributing factors based on the values, and explains its reasoning in plain English. This is an interpretive starting point — not a calculated answer — so treat it as a prompt for further investigation rather than a final result.

Report drafts. "Write a three-paragraph summary of this spreadsheet for an executive." Claude reads the ranges you reference in your prompt and returns a structured summary suitable for a meeting note or email. Teams using financial models and KPI trackers report saving 15 to 30 minutes per reporting cycle with this feature, since the output is ready to paste without additional formatting.

Skills. The March 2026 update introduced Skills: saved prompts you can run with a single click. You save "find all rows where status is Overdue and summarize the count by owner" as a skill, then re-run it on any file in one click from the sidebar panel. Teams use Skills to standardize recurring tasks that previously required sharing a prompt document and manually pasting the same instructions each week.

How Claude Reads Your Workbook

Claude for Excel does not scan your entire workbook automatically. It reads data that is either currently visible in your active sheet or that you explicitly reference in your prompt. If your data lives on a tab called "Raw Data," mentioning that tab name in your prompt ("on the sheet called Raw Data, find the top five customers") tells Claude where to look.

For large workbooks with multiple tabs and named ranges, the add-in handles them natively. You do not need to export data or copy-paste into the chat. The model is informed of the workbook's structure when the sidebar is open, including sheet names and defined named ranges, so you can refer to them by name in your instructions.

Shared Context with PowerPoint

The March 2026 update also introduced Shared Context across Claude's Excel and PowerPoint add-ins. If you analyze a revenue table in Excel and then open Claude in PowerPoint, the previous analysis is already in context. You can type "turn the Excel summary into three slides" and Claude will reference the data without you pasting anything.

This matters for reporting workflows where the same source data feeds both a financial model and an executive deck. Before this update, users needed to manually copy analysis text from the Excel sidebar into the PowerPoint sidebar. With Shared Context, the handoff is automatic within the same Claude session.

What Claude for Excel Does Not Do

Claude for Excel does not write and auto-execute VBA macros. It can generate macro code on request, but you paste and run it yourself. Auto-executing code in a workbook is a security risk, and the add-in is designed to keep the user in control of what runs.

It does not connect to external data sources. You cannot point it at a database URL, a live API, or a cloud storage bucket and have it pull data. The add-in works only with data already present in your open workbook.

It also does not run Python or R computations. The analysis Claude provides is text-based interpretation of your data, not a statistical computation engine. For teams that need live database connections, automated data refresh, and built-in statistical analysis from a file upload without setup, a purpose-built analytics platform handles that layer end to end. If you want to upload a CSV and get analysis plus charts from a single prompt without any installation, VSLZ handles that workflow directly.

Pricing

Claude for Excel is included in the Claude plan subscription — there is no additional charge for the add-in itself.

As of April 2026, Claude plans are priced as follows: Claude Pro at $20 per month for individuals, Claude Max at $100 per month with higher usage limits, Claude Team at $25 per user per month, and Claude Enterprise at custom pricing for large organizations.

Usage within the add-in counts against your standard Claude message limits, the same pool shared with claude.ai and other Claude surfaces.

Troubleshooting Common Issues

Add-in does not appear after installation. Close Excel completely and reopen it. On Excel for the Web, try a hard refresh with Ctrl+Shift+R on Windows or Command+Shift+R on Mac.

Sign-in fails. Confirm your Claude plan is active by logging in at claude.ai. If the plan is active, sign out of the add-in sidebar and re-authenticate.

Admin has blocked add-ins. You will see an error message during install. Contact your Microsoft 365 administrator and ask them to enable third-party add-ins via the Microsoft 365 admin center under Settings, then Integrated Apps.

Data is not read correctly. Claude reads from your active sheet and any explicitly referenced ranges. If your data is on a different tab, mention the tab name directly in your prompt — for example, "on the sheet called Q1 Sales, find the top five customers by revenue."

Sidebar closes unexpectedly. This typically happens when Excel is running in a low-memory state. Close other large workbooks and reopen the Claude sidebar from the ribbon.

Summary

Claude for Excel is a practical add-in for analysts and ops managers who spend significant time in spreadsheets. Setup takes under two minutes through the standard Office Add-ins store. The core capabilities — formula help, data cleaning, analysis summaries, and report drafts — address the tasks that consume the most time in a typical Excel workflow. The March 2026 Skills and Shared Context updates make it more useful for teams running recurring reports or combining Excel analysis with PowerPoint output.

For any user on an active Claude Pro plan, the setup friction is low enough to complete in a single working session.