How to Use Claude in Excel:
Chat, Cowork and Add-In Compared

Claude has been able to work inside Excel for a while now. This is not a launch post. I am writing it because I keep watching professionals hit the same walls, and every wall exists because nobody showed them how to actually use it.

Excel is part of my daily job at brisk., and I am not a heavy user, which is exactly why I never learned the deep formulas or the shortcuts everyone assumes you already know. I struggled with it, quietly, for years. Then Claude for Excel showed up, and now I enjoy the thing: I can finally produce what I pictured in my head without knowing the formula to get there, and it does the boring data cleanup I used to grind through by hand.

Claude can hand you a confidently wrong formula. Speed is the gift. Verifying is the rent you pay for it, and it costs you two minutes.

What Are the 3 Ways to Use Claude With Excel?

Claude chat, Cowork, or the Excel add-in, and picking the wrong one for the job is the first mistake I watch people make.

• Claude chat (paste or upload). The fast, no-setup path. Open Claude in your browser or desktop app, paste a few rows straight into the chat, or upload the whole file. Use it for a quick "fix this one formula" question, or when you are not even in Excel.
• Cowork. Cowork works with the actual files sitting in the folders on your computer, opening your spreadsheet, editing it in place, and saving it back with no uploading or re-downloading. Use it when the file already lives on your machine and you want it handled, not babysat through a chat window. I cover the full setup in Cowork.
• Claude for Excel (the add-in). The one worth your attention. Claude sits in a sidebar inside Excel, reads your live open workbook, and edits it while preserving your formula dependencies. It cites the exact cells it is talking about and highlights every change it makes.

The failure is staying in the chat window forever, pasting cells, never installing the add-in that does the real work.

Setting up the add-in

• Install "Claude by Anthropic for Excel" from the Microsoft Marketplace.
• You need a paid Claude plan (Pro, Max, Team, or Enterprise) and a Microsoft 365 work or school account. Personal @outlook.com accounts and old perpetual versions like Excel 2016 or 2019 are not supported.
• Open Excel, activate the add-in, sign in with your Claude account, then open the sidebar with Ctrl+Alt+C on Windows or Ctrl+Option+C on Mac.

Claude's spreadsheet features move fast, so confirm the exact menu path on Anthropic's site before you rely on it.

How Do You Write Excel Formulas in Plain English?

You describe the outcome you want, and Claude writes the exact formula, then explains what each piece does in one line.

You do not learn VLOOKUP, INDEX MATCH, or nested IF statements. Excel is a language you were never taught, and every symbol, comma, and dollar sign is just syntax you were expected to pick up on your own.

You were never bad at Excel. You were bad at a language nobody taught you. That was never the same thing.

Copy-paste prompt:

I have a sheet where column A is client name, column B is invoice
date, and column C is amount. I want column D to show "overdue" if
the invoice date is more than 30 days ago, otherwise "ok". Give me
the exact formula to paste into D2, and tell me in one line what
it does.

The magic is the second half: "tell me in one line what it does." That sentence turns every formula into a mini-lesson, instead of a formula you copy once and forget. Skip it, and you stay dependent forever, asking for the same thing next month.

For the lookup that has humiliated most people at least once:

I have two sheets. Sheet 1 has an "email" column. Sheet 2 has
"email" and "company name". I want Sheet 1 to pull in the matching
company name from Sheet 2. Give me the exact formula, tell me
which cell to put it in, and warn me about anything that could
break it.

That last line, "warn me about anything that could break it," is the difference between a formula that works on your screen and one that survives your actual messy data.

How Does Claude Clean Up Messy Spreadsheet Data?

You describe the mess in one sentence, and Claude gives you the steps, or the formula, to fix it.

Real spreadsheets are filthy: names typed five different ways, dates in three formats, trailing spaces, duplicate rows, a stray "N/A" that quietly breaks every calculation downstream. Fixing all of that by hand, row by row, used to eat entire afternoons.

• Standardizing names: "This column has client names typed five different ways: 'ACME', 'Acme Inc', 'acme inc.', 'ACME INC', 'Acme Incorporated'. Give me the steps to standardize them all to one clean version, no code, just clicks I can follow."
• Fixing mixed date formats: "Column B has dates in mixed formats: some are '05/03/2026', some are 'March 5 2026', some are just text. Show me how to get every value into one consistent date format so I can sort and filter them."

Ask for "no code, just clicks I can follow" when you want to do it yourself inside Excel. Ask for a formula when you want it automated and repeatable. Inside the add-in, you can tell Claude to clean the column in place and watch it highlight every cell it touched.

Excel punishes messy data. Claude assumes your data is messy, because it always is, and starts from there.

Match the ask to the job: one-time cleanup, ask for clicks. Something you repeat every month, ask for the formula.

How Do You Get Claude to Analyze Your Spreadsheet?

You describe the question in words, and Claude either walks you through a pivot table click by click, or writes the formula that skips it entirely.

I want to see total revenue by client, broken down by quarter.
Walk me through building this as a pivot table, one click at a
time, assuming I have never made one. Then tell me the one
formula I could use instead if I want to skip the pivot table.

The real unlock is letting Claude find the analysis you did not think to ask for. Upload your worst spreadsheet and ask: "What are the 3 most useful things I could pull from this data that I probably haven't thought of?" Let it find the questions you did not know to ask.

I do this with reports before I present them, and it consistently surfaces one angle I would have missed. The failure I keep seeing: people use Claude to confirm the answer they already wanted, instead of letting it challenge them. You get a research assistant only if you actually let it think.

Can Claude Build a Full Financial Model in Excel?

Yes. The add-in does not just write single formulas, it links tabs, runs scenario and sensitivity analysis, and updates one assumption without breaking the twenty formulas that depend on it.

Start small, with a forecast:

Build me a simple 3-year revenue and cash-flow forecast for a
small consulting business. Assumptions: I bill roughly [X] per
month now, growing [Y]% a year, with monthly costs around [Z].
Lay it out month by month, keep the assumptions in their own
cells so I can change them, and explain the structure in plain
English.

Because the assumptions sit in their own cells, changing one number updates the whole forecast. That is the moment it stops feeling like a spreadsheet and starts feeling like a tool.

Then the real thing, a 3-statement model:

Build a 3-statement financial model for a small SaaS company:
income statement, balance sheet, and cash flow, linked so the
three connect properly. Use placeholder assumptions I can edit,
keep drivers on their own tab, and add clear labels so a
non-finance person can follow it. Explain how the three
statements link, one paragraph, no jargon.

Claude keeps the dependency between the income statement, balance sheet, and cash flow intact when you change an input, which used to be the work of people who spent years learning it.

Two features make the models yours:

• Instructions. Set persistent instructions once in the add-in sidebar, like your formatting conventions, and Claude applies them to every conversation in Excel.
• Skills. Type "/" in the sidebar for ready-made moves. Some are Excel-specific, like a cleanup skill; the finance ones can build DCF models and comparable-company analysis on request.

For the harder models, start with Anthropic's "Use Claude for Excel" help page, which lists finance prompts from 3-statement models to DCF to LBO. The Corporate Finance Institute also runs a course on AI financial modeling with Claude and Excel, and there is a free beginner's guide on GitHub that walks through a 3-statement model and DCF.

What Mistakes Should You Avoid When Using Claude in Excel?

Verify one row by hand before you trust the column, because Claude can hand you a confidently wrong formula that looks and sounds right.

This is true of every AI tool, not just this one: fluent is not the same as correct. So the rule takes two minutes.

The rule: AI writes the formula, you verify one row by hand. Pick a row where you already know the answer, do the math yourself, and check that Claude's number matches. If it does not, tell Claude what you expected and why, and it will fix the formula.

A few more failures worth naming:

• Saving before reviewing. The add-in highlights every change it makes. Look at the highlights before you save, every time.
• Shipping unreviewed. Treat Claude's output as a strong first draft, never the signed-off version, especially for a client or a board.
• Trusting a stranger's file. Do not run the add-in on spreadsheets from untrusted sources. Hidden instructions can sit inside cells and comments, and a downloaded template or vendor file can quietly tell Claude to do something you never asked for.

Claude is a truth machine only if you check it. Fluent and confident is not the same as correct, in a spreadsheet or anywhere else.

Prices, plans, and menu paths move fast, so reconfirm the current details on Anthropic's site before you rely on them.

Sources and further reading

• Cowork. - the brisk. guide to letting Claude handle files on your own machine
• Anthropic, "Use Claude for Excel" help page - finance prompts from 3-statement models to DCF and LBO
• Corporate Finance Institute - AI financial modeling course with Claude and Excel

Install the sidebar, open the most annoying spreadsheet you own, find the one formula you have been avoiding for weeks, and describe it in plain English. Then check one row. That is the whole brisk. method for Excel: let Claude do the syntax, you keep the judgment.