Claude for Excel: How to Automate Spreadsheet Work with AI
Two ways Claude handles Excel: the add-in that works inside your spreadsheet, and Cowork that works on spreadsheet files. Here's how to use both.
Quick Answer: There are two ways to use Claude with Excel. The Claude in Excel add-in works inside Microsoft 365 spreadsheets: ask it in plain English to build formulas, clean data, analyze numbers, and format sheets. Claude Cowork works on Excel files at the folder level: point it at spreadsheets on your computer and it builds reports, merges data, and runs recurring spreadsheet tasks in the background. The add-ins went GA in May 2026, and both routes are included with paid Claude plans.
Why "Claude for Excel" means two different things
Excel is where small business work actually lives: budgets, client trackers, pricing sheets, inventories, campaign data. Claude meets it at two levels.
Inside the spreadsheet: Claude in Excel. Anthropic's Microsoft 365 add-ins for Excel, PowerPoint, and Word reached general availability in May 2026. In Excel, Claude sits in your sheet and takes instructions like "add a column calculating month-over-month growth" or "find the duplicates in this customer list and flag them." It writes the formulas so you don't have to remember whether it's XLOOKUP or INDEX MATCH. This is interactive: you're in the file, working with Claude turn by turn.
On the files: Claude Cowork. Cowork operates at the folder level. Give it permission to a folder of spreadsheets and delegate whole jobs: "Combine these twelve monthly expense files into one annual summary with a breakdown by category and a written analysis of the trends." Cowork opens the files, does the work, and saves the result. It can also run this on a schedule, and it can use Claude in Excel as a tool when a task calls for it. This is delegation: you come back to finished work.
The practical split: use the add-in when you're actively in a sheet, use Cowork when the spreadsheet work is a task you want off your plate.
Recommended skills
Enterprise Automation Engineering Architect
by Shandra
Designs and upgrades business automation systems into modular, reliable, observa…
Small Business Social Media Kit Builder
by PromptWagon
Generate structured social media kits, content calendars, and caption banks for…
Facebook Ad Copy Writer Agent
by Shandra
Writes simple, persuasive Facebook and Instagram ad copy for products, services,…
What this replaces in real work
Formula archaeology. Plain-English requests replace formula syntax. Nested IFs, pivot logic, conditional formatting rules: describe the outcome and it gets built.
Manual data cleanup. Deduplication, format standardization, splitting and merging columns, fixing the mess an export dumped on you. This is high-volume, low-judgment work, which is exactly what agents are for.
Recurring reports. The Monday sales rollup, the monthly budget-vs-actual, the client-facing summary built from the same source sheet every time. Set it up once as a scheduled Cowork task and stop rebuilding it by hand.
Analysis you'd otherwise skip. "What's driving the variance in Q2?" is a question most small teams never get to because someone would have to dig. Claude digs and writes up what it finds.
The honest limitations
Claude is very good at mechanics and pattern work in spreadsheets and needs your judgment on meaning. It won't know that March revenue looks weird because a client paid early unless the data or your instructions say so. Verify outputs on anything that feeds a decision, keep your source files backed up (Cowork asks before destructive actions, but backups are still hygiene), and remember heavy multi-file tasks consume plan usage: details in the pricing guide.
Skills: the difference between generic and expert spreadsheet output
A raw agent builds a competent summary. A skill builds the summary your role actually requires. Skills on Agensi encode how a professional structures financial reviews, marketing performance rollups, bookkeeping categorization, and client-ready reports: the format, the sanity checks, the standards. Install one and every spreadsheet task Cowork runs inherits that discipline. Browse data and reporting skills at agensi.io/browse, and if your exact workflow doesn't exist, request it and 200+ creators get notified.
For adjacent workflows, see AI for financial analysis and AI for bookkeeping.
Keep reading
- Claude Cowork for Small Business: Real Use Cases and Setup
- What Is Claude Cowork? The Complete Guide for Non-Technical Users
- How to Automate Office Work with Claude Cowork
- Claude Cowork Plugins: What They Are and How They Compare to Skills
- Claude Cowork Pricing Explained: What It Costs and Which Plan You Need