Claude + Excel: What the Integration Can (and Can't) Do in 2026
Claude can read an Excel workbook through this connector — and, if an admin enables write tools, create or update the file, though not clearly edit individual cells. The way Claude reaches a spreadsheet stored in OneDrive or SharePoint is through Claude’s Microsoft 365 connector, which shipped read-only but gained write tools on July 7, 2026. By default Claude can search and read the values in a workbook as context; with write tools enabled it can create and update files — but Anthropic describes write tools at the file level, so editing individual cells or adding formulas through the connector isn’t documented. Write tools are also off by default and admin-gated, and — like every Claude connector — it has no event triggers: nothing happens because a row landed or a number crossed a threshold.
Here’s exactly how the connection works, how to turn it on, where the limits bite, and what to use if you want Excel work that runs on its own.
How Claude connects to Excel
There’s no standalone Excel app in Anthropic’s Connectors Directory. An Excel workbook is reached through the Microsoft 365 connector — Anthropic’s single bridge across the Microsoft 365 suite, built on the Model Context Protocol (MCP) like the rest of the 400+ directory connectors.
By default the connector is read-only. Through it, Claude can:
- Read an Excel workbook stored in OneDrive or SharePoint — pull its values into the conversation as context.
- Search Outlook, SharePoint, OneDrive, and Teams — bring email, files, and discussions in as context too.
Out of the box, what it cannot do is just as important: no editing cells or values, no adding formulas/rows/tabs, no writing back or uploading.
That eased slightly on July 7, 2026, when Anthropic added write tools that let Claude create and update files in OneDrive and SharePoint. But those are described at the file level — creating or replacing a workbook — not fine-grained cell or formula editing, and they’re off by default behind a Microsoft Entra admin’s consent plus org enablement. So for writing an answer back into a specific cell, the connector still isn’t the tool. (For the broader picture of this connector, see Claude for Microsoft 365.)
A note to avoid confusion: Anthropic also ships a separate “Claude for Excel” Office add-in that works inside the Excel app itself — that’s a different thing from the Microsoft 365 connector described here. The add-in does real in-cell work, but only inside the Excel app you’re driving; the connector path is read-only by default and, at most, file-level with write tools.
How to set it up
Setup lives in Claude’s connector settings:
- Open Settings → Connectors in the Claude app or on claude.ai.
- Find the Microsoft 365 connector and click Connect.
- Sign in with your Microsoft account and approve the requested permissions (your tenant admin may need to allow it).
- Back in a chat, point Claude at a workbook in your OneDrive or SharePoint — it’ll read it through the connector.
The first-party directory connectors are available broadly; custom connectors (your own MCP server) require a paid plan. Read access comes by default; write tools (create/update files) require a separate admin opt-in — a Microsoft Entra admin’s consent plus org enablement — and even then don’t clearly cover cell-level editing.
The limits that actually matter
Even with write tools, the connector is a reader of your workbooks, not an agent that maintains them. Three limits define it:
- Read by default; writes are file-level. Out of the box the connector can only read. Admin-enabled write tools can create or update the file, but editing specific cells, adding formulas, and inserting rows through the connector aren’t documented.
- No triggers, no automation. Even with write tools on, the connector has no event triggers. There’s no “when a number changes, recalculate and notify” or “when a new figure lands, update the model.” Nothing fires on a spreadsheet event — the trigger is always you or a clock.
- Nothing keeps it current. Claude helps in the moment; it doesn’t sit on your workbook maintaining it. The closest thing to “running on its own” is Claude Cowork’s scheduled tasks, which fire on a fixed clock, not on inbox events.
So Claude is great for “read this workbook and tell me what it means right now” and not built for “keep this spreadsheet updated as data comes in.”
If you want Excel work that runs on its own: Carly
The moment you want a workbook kept current the instant the data moves — values updated the instant data arrives, a summary emailed on schedule — you’ve crossed past what Claude’s read-only connector is for.
That’s where Carly fits. Carly is an AI executive assistant built to act on triggers, not just read in a chat:
- Fires on the event itself, not on a clock — when new data arrives, Carly acts; nothing waits for the next scheduled run.
- Writes to your spreadsheet as part of a workflow — and ties it to email, calendar, CRM, and tasks.
- Actually sends and updates — drafts and sends email (Gmail and Outlook) with attachments, files and labels, manages tasks, updates your CRM, and records meetings — the actions a read-only connector can’t touch.
- Builds the workflow for you — tell it “I’d like to set up a system that logs every new figure into a workbook and emails me a weekly summary” in plain English; it interviews you, then builds it with you. No prompt engineering, no MCP server to host.
AI agents start at $35/month, and steps in a workflow that don’t use AI run free. Carly connects to 200+ tools across 40+ categories — see integrations and the Excel integration page. By the way, Carly also integrates with Excel.
Claude’s Excel integration vs Carly
| Claude (Microsoft 365 connector) | Carly | |
|---|---|---|
| Read a workbook | Yes | Yes |
| Create / update the workbook file | Only with admin-enabled write tools* | Yes (automatically) |
| Edit specific cells / add formulas | No (not documented via connector) | Yes (automatically) |
| Reads files / content | Yes | Yes |
| Acts on triggers / events | No | Yes |
| Runs unattended on a schedule | Yes (Cowork tasks) | Yes |
| Sends email as part of the flow | No (chat-only, admin-gated) | Yes (Gmail + Outlook) |
| Pricing | Pro $20 / Max $100–$200 | AI agents from $35/mo |
*The connector’s write tools shipped July 7, 2026 and are off by default: a Microsoft Entra admin must consent and your Claude organization must enable them. Anthropic describes them at the file level (create/update), not cell-level editing, and they add no triggers.
Claude’s connector is a strong workbook reader inside a chat (and, with write tools, can create or update the file — though not edit cells). Carly is a teammate that keeps your spreadsheets running — automatically.
Frequently Asked Questions
Does Claude integrate with Excel?
Through the Microsoft 365 connector. It’s read-only by default — Claude reads an Excel workbook stored in OneDrive or SharePoint as context inside a chat (along with Outlook, SharePoint, OneDrive, and Teams) — and if an admin enables write tools (added July 2026) it can also create and update the file. But those write tools are file-level: editing individual cells or adding formulas through the connector isn’t documented.
Can Claude edit or update an Excel spreadsheet?
Through the connector, only at the file level, and only if an admin enabled write tools (added July 7, 2026, off by default) — it can create or replace the workbook file, but cell-level editing and formulas through the connector aren’t documented. The separate “Claude for Excel” Office add-in does in-cell work, but only inside the app you’re driving. For automatic, write-capable spreadsheet work, you need an agent platform like Carly.
How do I connect Claude to Excel?
Go to Settings → Connectors in the Claude app or on claude.ai, connect the Microsoft 365 connector, sign in with your Microsoft account, and approve permissions (your admin may need to allow it). Then point Claude at a workbook in OneDrive or SharePoint in a chat.
Isn’t there a “Claude for Excel” add-in?
That’s a separate Office add-in that works inside the Excel app itself — different from the Microsoft 365 connector covered here. The add-in does in-cell work inside the app you’re driving; the connector path in this guide is read-only by default and, with admin write tools, only file-level.
What if I want my spreadsheet kept current without me in the chat?
That’s outside what Claude’s connector does — even with write tools it has no event triggers, so nothing runs because the data arrived. Carly fires on the event itself, writing to your spreadsheet, sending email, and updating your tools as data arrives. AI agents start at $35/month.
More: Claude connectors · Claude for Microsoft 365 · Can Claude send emails · Claude vs Carly · Claude Cowork alternatives · Best AI agents for productivity
Ready to automate your busywork?
Carly schedules, researches, and briefs you—so you can focus on what matters.
See what people say
"Before Carly, I relied on a Calendly link, but the whole process felt impersonal and not very professional. Carly changed that by handling all the back-and-forth, so I'm no longer stuck in endless email threads trying to line up schedules.
Now Carly reaches out to candidates, shares my real-time availability, lets them pick a slot, then sends a Zoom link and drops it straight into my calendar. She sends reminders to both of us before each call, which has significantly reduced no-shows and last-minute confusion.
On top of scheduling, Carly acts like a full executive assistant, sending me my schedule the night before so I can prepare for each call. It reminds me of the old x.ai assistant, but Carly is noticeably smarter, faster, and better suited to my healthcare recruitment business."
