How to Use Claude with Excel: The Complete Guide

Q: Is Claude for Excel free?

The Claude for Excel add-in requires a paid plan — Claude Pro (from $20/month), Max, Team, or Enterprise. But you can use Claude with Excel for free by uploading a spreadsheet to Claude.ai, or by asking Claude to write formulas and macros you paste in yourself.

Q: Can Claude write VBA macros for Excel?

Yes — Claude can write VBA, Office Scripts, and Python when you describe what you want in a chat (on Claude.ai or the desktop app), and you paste the code into Excel. Note that the Claude for Excel add-in itself cannot read or modify existing macros or VBA in a workbook; that's a deliberate limitation. Always review and test any macro before running it.

Q: Can Claude read my entire workbook?

The add-in can read and navigate multi-tab workbooks and answers questions with cell-level citations, so it can tell you exactly where a number came from. It supports .xlsx and .xlsm files but not the older .xls format, and it cannot work with Data Tables.

Q: Claude or Copilot — which is better for Excel?

It depends on the job. Copilot has the deepest native integration (it's built into the Excel grid) and is great for fast, everyday edits. Claude is especially strong at explaining and tracing complex models, debugging, and writing clear code. Many people use both.

There are three practical ways to use Claude with Excel: install the Claude for Excel add-in to read and edit your open workbook from a sidebar, upload a spreadsheet to Claude.ai for analysis and formula help, or simply ask Claude to write a formula, macro, or script that you paste back into Excel. The add-in is the most capable option for working inside a live workbook and is available on paid Claude plans, but the other two work for anyone — and each is better suited to different jobs.

This guide covers all three, with real prompts that work, the limitations most write-ups skip (the add-in does not touch macros or VBA), and how Claude stacks up against Microsoft Copilot and ChatGPT for spreadsheet work.

The three ways to use Claude with Excel — and when to use each

Method	Best for	Who can use it
Claude for Excel add-in	Understanding, editing, and debugging a live workbook in place	Claude Pro, Max, Team, Enterprise
Upload a file to Claude.ai	One-off analysis, cleaning logic, summarizing, explaining formulas	Anyone (free tier included, with limits)
Ask Claude to write code	Generating formulas, VBA macros, Office Scripts, or Python	Anyone

A quick mental model: use the add-in when you want Claude working inside your spreadsheet; use Claude.ai upload when you just want answers about a file; and ask Claude to write code when you need something the add-in deliberately won’t do, like a macro.

Method 1: The Claude for Excel add-in

The Claude for Excel add-in puts Claude in a sidebar next to your worksheet. It can read the open workbook with cell-level citations (so it tells you exactly which cells an answer came from), make edits while preserving your formulas and dependencies, and highlight every change it proposes before applying it.

Who can use it, and on which versions

The add-in is available on the Claude Pro (from $20/month), Max, Team, and Enterprise plans. It runs on:

Excel on the web
Excel on Windows (Microsoft 365, build 16.0.13127.20296 or newer)
Excel on Mac (version 16.46 or newer)
Excel on iPad (version 2.51 or newer)

It does not work on the perpetual Excel 2016 or 2019, on Excel for Android, or on older Microsoft 365 builds. If you’re on a one-time-purchase version of Office, this add-in isn’t an option — a common reason people can’t find it.

How to install it

Open the Claude for Microsoft 365 listing on the Microsoft Marketplace (AppSource). You can also reach it from inside Excel via Insert → Get Add-ins and searching for “Claude.”
Click Get it now and follow the prompt to add it to Excel.
Open Excel, find Claude under Home → Add-ins (Windows) or Tools → Add-ins (Mac), and open it.
Sign in with your Claude account. The sidebar appears and is ready to use.

If you’re in an organization, an admin may need to approve or deploy the add-in through the Microsoft 365 Admin Center before it shows up for everyone.

What the add-in can do

Once it’s open, Claude for Excel can:

Answer questions about the workbook with cell-level citations — “Where does this number come from?” or “Which sheet controls these results?”
Trace dependencies — “Which cells feed into this P&L summary?”
Run what-if changes — adjust an assumption like a tax rate or growth figure and let Claude update the model while keeping every formula intact.
Debug errors and find the root cause of a #DIV/0!, #REF!, or #VALUE! — see our guide to Excel error codes for what each one means.
Build models or fill in templates from a description.
Navigate multi-tab workbooks and summarize what each sheet does.
Sort, filter, and edit PivotTables and charts, and apply conditional formatting and data validation.
Use connectors and Skills to pull in outside context or run repeatable workflows, and follow persistent instructions you set once.

Every session is logged to a “Claude Log” tab the add-in adds to your workbook, so you have a record of what changed.

What the add-in cannot do (read this first)

This is where most articles go quiet. The Claude for Excel add-in cannot:

Read or modify macros or VBA code
Work with Data Tables (the what-if feature)
Open the old .xls format — it supports .xlsx and .xlsm only

Anthropic also explicitly says it’s not the right tool for final client deliverables without human review, audit-critical calculations without verification, or highly sensitive and regulated data without proper controls. Treat Claude as a fast, knowledgeable assistant — not an unsupervised replacement for your own judgment. Always sanity-check the numbers, especially anything money-related where a rounding error or a common formula mistake can hide.

Method 2: Upload a spreadsheet to Claude.ai

If you don’t have a paid plan, or you just want answers about a file rather than live edits, upload the spreadsheet to Claude.ai (or the Claude desktop app) and ask away. This works with .xlsx and .csv files.

This path is ideal for:

Analysis — “What are the top three trends in this sales data?”
Explaining a formula — paste a gnarly nested IF and ask “What does this do, in plain English?”
Planning a cleanup — “This export is messy. What steps should I take to clean it?” Pair it with our clean-messy-data checklist.
Generating a structure — “Design a monthly budget layout with these categories.”

The trade-off: Claude.ai works on a copy of your data in the chat. It won’t live-edit the file on your computer — you apply its suggestions yourself. For many people that’s actually preferable, because nothing changes in your real workbook until you decide it should.

Method 3: Ask Claude to write formulas, VBA, or Office Scripts

Because the add-in deliberately won’t write macros, this is how you get them. Describe the result you want and Claude will write the code; you paste it into Excel and run it. Claude is strong at:

Formulas — “Write a formula to count unique client names in column B.” (New to functions? Start with the complete guide to Excel formulas.)
VBA macros — “Write a macro that saves each worksheet as its own PDF.” Learn how to add and run one in our VBA for beginners guide.
Office Scripts — the modern, cloud-friendly alternative to VBA for Excel on the web.
Python in Excel — for heavier analysis inside a workbook.

One rule: always read code before you run it, and test it on a copy first. AI-generated code can contain mistakes, a macro is powerful, and you’re the one accountable for what runs in your file.

Great prompts to use with Claude in Excel

The quality of what you get back depends on the prompt. These patterns work well:

“Explain what the formula in cell D2 does, step by step.”
“Why is cell F10 showing #REF!, and how do I fix it?”
“Which input cells affect the total in cell B25?”
“Build a 12-month cash-flow projection from these monthly figures.”
“Write a formula that returns the latest date for each customer in this table.”
“If I raise the growth rate in B2 from 5% to 8%, what happens to the year-3 total?”
“Turn this raw export into a clean table: trim spaces, fix the dates, and split the full-name column.”

Give Claude context (what the sheet is for, which version of Excel you’re on, Windows or Mac), and be specific about the output you want. Vague prompts get vague answers.

Claude vs. Copilot vs. ChatGPT for Excel

They overlap, but each has a clear sweet spot. Be honest about the trade-offs:

	Claude	Microsoft Copilot	ChatGPT
How it connects	Sidebar add-in, or file upload	Built natively into the Excel grid	Copy-paste, or file upload
Best at	Explaining and tracing logic, debugging large multi-tab models	Fast inline edits and everyday tasks	Quick formula help and one-off analysis
Live workbook edits	Yes (add-in), changes highlighted first	Yes, deepest grid integration	No native live editing
Macros / VBA	Writes code in chat; add-in won’t touch existing macros	Limited	Writes code you paste in
Where it lives	Pro and up	Microsoft 365 Copilot license	Free and paid tiers

The honest summary: Copilot has the deepest native integration because Microsoft builds it into Excel itself, which makes it great for quick, in-grid edits. Claude tends to shine at understanding and explaining — tracing how a complicated model works, debugging it, and documenting it — and at writing clear code. ChatGPT is the most accessible for fast formula questions. Many people use more than one. If you’re also weighing platforms, our Excel vs. Google Sheets comparison covers that side of the decision.

Is it safe? Data and privacy

A reasonable question before you point an AI at a financial model. The key facts for Claude for Excel:

Your inputs and outputs are automatically deleted within 30 days on Anthropic’s backend (with limited stated exceptions).
Chat history is stored locally in your browser, not on Anthropic’s servers.
Only use it with files you trust. Spreadsheets can carry hidden cells, comments, or imported text that contain instructions designed to mislead an AI (a “prompt injection”). Stick to internally created models and approved templates rather than unknown files from outside sources.
For regulated or highly sensitive data, don’t use it without your organization’s proper controls in place. Enterprise plans add audit options that the Free, Pro, Max, and Team plans don’t include.

In short: it’s built with sensible data handling, but you stay responsible for what you feed it and what you ship.

Tips for getting better results

Work on a copy of important workbooks until you trust the output.
Verify the numbers. Claude speeds you up; it doesn’t absolve you of checking the math.
Be specific. Name the cells, the sheet, and the exact result you want.
Use persistent instructions in the add-in for rules you always want followed (formatting conventions, rounding rules, etc.).
Combine tools. Let Claude explain and draft; let your own Excel skills do the final review. If you want to go deeper on the fundamentals, the essential functions for office workers and PivotTables guide are good next stops.

And if you’d rather not build a budget, tracker, or calculator from scratch at all — with or without AI — our ready-made Excel templates give you a polished, formula-driven workbook you can use in minutes.

Frequently Asked Questions

Is Claude for Excel free?

The Claude for Excel add-in requires a paid plan — Claude Pro (from $20/month), Max, Team, or Enterprise. But you can use Claude with Excel for free by uploading a spreadsheet to Claude.ai, or by asking Claude to write formulas and macros you paste in yourself.

Which versions of Excel support the Claude add-in?

Excel on the web, Excel for Windows (Microsoft 365, build 16.0.13127.20296 or newer), Excel for Mac (16.46+), and Excel on iPad (2.51+). It does not work on the perpetual Excel 2016 or 2019, on Excel for Android, or on older Microsoft 365 builds.

Can Claude write VBA macros for Excel?

Yes — Claude can write VBA, Office Scripts, and Python when you describe what you want in a chat (on Claude.ai or the desktop app), and you paste the code into Excel. Note that the Claude for Excel add-in itself cannot read or modify existing macros or VBA in a workbook; that’s a deliberate limitation. Always review and test any macro before running it.

Can Claude read my entire workbook?

The add-in can read and navigate multi-tab workbooks and answers questions with cell-level citations, so it can tell you exactly where a number came from. It supports .xlsx and .xlsm files but not the older .xls format, and it cannot work with Data Tables.

Claude or Copilot — which is better for Excel?

It depends on the job. Copilot has the deepest native integration (it’s built into the Excel grid) and is great for fast, everyday edits. Claude is especially strong at explaining and tracing complex models, debugging, and writing clear code. Many people use both.

Is my data used to train Claude?

For Claude for Excel, inputs and outputs are automatically deleted within 30 days, and chat history is stored locally in your browser rather than on Anthropic’s servers. Still, treat any AI tool with normal caution: only use files you trust, and keep regulated or highly sensitive data behind your organization’s approved controls.