Does Excel have an AI program?

The Problem: You Want AI Inside Excel, But the Options Are Confusing

You open Excel, ready to work, and wonder: does this program have AI built in, or do you need to paste your data into ChatGPT? The honest answer is that Excel does have AI — but Microsoft's overlapping branding, a retired function, and a hidden feature make it genuinely hard to know what you're looking at.

The flagship AI is Microsoft Copilot in Excel, an assistant that can build worksheets, suggest formulas, analyze data, and create charts and PivotTables from natural-language requests. It operates in three modes — Edit, Plan, and Chat — and Microsoft notes that "your content stays editable, and you're in control of everything that's modified," according to its official documentation.

Then there's the confusion. A formula-based =COPILOT() function once let you call AI directly inside a cell, but it was retired as of September 14, 2026. Existing workbooks keep cached results, yet any recalculation now returns a #NAME? error, per Microsoft's function reference — so tutorials referencing it are already outdated.

Buried beneath Copilot is a second, lesser-known AI feature: Analyze Data (formerly "Ideas"). It answers plain-language questions about your data and surfaces automatic insights in four classes — Rank, Trend, Outlier, and Majority — though it caps out at 1.5 million cells, according to Microsoft's support page.

Getting this wrong costs real time and money. Before spending anything, sort out which option you're actually dealing with:

• Copilot side pane — the ongoing AI access point, found via the icon in Excel's lower-right corner
• The discontinued =COPILOT function — retired September 14, 2026; ignore tutorials that still use it
• Analyze Data — free with Excel, accessed from the Home tab, but limited to insights rather than edits
• External tools like ChatGPT — powerful, but your data leaves Excel entirely

Cost matters too. Excel's AI requires an eligible Microsoft 365 subscription or Copilot license, and files must be saved to OneDrive or SharePoint with AutoSave on before the Copilot button even appears. Third-party sources conflict on pricing: Coursiv reports Copilot at $30 USD/user/month, while Zapier's comparison lists a Copilot add-on at $252/user/year on top of Microsoft 365 Business Standard — and notes the free Copilot plan doesn't work with Microsoft 365 apps. ChatGPT Plus runs $20/month by contrast.

There's also a trust question. Microsoft itself warns that AI output "should be reviewed and validated for accuracy, especially for critical business decisions or reports," and Windows Central argued that such accuracy warnings "defeat the purpose" of Excel AI for financial reporting. That verify-before-you-trust principle is exactly what SkillzBench applies to AI agent skills — publishing research found roughly 26% of skills carry at least one vulnerability, which is why SkillzBench is building free security scanning and sandbox benchmarking for every skill in its directory.

The sections that follow untangle each option so you can pick the right one first.

The Solution: Excel's Two Built-In AI Features — Copilot and Analyze Data

Yes — Excel actually ships with two AI programs, not one. The flagship is Microsoft Copilot in Excel, an AI assistant that builds and edits workbooks, generates formulas, and answers questions in natural language. The second, older feature is called Analyze Data, and many Excel users have never noticed it.

According to Microsoft's product blog, Copilot helps create worksheets, organize information, suggest formulas, and analyze data — reducing the manual steps in everyday spreadsheet work. It works through Excel's native tools (tables, charts, PivotTables, formulas), and Microsoft's documentation stresses that your content stays editable and you remain in control of everything modified.

Copilot operates in three modes:

• Edit mode (the default) — edits the workbook directly and supports multi-step tasks like applying conditional formatting or data validation
• Plan mode — generates a structured plan for your review before acting on anything
• Chat mode — analyzes data and surfaces insights without changing the workbook at all

After you submit a prompt, Copilot creates a step-by-step plan, executes it, and evaluates whether the result matches your intent. You can watch its reasoning live and stop it at any time.

Its practical capabilities go well beyond chat. Copilot can generate formulas, build charts, PivotTables and dashboards, summarize trends, identify outliers, clean messy datasets (duplicates, inconsistent capitalization), and explain cryptic errors like #NAME? and #REF! in plain language. It can even import data from other workbooks and complete repeatable tasks via custom skills.

Before Copilot, Excel's AI answer was a feature called Analyze Data — formerly known as "Ideas." You access it by selecting a cell in your data range and clicking the Analyze Data button on the Home tab. It accepts plain-language questions and returns insertable visuals: tables, charts, and PivotTables.

It also generates automatic insights in four classes — Rank, Trend, Outlier, and Majority — with no prompting required. The catch is scale: Analyze Data does not support datasets over 1.5 million cells, so very large workbooks fall outside its reach.

Microsoft repeatedly advises reviewing AI output before applying it, especially for critical business decisions or reports. That verify-before-you-trust mindset applies equally to AI agent skills — the reason SkillzBench is building a free directory and MCP connector that security-scan, validate, and benchmark skills before you rely on them.

How to Access Excel's AI: Requirements, Costs, and Platform Availability

Getting Excel's AI up and running isn't automatic — Microsoft gates Copilot behind specific subscription, storage, and formatting requirements. Here's the practical checklist before you click that Copilot icon in the lower-right corner of your spreadsheet.

First, you need an eligible Microsoft 365 subscription or Copilot license. If the Copilot icon is missing from your ribbon, your plan likely doesn't include it. Importantly, the free Copilot plan doesn't work with Microsoft 365 apps at all, according to Zapier's comparison — you'll need a paid tier.

Second, your file setup matters. Microsoft requires files saved to OneDrive or SharePoint with AutoSave enabled before the Copilot button even appears, per the company's Excel product blog. Your data must also be formatted as a table, and only three file types work:

• .xlsx — the standard Excel workbook format
• .xlsb — binary workbooks for large datasets
• .xlsm — macro-enabled workbooks

Older .xls files don't work with Copilot, so legacy spreadsheets need converting first. The older Analyze Data feature has its own constraints too, including no support for datasets over 1.5 million cells, per Microsoft's documentation.

Platform availability varies. Windows, Mac, and Excel for the Web get the full experience — Edit, Plan, and Chat modes. iPad currently supports Chat and Plan (with Edit rolling out), while iPhone and Android are limited to Chat mode only, meaning mobile users can get insights but can't yet have Copilot modify their workbooks.

What about cost? This is where things get murky, because Microsoft's official documentation omits pricing entirely. Third-party sources conflict: Coursiv reports Microsoft 365 Copilot at $30 USD per user per month, while Zapier cites a Copilot add-on at $252 per user per year, stacked on top of Microsoft 365 Business Standard at $150 per user per year. Treat both figures as estimates and confirm current pricing with Microsoft directly before budgeting.

One final note: Microsoft stresses that every AI suggestion "stays available to check first" — human review before trusting output, especially for critical reports. That verify-before-you-trust discipline applies equally to AI agent skills, which is why SkillzBench is building a free, independent directory that security-scans and benchmarks each skill before you equip it.

Verify Before You Trust: Human Review and Extending Excel AI With Agent Skills

Even Microsoft tells you not to blindly trust its own AI. The company's guidance for the =COPILOT function is unambiguous: output "should be reviewed and validated for accuracy, especially for critical business decisions or reports," according to Microsoft's own announcement. That is not a disclaimer buried in fine print — it is the operating principle for Excel AI.

Microsoft builds verification into the product itself. Copilot presents a step-by-step plan before executing it, and "every suggestion stays available to check first," as the company's product blog explains. You can watch the reasoning live, stop it mid-task, and reject anything that misses your intent. Windows Central's Kevin Okemwa went further, arguing that Microsoft's accuracy warnings make the COPILOT function "seem like a trivial feature at best" for financial reporting — a blunt reminder that AI assistance and AI authority are not the same thing.

The same verify-before-you-trust logic applies beyond Excel, to the AI agent skills increasingly used for spreadsheet-adjacent automation. Published research found that roughly 26% of published skills carry at least one vulnerability, and almost nobody has time to audit a SKILL.md file line by line. A skill that cleans your CSV exports or builds your budget tracker deserves the same scrutiny Copilot's output gets.

A practical review workflow for Excel AI looks like this:

• Confirm the data range and table structure Copilot actually used before accepting edits
• Spot-check generated formulas against a manual calculation on a few rows
• Validate any chart, PivotTable, or insight against the source data
• Hold AI output to a higher bar for anything feeding financial reports

This is exactly the problem SkillzBench is built to solve for agent skills. Its free directory is being designed to pin every skill version to a commit SHA, run security scans, license checks, and quality validation, then benchmark each skill in a sandbox — with and without it — to publish the measurable Lift. A free MCP connector, currently in development, will let you equip any agent with only the security-scanned, benchmarked skills you choose.

Verification should not be a chore you perform — it should be infrastructure you rely on. Microsoft made the right call telling Excel users to review before they trust. SkillzBench extends that same discipline to the agent skills automating everything around your spreadsheets, so the trust is earned with evidence rather than assumed.