Can Claude AI write Excel formulas?

Yes, Claude AI is excellent at writing Excel formulas. It handles everything from simple SUM and VLOOKUP to complex nested formulas, dynamic arrays, LAMBDA functions, and array-based calculations. Claude tends to provide clear explanations of how each formula works, making it particularly good for learning.

Is Claude better than ChatGPT for Excel formulas?

Both are strong for Excel formulas. Claude tends to be more precise with complex nested logic and provides better explanations of formula behaviour, and since early 2026 Claude Pro subscribers can also use the official Claude for Excel add-in to work directly inside the workbook. ChatGPT has an edge with Code Interpreter for analysing uploaded files end-to-end. For formula writing, debugging, and in-workbook help on a Pro plan, Claude is often the better choice. For free file-based analysis, ChatGPT may be more practical.

Claude + Excel

How to Use Claude AI to Write Excel Formulas Instantly

By Sagnik Bhattacharya1 Mar 20269 min read

Coding Liquids blog cover featuring Sagnik Bhattacharya for How to Use Claude AI to Write Excel Formulas Instantly, with AI prompt styling, formulas, and spreadsheet visuals.

If you've ever spent 20 minutes trying to get a VLOOKUP to work, or Googled "Excel formula for calculating percentage difference between two columns" only to find answers that don't quite fit — Claude AI can save you hours every week.

I teach Flutter and Excel with AI — explore my courses if you want structured learning.

Claude, built by Anthropic, is particularly strong at understanding what you mean in plain English and translating it into precise Excel formulas. In this guide, I'll show you exactly how to use it — with real examples you can copy and paste straight into your spreadsheets.

Quick note: Anthropic also offers Claude for Excel, an official add-in (Claude Pro, Max, Team, and Enterprise plans) that reads your open workbook directly and writes cited formulas into the cells — no copy-and-paste. This guide covers the free chat workflow; for the add-in, see how to install and use Claude for Excel.

Why Claude Excels at Excel Formulas

Unlike generic search engines, Claude understands context. You can describe your spreadsheet layout, explain what result you want, and Claude will generate the exact formula — accounting for your specific column letters, row numbers, and edge cases.

It understands natural language — you don't need to know the function name to ask for it
It handles nested formulas — complex multi-function formulas that would take you ages to debug
It explains the formula — so you actually learn, not just copy-paste
It remembers context — describe your spreadsheet once, ask multiple questions

Getting Started: Your First Formula Request

The key to getting great formulas from Claude is being specific about your spreadsheet layout. Here's a template that works every time:

"I have an Excel spreadsheet where column A has [data type], column B has [data type], and column C has [data type]. I need a formula in column D that [describes what you want]."

Example 1: Conditional Calculation

Let's say you have a sales spreadsheet with Column A (sales rep name), Column B (region), Column C (sales amount). You want Column D to show a 10% bonus if sales exceed ₹50,000, otherwise 5%. Ask Claude and it gives you:

=IF(C2>50000, C2*0.1, C2*0.05)

Claude will also explain why the formula works, and often suggest improvements like a tiered structure for multiple bonus levels.

Example 2: Multi-Condition Lookup

You need to look up a value based on two criteria. For a deeper dive into lookup functions, see VLOOKUP vs XLOOKUP. Claude will give you:

=INDEX(C:C, MATCH(1, (A:A="Electronics")*(B:B="North"), 0))

Note: Claude will remind you this is an array formula and needs Ctrl+Shift+Enter in older Excel versions.

Example 3: Modern Dynamic-Array Functions

If you're on Microsoft 365 or Excel 2021+, tell Claude your version and it will reach for the newer functions — XLOOKUP, FILTER, and LET and LAMBDA — which are shorter and don't need Ctrl+Shift+Enter.

Ask "look up the price for the ID in A2 from the Products sheet, and return 'Discontinued' if it's missing" and Claude returns a single readable formula:

=XLOOKUP(A2, Products!A:A, Products!C:C, "Discontinued")

For "show every order above ₹10,000 from the North region", Claude reaches for a spill-range FILTER:

=FILTER(Orders, (Orders[Amount]>10000)*(Orders[Region]="North"), "No matches")

And when a formula gets hard to read, ask Claude to refactor it with LET so each step is named:

=LET(net, C2-D2, rate, IF(net>50000, 0.1, 0.05), net*rate)

Advanced Techniques

Technique 1: Paste Your Data

Copy a few rows from your spreadsheet and paste them directly into Claude. This gives it the exact context it needs for accurate formulas.

Technique 2: Ask for Alternatives

After Claude gives you a formula, ask: "Is there a simpler way?" or "Can you do this without an array formula?" Claude will provide 2-3 alternative approaches with trade-offs.

Technique 3: Error Handling

Ask Claude to make your formulas robust. For more on IFERROR, VLOOKUP, and other power functions, see the advanced formulas guide. For example, wrapping a VLOOKUP in error handling:

=IFERROR(VLOOKUP(A2, Sheet2!A:C, 3, FALSE), "Not Found")

Prefer Claude Inside the Workbook?

Everything above works on free Claude by copy-and-paste. If you're on a paid plan, the Claude for Excel add-in reads your whole workbook and writes formulas straight into the cells with clickable citations — no pasting. I cover installation and the full in-workbook workflow in the dedicated guide: how to install and use Claude for Excel.

Real-World Use Cases

What You Need	What to Ask Claude	Formula You Get
Sum values by category	"Sum all values in column C where column A equals 'Sales'"	`=SUMIF(A:A,"Sales",C:C)`
Find duplicates	"Highlight or flag duplicate values in column B" — also see how to clean messy data	`=COUNTIF(B:B,B2)>1`
Date calculations	"Calculate business days between two dates excluding weekends"	`=NETWORKDAYS(A2,B2)`
Text extraction	"Extract the domain name from email addresses in column A"	`=TEXTAFTER(A2,"@")`
Dynamic ranges	"Create a formula that automatically includes new rows"	`=SUM(Table1[Amount])`
Cross-sheet lookups	"Look up a value from Sheet2 based on matching IDs"	`=XLOOKUP(A2,Sheet2!A:A,Sheet2!C:C)`

Common Mistakes to Avoid

Being too vague — Describe your columns and desired output specifically
Not mentioning your Excel version — XLOOKUP only works in Microsoft 365 and Excel 2021+
Forgetting regional settings — If you use semicolons instead of commas as separators, let Claude know
Not testing with edge cases — Always test with blank cells, zero values, and text in numeric columns. When a formula breaks, see using Claude to debug formulas

Wrapping Up

Claude AI isn't just a formula generator — it's like having a patient Excel expert sitting next to you. Start with your most annoying, frequently-used formula and ask Claude to write it for you. You'll be surprised how much time you save.