Claude in Excel: The $80/Month Feature That's Now $20

The Excel AI sidebar that used to be a premium-tier perk now rides along with the plan most marketers already pay for.

For a while, Anthropic’s Excel add-in was locked behind the top Max tier, the one that runs well into three figures a month. Then the Skills update folded it into the regular Pro plan, the roughly $20-a-month tier most marketers already carry. Same tool, a fraction of the cost. If you live in spreadsheets, building campaign models, picking apart performance data, scrubbing CRM exports, that change matters.

I’ve been reaching for it more and more. Here’s what it does, where it earns its keep, and the spots where it still falls short.

Claude in Excel: Why the $20 Plan Changes EVERYTHING (MarketingAlec on YouTube)

What Claude in Excel actually is

Claude in Excel is Anthropic’s official Microsoft Excel add-in. It drops a sidebar into your Excel window where you talk to Claude about the workbook you have open.

This isn’t copy-paste or a browser extension bolted on the side. Claude reads your open workbook directly: cells, formulas, tab structure, all of it. When it explains something, it cites the exact cells it’s looking at. When it changes something, it highlights what it touched and tells you why. You can see the work.

A few specifics worth knowing:

Works on Excel 2016 and newer (Mac, Windows, and Excel on the web)
Runs Anthropic’s top Opus model, and you don’t get to pick the model yourself
Keyboard shortcut: Ctrl+Option+C on Mac, Ctrl+Alt+C on Windows
Install from the Microsoft Marketplace: search “Claude by Anthropic in Excel”

The pricing shift

The short version: the Skills update extended Excel access to Pro subscribers, the ~$20/month plan. Before that, it was Max-only. That’s the whole reason this went from a “maybe later” tool to one I’d actually recommend to a marketer on a normal plan.

One gotcha trips people up. You have to flip two toggles in your Claude settings:

“Code execution and file creation”
“Skills”

Without both turned on, the Excel add-in won’t work even if you’re paying for Pro. Check those first before you assume something’s broken.

Where it earns its keep for marketers

This is the part that matters for the AI marketing work I do every week. Here’s where Claude in Excel pulls real weight.

Campaign performance analysis. Feed it a performance export and ask plain questions:

“Which channels had the highest CPA increase month over month?”
“Flag campaigns where CTR dropped more than 20% while spend went up.”
“Build a summary table of my top 10 campaigns by ROAS.”

It points back to specific cells in every answer, so you can check its math instead of trusting it.

Budget modeling. When you’re building a budget with multiple scenarios:

“Create a budget template with columns for Q1 through Q4, a row per channel, and formulas for totals and year-over-year change.”
“Add a toggle that switches between conservative, moderate, and aggressive growth assumptions.”

It keeps the formula dependencies intact, so the model still works after it edits.

Data cleaning. For the messy CRM and campaign exports that eat your afternoon:

“Standardize the dates in column C to YYYY-MM-DD.”
“Split the Full Name column into First Name and Last Name.”
“Find and flag duplicate email addresses.”

Reporting templates. For the reports you rebuild every month:

“Lay out a dashboard with conditional formatting that turns underperforming metrics red.”
“Add VLOOKUP formulas that pull campaign names from the reference sheet.”

Attribution. For multi-touch models:

“Build a weighted attribution model: 40% first touch, 40% last touch, 20% split across the middle.”
“Write an INDEX-MATCH formula to pull conversion data by campaign ID.”

MA free resource: 5 Excel Prompts for Marketers

Claude vs Copilot: which one

This is a routing call, the same kind I work through across all my AI tool comparisons. The real split comes down to control.

Claude leaves your file where it is. No forced AutoSave, no cloud requirement. Microsoft Copilot wants OneDrive and AutoSave switched on, which isn’t always how you want to work, especially with client data you’d rather keep local.

On price, the lines have blurred. Claude Pro and ChatGPT Plus sit in the same low monthly range, and Copilot runs a bit higher depending on the plan. ChatGPT, for what it’s worth, has no native Excel integration at all. So the spreadsheet decision isn’t really about a few dollars. It’s about whether you want your file local and the AI’s edits cited, or whether you’re already deep enough in the Microsoft 365 world that having Copilot right there wins.

Where it still falls short

Before you go all in, the limits. A few of these matter; most won’t for everyday marketing work.

What it won’t open:

Only .xlsx and .xlsm files
A file-size ceiling in the tens of megabytes
Only the workbook you currently have open

What it can’t build:

Conditional formatting (it’ll explain how, but won’t set it up)
Data validation rules
VBA macros
Data tables
External add-in functions

A couple of workflow notes:

Chat history doesn’t carry between sessions, so context resets each time
The model is locked, no swapping to something faster or cheaper
It only sees the open workbook, so it can’t reference your other files

For most marketing spreadsheet work, none of that gets in the way. If you’re maintaining macro-heavy reports with custom VBA, Claude isn’t the tool for that job.

One warning worth taking seriously

Anthropic puts it plainly: use Claude in Excel only with spreadsheets you trust.

That’s not legal-page filler. The risk has a name: prompt injection. Instructions can be hidden inside cells, formulas, or comments. Open an untrusted spreadsheet, ask Claude for help, and those buried instructions could push it into:

Sending data out to an external URL
Rewriting formulas in ways that mask errors
Taking destructive actions you didn’t ask for

So keep it simple:

Don’t point it at downloaded templates from sources you don’t know
Be careful with vendor-supplied spreadsheets
Skip files from email attachments you haven’t checked
Stick to workbooks you or your team built

Quick start

Ready to try it?

Confirm your plan: Claude Pro or higher.
Enable both features: in Claude settings, turn on “Code execution and file creation” and “Skills.”
Install the add-in: Microsoft Marketplace, search “Claude by Anthropic in Excel,” get it here.
Open Excel: Insert > Add-ins (or Home > Add-ins), find Claude.
Sign in with your Claude credentials.
Start on a trusted file, something simple you made.
Ask before you edit: have it analyze first, then let it make changes.

Shortcut to remember: Ctrl+Option+C (Mac) or Ctrl+Alt+C (Windows) opens the Claude sidebar.

Go deeper

Steal the spreadsheet prompts before you build your own

Every Friday I send marketers one workflow I’m actually running that week, broken down to the exact prompts and the cells Claude touched. The Excel sidebar is one of them; there’s a whole stack I’d hand a new hire on day one. If you’d rather copy a tested setup than reinvent it in a blank workbook, grab the rest of the kit.

Subscribe free →