Your Spreadsheet Just Got a Brain
How Claude in Excel Changes Everything (And Why Microsoft Should Be Embarrassed)
Word of the Day
Add-in is a mini-program that lives inside another program, giving it new abilities it didn’t have before.
Think of it like installing a new app on your phone. Your phone worked fine before, but now it can do something new. An add-in does the same thing for Excel.
Why this matters for your business: The Claude add-in for Excel means you can now have a conversation with your spreadsheet. Ask it questions. Tell it what to fix. Have it explain formulas to you like you’re a human being, not a computer science major.
What Actually Happened
Anthropic released Claude as an Excel add-in. You install it, and suddenly there’s a sidebar in your spreadsheet where you can talk to Claude directly.
Here’s the stat that should stop you cold: Microsoft has had Copilot in Excel for over a year. They own both products. And they still couldn’t make it work as well as Claude does after one week.
What You Can Actually Do With This
Let me give you some real examples. Not the marketing fluff. What actually works.
Understand Inherited Spreadsheets
Someone hands you a spreadsheet with 47 tabs and formulas that look like ancient hieroglyphics. Instead of pretending you understand, click on a cell and ask: “Explain what this formula does in plain English.”
Claude will trace it back to its source. Tell you what it’s calculating. And explain why that weird SUMIF is nested inside that VLOOKUP.
This is the feature I wish I’d had for the past decade.
Find Errors (For Real This Time)
Now you can ask: “Find all #REF and #VALUE errors in this workbook and tell me why they’re happening.”
Claude will highlight every problem cell and explain the root cause. Not “check if something references a deleted cell.” The actual problem.
Clean Messy Data
You get a data export. Dates in five different formats. Names split wrong. Duplicates everywhere. This usually takes hours.
Now you can say: “Convert all dates to YYYY-MM-DD format” or “Find and remove duplicate rows, keeping the most recent.”
Claude highlights every cell it touches. You see exactly what changed before you commit to anything.
Build Financial Models From Scratch
“Build a 12-month revenue forecast using my historical data.” That’s it. That’s the prompt.
Claude will create the formulas, set up the structure, and explain what it built. You’re not starting from a blank sheet anymore.
Extract Data From PDFs
Someone sends you a PDF with financial tables locked inside. You upload it directly to Claude in Excel and say: “Extract the financial table from this PDF into my spreadsheet.”
Done. No more retyping. No more expensive converter tools.
How to Set It Up
This is refreshingly simple.
Make sure you have Excel installed. If you’re on Mac, you can download it free from Microsoft: go.microsoft.com/fwlink/p/?linkid=525135
Go to the Microsoft Marketplace and search for “Claude” or just USE THIS LINK. Click “Get it now.”
Open Excel. On Mac, go to Tools, then Add-ins. On Windows, go to Home, then Add-ins.
Sign in with your Claude account. If you don’t have one, create it at claude.ai.
Use the keyboard shortcut to open Claude: Control+Option+C on Mac or Control+Alt+C on Windows.
One honest note: You need a paid Claude subscription ($17/month) for this to work. I know that’s another subscription. But if you spend more than an hour a month fighting with spreadsheets, it pays for itself.
What It Can’t Do (Yet)
I’m not going to pretend this is perfect. Here’s where it falls short:
No macros or VBA. If you’re running complex automation, this won’t replace it.
No Power Query or Power Pivot. The advanced data transformation tools are still out of reach.
No external database connections. It works with what’s in your spreadsheet.
And Anthropic is very clear: don’t use this for final client deliverables without review, audit-critical calculations without verification, or models with highly sensitive data without proper controls.
Translation: It’s a tool, not a replacement for thinking. Check its work.
The Bottom Line
For years, we’ve been told AI would transform how we work with spreadsheets. We got clunky integrations and broken promises.
This is different. Not because it’s perfect. But because it actually works the way we were promised AI would work.
You talk to it. It understands your spreadsheet. It helps you fix things, build things, and understand things.
Is it there yet? No. Are we getting closer? Absolutely.
We’ll get there. Together.
SmartOwner is published (almost) daily by Scott McIntosh at DigitalTreehouse. Want AI consulting or automations for your business? Reply to this email.