Claude for Excel in 2026: a beginner's guide
It is 9:10 in the morning. Your manager has just dropped a workbook on you with three tabs, eighty-seven columns and a question that sounds simple: "which five customers have fallen behind on payments the most this quarter?". You stare at the sheet, glance at the clock and think about the coffee you have not had yet. Six months ago this afternoon would disappear into filters, weird formulas and a pivot table that comes out twisted. Today you open a side panel, type the question in plain English, and Claude returns the names sorted by how late they are, with outstanding amounts and days overdue.
This is not science fiction. Since 24 January 2026, Claude for Excel has been available to every Pro, Max, Team and Enterprise subscriber. In other words, anyone with a paid claude.ai account can have a copilot living inside their spreadsheet, reading cells, writing formulas and applying formatting without leaving the file. In this guide you will see exactly what it is, how to install it, what it does well today and where it is still rough, all in plain language without jargon.
What Claude for Excel is and why it is different
Claude for Excel is an add-in that runs inside your Excel. It is not a separate website, it is not a weird macro: it shows up as a chat panel on the right of your workbook. You talk to it in plain English, ask for things, and Claude has real access to the cells, sheets, formats and pivot tables of the file you have open.
The difference with copy-pasting your data into claude.ai is huge. When you paste a table into a normal conversation, Claude only sees text. Here it sees structure: it knows which columns exist, what data types they hold, which cells are locked, which sheets are linked. Most importantly, it can act: sort, filter, write formulas, create new tabs, adjust conditional formatting or get the document ready to print.
Under the hood the add-in runs on Claude Opus 4.6 (with Opus 4.7 already arriving as an option for higher tiers). That means advanced reasoning and the ability to follow long, tangled instructions without losing the thread. The March 2026 update also brought shared context between Excel and PowerPoint: what you analyse in a sheet can feed straight into your slides without re-explaining anything.
Install and first run in five minutes
The actual process to get this working on your machine:
Step 1. Open Excel for Windows or Excel for the web (you need Microsoft 365, not the boxed Excel from 2018). On the Insert tab, click Add-ins and then Get Add-ins.
Step 2. Search for Claude by Anthropic or Claude for Excel. Make sure the publisher is Anthropic, not a copycat with a similar logo. Hit Add and accept the permissions. Install takes less than a minute.
Step 3. A new Claude icon appears on the ribbon, on the Home or Data tab depending on your version. Click it and the side panel opens. The first time it asks you to sign in with your Claude account. Use the same one you use at claude.ai. If your subscription is below Pro, you will see a prompt to upgrade.
Step 4. To open Claude quickly from now on: Ctrl + Alt + C on Windows, Ctrl + Option + C on Mac. Worth memorising because you will be using it often.
If you hit the classic "the add-in failed to load" message, the most common cause is an old Office build. The minimum is 16.0.13127.20296. Inside Excel, go to File → Account → About Excel to check, and run Update Now if you are below.
Five real flows that already speed up office work
To make this concrete, here are five scenarios you can try tomorrow morning.
Cleaning imported data. You get a CRM dump with names in caps, phone numbers in mixed formats and dates as text. The old fix was a chain of TRIM, UPPER, PROPER and TEXT functions. Now you tell Claude: "Normalise column B to First Last with title case, and convert column F to date in DD/MM/YYYY format". It does it and shows you the result before saving.
Pivot tables for non-experts. Pivot tables intimidate half of every office. With Claude you just type: "Create a pivot table showing sales by rep and month, with totals and percentage of total". It builds the table on a new sheet, formats it and, if you ask, adds a chart on top.
Auditing inherited formulas. We have all opened a workbook full of formulas written by someone who left the company three years ago. Ask Claude to scan tab X and explain in plain English what each block calculates, where there are circular references and which cells depend on external sources that no longer exist.
Budget vs actual variance analysis. A finance classic. Load budget on one sheet, actuals on another and ask for variance analysis with absolute and percentage deltas, sorted by largest gap. Half a morning of work, three minutes now.
Preparing a file to print or send. Adjusting margins, repeating headers, configuring page breaks and a decent header can take more than the analysis itself. Claude does it in a single prompt: "Get this workbook ready to print on A4 landscape, with repeating headers and the company logo top-left".
What it still does not do well, and traps to avoid
Not everything is rosy. Worth knowing before you spend time on it.
Old macros and VBA are still hostile territory. Claude can read and explain VBA, but its recommendation will almost always be to rewrite the flow with modern formulas or Power Query, not patch the VBA. If your work depends on a fifteen-year-old macro, weigh case by case.
Massive files (over 200,000 rows or many tabs with heavy array formulas) slow down the response. The side panel works, but reasoning over and applying changes to giant datasets takes time. For those volumes many people still push data into a database and query it from Claude using SQL.
You need to watch privacy. By default sheet data is sent to the Claude API for processing. On Enterprise plans you can deploy via Amazon Bedrock, Vertex AI or Microsoft Foundry so data never leaves your infrastructure. If you handle sensitive financial or health information, talk to your IT team before installing.
A golden rule: always review what Claude proposes before saving. The interface asks for confirmation on changes that touch cells, and that is an important safety net. Do not "Apply All" without looking.
Is paying for Pro worth it just for this?
If your day involves more than an hour of Excel, almost certainly yes. The Pro subscription is around $20 a month. If it saves you two hours a month, it pays for itself comfortably at typical office hourly rates. And that is before counting everything else Claude does outside Excel: writing, document analysis, coding, search, presentations.
If you only need Excel for very occasional tasks, alternatives exist. Manually copying tables to claude.ai still works for one-offs. Microsoft Copilot inside Office is another option if your company already has the licence. The choice depends on what you need: for finance, consulting and operations work, Claude for Excel earns its keep quickly.
At learnaifast.io we run courses designed for people getting started with Claude without prior AI experience. Spreadsheets are one of the first use cases where the gain is obvious from day one, so it is a great entry point.
Next steps to start today
If you have read this far, here is a concrete plan for the week. Today: install the add-in and try it on a real file, not a demo. Tomorrow: pick one repetitive Excel task from your job and ask Claude to do it. Wednesday: show a colleague the trick, watching it on someone else triggers ideas. Thursday: configure a saved shortcut or flow for the things you do most. Friday: review what you have saved and decide whether the Pro is worth keeping.
The integration will keep improving. Reusable Skills, connectors with S&P Global, LSEG, PitchBook and Moody's, enterprise deployments on the cloud of your choice. The learning curve starts now and, like most things in AI, those who climb on early take the lead.
Want to learn how to weave Claude into your everyday work without losing your mind? Have a look at our beginner courses and start with the fundamentals one. In less than an afternoon you will have a clear sense of how to use Claude, not just in Excel but in everything you do with a computer.
