Stop searching for the right Excel formula. Describe what you want and let AI write it.
Here is how to use AI in Excel in one line: tell the AI what your columns hold and what answer you want, then check the result before you rely on it. You can do this inside Excel with Microsoft Copilot if your plan includes it, or for free by asking ChatGPT, Claude or Gemini to write the formula and pasting it into your sheet.
This guide covers both ways, prompts you can copy, how to analyse data with AI, and the checks that stop a wrong number reaching your report.
Chat on WhatsApp and tell me what you do in Excel every week.
Three ways to use Excel with AI
Pick the way that matches your Excel plan and your task. All three work for beginners.
| Way | What it is | Good for | Cost |
|---|---|---|---|
| Copilot in Excel | Microsoft's AI assistant inside Excel | Formulas, charts, PivotTables, sorting and highlighting, done in your sheet | Needs a Microsoft 365 plan that includes Copilot (see below) |
| An AI assistant in a chat window | ChatGPT, Claude or Gemini in your browser | Writing and explaining formulas, cleaning up text, planning a sheet | Free versions exist; check each provider's plans |
| Analyze Data in Excel | A built-in Excel button that suggests charts and summaries | Quick patterns and trends in a tidy table | Included for Microsoft 365 subscribers |
Most people start with the chat window because it's free and works with any version of Excel. If you use Excel every day at work, Copilot saves the copy-paste.
How to use AI in Excel with Copilot
Copilot in Excel works inside your workbook. You type a request in plain English and it can make the change for you.
Check your plan first. Copilot in Excel comes with some Microsoft 365 plans, both home and business. Microsoft changes which plans include Copilot, so check the current list in Microsoft's Copilot in Excel FAQ before you buy anything.
If you don't see Copilot, Microsoft says it may not be included in your subscription or may be turned off by your organisation. Ask your IT admin, or check your Microsoft 365 account.
Then follow these steps:
- Put your data in a clear layout. One header row, one record per row, and clear column names such as "Date", "Product", "City", "Amount".
- Open Copilot. Select the Copilot button in Excel to open the Copilot pane. Microsoft's Get started with Copilot in Excel guide shows where it is in your version.
- Decide what you want back. A change to the sheet, or just an answer. See the table below.
- Name the columns in your request. Microsoft's own tip is to name the columns or ranges you want Copilot to work with (Copilot in Excel tips).
- Review the change. Check a few rows by hand before you share the file.
| What you want | How to ask | Example |
|---|---|---|
| A change to the sheet | Say what to add or change, and where | "Add a column that shows the month from the Date column." |
| A plan before it acts | Ask for the steps first, then say "go ahead" | "List the steps to build a monthly sales summary. Don't change anything yet." |
| An answer only | Ask a question and say not to change the workbook | "Which city had the most orders? Don't change the sheet." |
Copilot's buttons and options move as Microsoft updates Excel. The habit stays the same: say what you want, name the columns, and check the result. Microsoft's Copilot in Excel FAQ lists what works on Windows, Mac, the web and phones today.
Good Copilot requests to try:
- "Add a column that shows the month from the Date column."
- "Highlight rows where Amount is more than 10,000."
- "Create a PivotTable of total Amount by City and Product."
- "Make a line chart of Amount by month."
- "Which three products sold the most last month?"
If a sheet uses an old AI formula. Microsoft has tried out AI features inside Excel formulas, and some preview features have later been removed. If an old sheet shows a #NAME? error where an AI formula used to be, replace it with a normal formula, or ask Copilot in the side pane to do the same job.
How to use AI in Excel for free
You don't need Copilot to get AI help with Excel. A free AI assistant can write the formula; you paste it in. This works in any version of Excel.
- Describe your sheet. Say which column holds what. AI can't see your file unless you upload it.
- Say the answer you want. "The total", "the count", "a Yes or No", "the matching price".
- Ask for the formula and an explanation. The explanation helps you spot mistakes.
- Paste it into one cell and test it. Check it against a few rows you can work out by hand.
- Copy it down only once it's right.
Example. Your sheet has Date in column A, Product in column B, City in column C and Amount in column D. You ask:
Write an Excel formula that totals Amount (column D) where City (column C) is "Pune" and Date (column A) is in October 2026. Explain each part in one line.
A correct answer looks like this:
=SUMIFS(D:D, C:C, "Pune", A:A, ">="&DATE(2026,10,1), A:A, "<="&DATE(2026,10,31))
If the dates in column A are typed as text rather than real dates, the formula returns zero. That's the kind of thing to check, and a good reason to ask for the explanation.
ChatGPT for Excel formulas: prompts you can copy
These prompts work in ChatGPT, Claude or Gemini. Replace the parts in brackets. For more on writing prompts, see my guide on how to use ChatGPT for business.
Write a formula
My Excel sheet has [column letter: what it holds] for each column. Write a formula that [what you want]. Explain it in plain English.
Find a matching value
Column A in Sheet1 has product codes. Sheet2 has codes in column A and prices in column B. Write a formula for Sheet1 that brings in the price for each code, and shows "Not found" if there's no match.
Fix an error
This formula returns [#N/A / #VALUE! / wrong number]: [paste formula]. My data looks like this: [paste 3 rows]. Tell me why and give the fixed formula.
Clean messy text
Column B has customer names in mixed case with extra spaces. Write a formula that makes them Proper Case with single spaces.
Plan a sheet
I run a [type of business]. Suggest the columns for a sheet to track [orders / stock / payments], with one example row and the formulas for the totals.
Explain a sheet you inherited
Explain what this formula does, step by step, as if I'm new to Excel: [paste formula].
AI for Excel data analysis
For questions like "what changed this month?" or "which product is slowing down?", you have three options.
- Analyze Data in Excel. Select a cell in your table, then select Analyze Data on the Home tab. Microsoft says it gives visual summaries, trends and patterns, and you can ask questions in plain language. It's for Microsoft 365 subscribers and works best on a tidy table. Very large data sets may be too big for it (Analyze Data in Excel).
- Copilot in chat-only mode. Ask questions about the workbook without changing it.
- Upload the file to an AI assistant. ChatGPT accepts spreadsheet uploads, including .xlsx and .csv, and can summarise trends and make charts (OpenAI Help: Data analysis with ChatGPT). Claude also reads spreadsheet files; its help page lists which file types it accepts and any setting you need to turn on first (Claude Help Center). If a tool won't take your .xlsx file, save a copy as .csv and upload that.
Prepare your data first. AI reads a tidy table far better than a messy report.
| Do | Avoid |
|---|---|
| One header row with clear names | Two or three header rows |
| One record per row | Subtotal rows mixed into the data |
| Real dates and numbers | Dates typed as text, numbers with words in the cell |
| One table per sheet | Several tables side by side |
| Unmerged cells | Merged cells across the header |
Keep private data out. Before you upload a file to any AI assistant, remove customer phone numbers, bank details, salaries and anything confidential. Use a business plan with admin controls for team work.
Want to see this done live on a real sheet? I run a live AI demo for business owners on Saturdays at 11:00 AM IST (₹999, 10 places). See the next session on AI for business owners.
Check before you trust the answer
The biggest mistake with AI in Excel is trusting the number without checking it. AI is good at writing formulas and spotting patterns. It can still pick the wrong column or misread a date.
| Mistake | Do this instead |
|---|---|
| Copying a formula down without testing | Test it on 3 rows you can check by hand |
| Not saying what each column holds | Name the columns in every request |
| Asking AI to do the maths in the chat | Ask for an Excel formula, so Excel does the maths |
| Uploading the full customer list | Remove personal and confidential columns first |
| Sharing an AI-made chart unchecked | Check the totals against your own SUM |
Ask for the formula and the explanation, every time. The explanation shows you which columns the AI used, so a wrong guess is easy to spot before the number reaches your report.
Which AI is best for Excel?
The best AI for Excel is the one that fits how you work. There's no single winner.
- You use Excel all day and your plan includes Copilot: use Copilot in Excel. It works inside the sheet, so there's no copy-paste.
- You use any version of Excel and want it free: use a free AI assistant (ChatGPT, Claude or Gemini) to write and explain formulas.
- You want quick charts from a tidy table: try Analyze Data first.
- You need to analyse a large export: upload a copy, with private data removed, to an AI assistant that accepts spreadsheets.
Be careful with add-ins and websites that promise "AI for Excel". Before you install one, check who makes it, where your data goes, and whether you can remove it easily.
Excel with AI course: learn it properly
Reading helps you start. Practice on your own sheets makes it stick. If you or your team want to learn AI in Excel on your real work, coaching covers it hands-on, from writing prompts to checking results. If you'd rather get a plan for your business first, book a consulting session.
Read next: AI for Small Businesses: Where to Start: where else AI earns its place in a small business.
Also read: Minutes of meeting format: a free template, and an AI prompt that turns your rough notes into minutes.
FAQ
Is there an AI that works with Excel?
Yes. Microsoft's Copilot works inside Excel if your Microsoft 365 plan includes it. You can also use ChatGPT, Claude or Gemini in a browser to write formulas, and Excel's Analyze Data button suggests charts and summaries for Microsoft 365 subscribers.
How can I use AI in Excel for free?
Ask a free AI assistant such as ChatGPT, Claude or Gemini to write the formula. Tell it what each column holds and what answer you want, then paste the formula into Excel and test it on a few rows. This works with any version of Excel.
Is there a ChatGPT for Excel?
ChatGPT itself isn't built into Excel, but you can use it alongside Excel to write and explain formulas, or upload a spreadsheet for analysis. Microsoft's own AI assistant inside Excel is Copilot.
Can AI make an Excel sheet for me?
Yes. Ask an AI assistant to suggest the columns, an example row and the formulas for a sheet such as orders or stock. Copilot in Excel can add columns, charts and PivotTables to a sheet you already have.
Is it safe to upload my Excel file to AI?
It's safe for most work if you remove personal and confidential data first. Don't upload customer phone numbers, bank details or salaries. For team use, choose a business plan with admin controls.
Start using AI in your next spreadsheet
Pick one task you do in Excel every week. Write one request that names your columns. Check the answer on three rows. That's the habit that makes AI in Excel useful.
I'm Khalil Kothia, an AI Implementation Coach. I've spent 20 years in product, development and automation, and I've trained 10,000+ professionals to use AI in their daily work. See the next Saturday live demo on AI for business owners.
Chat on WhatsApp. I reply within 12 hours.
