Excel AI: Copilot, Claude and free tools compared

In brief

Copilot is the AI built into Excel, and Microsoft 365 Premium, at $19.99 a month, is one plan that carries it. Free options exist: GPTExcel gives 50 credits a month with an account, and ChatGPT lists a free Excel add-in with limited use, as of November 2026. Check every formula.

What prompt gets a good result from Excel AI?

Paste this into Copilot, ChatGPT, Claude, Gemini or Whizi and fill the brackets. It gives the model the layout it can't see in a plain chat.

A frosted glass calculator and a stack of white sheets on a black plinth, with a green spreadsheet grid card standing behind them and a small terracotta Claude starburst beside a rainbow glass Gemini star, in a dark charcoal studio.

My sheet has these columns: [A: order date, B: customer, C: amount, and so on]. Here are two sample rows: [paste]. I want [the result, such as total amount per customer per month]. Put it in [cell or new tab]. Use [Excel 365 functions or any Excel version]. Write one formula, explain each argument in a line, and name one input that would make it return a wrong value.

Each bracket closes a gap. The sample rows show the data types, so a date stored as text doesn't slip past. The version line decides whether you get XLOOKUP and FILTER or the older INDEX and MATCH. The last sentence makes the model point to its own weak spot.

Does Excel have AI built in?

Yes. Microsoft's AI in Excel is Copilot, and it only appears if your plan includes it. Microsoft's FAQ lists four routes in: a Microsoft 365 Personal or Family plan with an AI credits plan, Microsoft 365 Premium, a commercial Microsoft Copilot subscription, or a business or enterprise plan that is eligible for Copilot Chat. Microsoft's plan page lists Premium at $19.99 a month as of November 2026. For enterprise users it can also depend on how the organization's tenant is set up.

Microsoft's getting started page says you open it from the Copilot icon in the lower right corner of Excel. It lists what it can do: edit worksheets, write formulas, create and edit charts and PivotTables, sort and filter, fetch web information with citations, and import data from other workbooks.

It has three modes. Allow editing changes the workbook directly and is the default. Plan proposes a plan for you to review first. Chat only answers questions without touching the file. Windows, Mac and the web support all three. iPad and iPhone chat and plan, with edit rolling out, and Android is chat only, as of 21 November 2026.

Two more facts from the FAQ matter. Copilot editing only works when Calculation Options are set to Automatic. And a file checked out in SharePoint, where your organization requires check out, won't work in Copilot on Windows or Mac, though Excel on the web still opens it.

The model changes by plan. Microsoft says Copilot in Excel supports Claude models from Anthropic and GPT models from OpenAI for editing. Switching between them needs a commercial Copilot subscription or Microsoft 365 Premium, and the choice resets when you close Excel.

Is there a free Excel AI?

Yes, but each free option has a catch. The table lists what each tool's own page states as of November 2026. A cell that says not stated means the page was silent.

ToolFree useSign upPaid priceWhere it runsBest at
Copilot in ExcelNo free tier statedMicrosoft account and an eligible planPremium $19.99 a month; AI credits plan price for Personal ($9.99) and Family ($12.99) not statedInside ExcelEditing your open workbook
GPTExcel50 credits a month, 5 tool runs a day freeYesPlus $19 a month, Pro $39 a monthA web appFormulas, pivots, slide decks
JuliusA daily credit allowance, amount not statedNot statedPlus $20 a month, Pro $45 a monthA web appCharts and analysis on uploads
ChatGPT for ExcelLimited usage on FreeA ChatGPT accountGo $8, Plus $20 a monthInside ExcelFormulas in your sheet
Claude for ExcelNone: Pro, Max, Team and Enterprise onlyA Claude paid planPro $20 a month, or $17 on annual billingInside ExcelTracing errors, cell citations
Whizi10 messages a day on Whizi AI, Auto and Claude Haiku, no cardAccount neededPro $29.99 a monthA chat in your browserComparing Claude, GPT and Gemini on one sheet

Whizi loses in two places. It has no Excel add-in, so it can't sit beside your open workbook the way Copilot does. And GPTExcel is a dedicated spreadsheet tool with pivot table and slide deck builders that Whizi doesn't have. Julius states a daily allowance but not its size, so no free comparison with it is possible.

The GPTExcel row comes from its own pricing page, which lists 50 credits a month and five free tool runs a day, with files up to 5 MB on the free plan. It doesn't say whether a card is needed. Julius's pricing page says its free plan "comes with a daily credit allowance" and gives no number. Microsoft's plan comparison page lists Personal at $9.99, Family at $12.99 and Premium at $19.99 a month and gives no price for an AI credits add-on. For the other two rows, see ChatGPT for Excel and Anthropic's Claude for Excel page, which says it is generally available to Pro, Max, Team and Enterprise.

If you pay for none of these, the cheapest working route is a chat app. Upload the sheet, ask for the formula, and paste it back.

Can AI write Excel formulas?

Yes, and formulas are the job AI does most reliably in a spreadsheet. Fill the brackets and send any of these. In a chat app, add two sample rows so the model sees your layout.

  1. Lookup: "Column A holds product codes and sheet [Prices] holds code in A and price in B. Write a formula for C2 that returns the price, and shows [not listed] when the code is missing."
  1. Totals by condition: "Sum column D where column B equals [Region] and column A falls in [month]. Explain each argument."
  1. Split text: "Column A holds names like 'Smith, Ana'. Give me formulas that put the first name in B and the last name in C."
  1. Clean dates: "Column A has dates typed as text in three formats: [examples]. Write a formula that returns real dates and flags any it can't read."
  1. Fix an error: "Cell [E12] shows #N/A. This is the formula: [paste]. Say which part fails and propose a fix. Don't change anything yet."
  1. Replace a nested IF: "Rewrite this nested IF as a lookup a new teammate could read: [paste]."
  1. Find duplicates: "List every duplicate customer in column A, ignoring case and trailing spaces, and show the count first."
  1. Explain a formula: "Explain this formula in plain words and name one input that would break it: [paste]."
  1. Build a summary tab: "Make a Summary tab with total and average per [category], using live formulas that point at the Data tab."
  1. Plan first: "Before editing, outline exactly which tabs and ranges you would change, then wait for my go."
  1. Speed: "This workbook is slow. Find formulas that scan whole columns or call volatile functions and suggest a cheaper version of each: [paste]."
  1. Sanity check: "Here are my totals: [paste]. Give three quick checks that would reveal a double count or a missing row."

What do real Excel AI jobs look like?

Three jobs people bring most are a messy export, a monthly summary and a broken formula. These are the prompt and what a good answer must contain. They are examples written for this page, not tested output from any named model.

1. A messy export. Prompt: "Column A holds customer names typed three ways: 'ACME Inc', 'Acme, Inc.' and 'acme inc'. Give me a formula that returns one clean name per row, then tell me how to count distinct customers." A good answer builds the cleaning with TRIM, PROPER or UPPER, removes the punctuation with SUBSTITUTE, and counts the distinct names with a function your Excel version has. It should say that the count is only as good as the cleaning. See cleaning up a spreadsheet with AI for the long version.

2. A monthly summary. Prompt: "Sheet Data has date in A, region in B and revenue in C, about 4,000 rows. Make a Summary tab with revenue per region per month, live formulas, and a total row that matches the sheet's grand total." A good answer uses SUMIFS or a PivotTable, anchors the ranges so new rows count, and ends with a check cell that compares the summary total with the data total.

3. A broken formula. Prompt: "This formula returns #VALUE! for some rows: [paste]. Rows 14 and 91 fail. Here are those rows: [paste]. Find the cause." A good answer names the cell content that breaks the formula, such as a number stored as text or a stray space, gives a fix that handles it, and says what to look for in other rows.

How does the file round trip work with a chat AI?

You attach the workbook to a chat, ask for a change or an analysis, and get a new .xlsx back to download. That works without any add-in, and it works on any plan that lets you upload a spreadsheet. The trade is that the AI sees a copy, so nothing changes in your open workbook until you open the returned file.

Prepare the sheet first. Put clear column names in the first row, keep one record per row, and avoid several unrelated tables on one tab. Then say which tab the answer should land on and what to leave alone. OpenAI's file upload page says ChatGPT takes XLSX, XLS, CSV, TSV and ODS files, with spreadsheets capped near 50 MB.

Check the file that comes back. Open it, press Ctrl and the backtick key to show formulas, and confirm the totals are live formulas rather than typed numbers. If the AI pasted values, ask again: "Use formulas, not values."

For a deeper look at getting a finished file out of a chat, read AI that can create Excel files. For analysis rather than editing, the best AI for data analysis compares tools.

What mistakes ruin Excel AI results?

Four mistakes cause most bad results, and each has a plain fix.

  1. Letting it edit your only copy. The fix: duplicate the workbook first. Microsoft's FAQ says that once you save Copilot changes, anyone with access to the file can see them.
  2. Leaving Calculation on Manual. The fix: set it to Automatic, since Copilot editing only works then.
  3. Describing the goal but not the columns. The fix: list the columns and paste two sample rows, as in the first prompt.
  4. Trusting a total you never checked. The fix: recalculate one total by hand and add a check cell that compares the summary with the data.

A fifth catches people with macros. Anthropic's page lists macros and VBA operations as unsupported in Claude for Excel, and OpenAI's help page says VBA and macros may not be fully supported in ChatGPT for Excel. Test a copy of any workbook that depends on them.

Where does Whizi fit as an Excel AI?

Whizi is one app instead of a pile of single purpose tools, and it works in a chat, not inside Excel. You attach an .xlsx, ask your question, and ask for an Excel file back. Excel and Word files made in chat have no plan gate, so a free account can make one inside its daily messages. Whizi reads old .xls files only after you re-save them as .xlsx.

The free plan gives 10 messages a day on Whizi AI, Auto and Claude Haiku, with no card. Pro carries Claude, GPT and Gemini in one app, and its first week is $1.99. That lets you have one model write a formula and a second model from another lab check it. Side by side Compare, which runs two models on one prompt, is a Pro and Powerhouse feature. See Whizi pricing for what each plan holds.

If your company already pays for Copilot, use Copilot for edits inside the live workbook. Whizi earns its place for the jobs that start in a chat.

What can Excel AI not do?

It can't promise a correct number, and it can't see what you didn't give it. A model that writes a plausible formula against the wrong column still returns a plausible answer. Claude's own page says not to use it for audit critical calculations without verification, for final client deliverables without human review, or for regulated data without proper controls.

It also can't replace an accountant for a tax return or an audit. Treat its output as a draft, review the changed cells, and keep the original file.

Workflow checklist
  • Duplicate the workbook before any AI edits it
  • List the columns and paste two sample rows in every formula prompt
  • Ask for a plan first on any large edit
  • Set Calculation Options to Automatic before using Copilot editing
  • Recalculate one total by hand and add a check cell
  • Test macros on a copy, since several add-ins skip VBA
Common questions

Frequently asked questions

Is there a free AI for Excel?

Yes. GPTExcel lists a free plan with 50 credits a month and an account, and ChatGPT lists limited free use of its Excel add-in, as of November 2026. Copilot in Excel needs an eligible Microsoft plan, and Claude for Excel needs a paid Claude plan.

Does Copilot in Excel cost extra?

It needs an eligible plan, which can mean paying more. Microsoft lists a Personal or Family plan with an AI credits plan, Microsoft 365 Premium, a commercial Copilot subscription or an eligible work plan. Microsoft lists Premium at $19.99 a month, Personal at $9.99 and Family at $12.99, as of November 2026, and states no price for the AI credits plan. Check Microsoft's plan page for that amount.

Can AI read an Excel file I upload?

Yes. ChatGPT, Claude, Gemini and Whizi take .xlsx uploads, and OpenAI says ChatGPT accepts XLSX, XLS, CSV, TSV and ODS up to about 50 MB. Put clear headers in row one, say which tab to use, and check the returned file's formulas.

Can Excel AI run macros?

Not reliably. Anthropic lists macros and VBA operations as unsupported in Claude for Excel, and OpenAI says VBA and macros may not be fully supported in its add-in. Test a copy of any macro workbook first.