Claude Excel Connector: Can Claude Edit Excel Files?
Yes. Add the Carly connector to Claude, connect Excel, and you can set up triggers right from the chat: when this happens, update that spreadsheet. “When a new order email comes in, add a row to the Orders workbook.” You type it once in Claude. Carly adds it every time, whether Excel or Claude is open or not.
Where Claude and Excel fall short today
Claude reaches Excel two ways: the Claude for Excel add-in, which edits the workbook you have open, and the Microsoft 365 connector, which reads files in OneDrive and SharePoint. Here’s where they stop:
- The add-in only works while the workbook is open. Close the file and nothing updates until you open it and ask again.
- No macros or VBA. Anthropic lists them as unsupported, and the add-in doesn’t run on Excel for iPad.
- It’s a paid-plan feature. Claude for Excel is on Pro, Max, Team and Enterprise.
- Files from outside can carry tricks. Anthropic warns that downloaded templates and vendor files can contain prompt injections.
- The connector needs a work account. The Microsoft 365 connector doesn’t take personal Microsoft accounts, and its write tools only work if your admin turns them on.
How Carly fixes it
- Two minutes to set up. Add the Carly connector, sign in to Excel in Carly, done.
- Updates with the file closed. Carly adds rows, updates totals and copies data in, whenever the trigger fires.
- Reports go out on their own. Carly emails the numbers to whoever needs them, on your schedule.
- Every account and thousands of apps. Carly works with personal and work Microsoft accounts, every Gmail and Outlook inbox, and thousands of apps, including Stripe, Shopify and HubSpot.
How to connect Excel to Claude
- Add Carly to Claude. Click Get the Carly connector, then Connect, and sign in.
- Connect Excel in Carly. Open Integrations, find Microsoft Excel and sign in.
- Tell Claude what should happen, and when. Carly sets up the workflow and runs it from then on.
Seeing “Need admin approval”? Watch the quick fix.
Triggers you can set up from Claude
Type these into Claude. Each one becomes a trigger that runs in the cloud, whether or not you’re in the chat:
- “When a new order email comes in, add a row to the Orders workbook.”
- “When a Stripe payment lands, log it in the Revenue sheet.”
- “Every Monday at 8, email the team the totals from the Pipeline workbook.”
- “When a form is submitted, add the answers to the Leads workbook and email me.”
- “When a row in the Tasks sheet is marked Done, email the client.”
Steps that don’t need AI run as free Zapier-style workflows.
Ask Claude about your spreadsheets
- “What were our top ten products by revenue in the Sales workbook last month?”
- “Which rows in the Leads sheet have no follow-up date?”
- “Summarize the Budget workbook for my 2pm with Claire.”
Free Zapier-style workflows; AI agents from $35/month. Get started.
FAQ
Can Claude edit Excel files?
Yes. The Claude for Excel add-in edits the workbook you have open, on paid Claude plans. With the Carly connector, Claude can also update your workbooks when they’re closed, on a trigger or a schedule, through Carly.
Can Claude read Excel files?
Yes. Upload one to a chat, use the Claude for Excel add-in, or reach files in OneDrive and SharePoint through the Microsoft 365 connector.
Does it work with a personal Microsoft account?
The Microsoft 365 connector needs a work account. Carly connects personal and work Microsoft accounts.
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."
