How to Use AI for Excel Formulas (Free)

To use AI for Excel, describe your data and what you want in plain English — for example, “I have regions in column A and sales in column B; give me a formula that totals sales for each region.” AI returns a working formula you paste straight into a cell.

How it works

You describe the layout and the goal; AI writes the formula. It’s especially useful for the formulas people forget the syntax of — SUMIFS, VLOOKUP, XLOOKUP, IF nests, and date maths.

Free with ChatGPT, Claude, or Gemini. You don’t need a paid Excel add-in.

Step by step (ChatGPT)

1. Open ChatGPT and start a new chat.

2. Describe your columns and what you want:

   I have a sheet with Region in column A, Product in column B, and Sales in column C, with headers in row 1 and data from row 2 to 500. Give me a formula that totals Sales for the “North” region.

3. Paste the formula it gives you into a cell.

4. If it errors, paste the error message back — that’s usually enough for it to fix it.

Give it real details: sheet names, row ranges, and whether numbers might be stored as text.

Prompts that work well

The last one is underrated: paste an existing formula and ask it to explain — you learn while you work.

Always verify the formula

AI is confident and occasionally wrong. Before you trust a result:

1. Check the ranges match your actual sheet.
2. Spot-check manually — filter the data and compare a total or two.
3. Look for absolute references ($A$2) — AI sometimes adds them when you didn’t want them, which breaks fill-down.
4. Ask for an explanation, then confirm it matches what you expected.

Never paste a formula into a sheet you can’t afford to be wrong about without checking it.

Built-in AI in Excel

Microsoft’s Copilot can write formulas inside Excel, but it needs a paid plan — Microsoft 365 Personal/Family with AI credits, Microsoft 365 Premium, or a commercial Microsoft 365 Copilot subscription. For most people, a free ChatGPT or Claude tab alongside Excel achieves the same result.

Once a formula works, the rest is presentation — see how to make a graph in Excel and how to freeze a row so your headers stay visible.

Want the wider picture of what AI can do for you? See the best AI tools or start with how to use AI.

FAQ

Can AI write Excel formulas for me?

Yes. Describe your columns and the goal in plain English to ChatGPT, Claude, or Gemini and it returns a formula you paste into a cell.

Is there a free AI for Excel formulas?

Yes — ChatGPT, Claude, and Gemini all have free tiers that handle formula writing well. No add-in needed.

Is AI-generated Excel formulas accurate?

Usually, but not always. Always check the ranges and spot-check the result before relying on it.

Which is better for Excel, ChatGPT or Copilot?

Copilot works inside Excel but needs a paid subscription. A free ChatGPT tab is enough for most formula writing — see how to use ChatGPT.

Can AI explain an Excel formula I already have?

Yes — paste the formula and ask what it does. It’s a fast way to learn. For specific functions, see how to use SUMIF and how to use VLOOKUP.