Is there AI in Excel now?

Excel's AI Confusion: Three Interfaces, One Clear Answer

Yes — AI is now built directly into Microsoft Excel, delivered through Microsoft 365 Copilot. According to Microsoft's own product page, it speeds up spreadsheet tasks like adding columns and formulas, formatting tables, and surfacing insights from your data.

But if you've been following the news, you've probably heard about three different things called "Copilot in Excel." Untangling them matters, because one of them is going away.

Three interfaces, one Copilot

The first and oldest is the Copilot side pane — a chat window that opens from the Excel ribbon, where you ask questions and request changes in plain language. The second is the experimental =COPILOT formula, which put large language models directly into the calculation engine. The third is the newest: an "agentic" mode, labeled "Edit with Copilot," that can take multi-step actions directly in your workbook.

The formula route is the one to stop investing in. Microsoft has announced that starting September 14, 2026, the =COPILOT function will no longer be available, with the side pane supporting many of the same AI-powered tasks, per the Microsoft 365 Insider Blog. The function also came with tight rate limits — 100 calls per 10 minutes, up to 300 per hour — which made bulk work impractical anyway.

The agentic mode, by contrast, is where Excel's AI is heading. As of April 2026, agentic capabilities in Excel are generally available, meaning Copilot can explore data, build analysis, and make changes across formulas, tables, and visuals. Microsoft attributes the leap to model improvements in instruction following and reasoning — and emphasizes that control remains with the user, who can review and keep or discard every change.

So which interface should you learn?

• The Copilot side pane — the durable, default interface going forward
• Agent Mode ("Edit with Copilot") — multi-step, in-workbook actions, now generally available
• The =COPILOT formula — experimental, rate-limited, and retiring September 14, 2026

If you're building AI workflows around Excel rather than just inside it, agent skills can automate the surrounding steps — SkillzBench is building a free directory where you can browse, security-scan, and benchmark skills before loading them via its free MCP connector. For in-spreadsheet work, though, the side pane is the answer: it's the one interface Microsoft is explicitly positioning as permanent.

How to Actually Enable AI in Excel: The Checklist

Enabling AI in Excel is less about flipping a switch and more about clearing four specific gates: licensing, file location, data formatting, and access. Miss any one of them and the Copilot button simply won't do what you expect.

Step 1: Check your subscription. Copilot Chat is included in eligible Microsoft 365 business and enterprise plans, but the full experience — including priority access and model choice — requires the Microsoft 365 Copilot add-on at $30/user/month, or Microsoft 365 Premium for individuals, according to a vendor comparison of Excel AI tools. Note that this pricing figure comes from a third-party source rather than Microsoft's official licensing documentation, so verify current pricing against Microsoft's own pages before budgeting. The agentic capabilities that let Copilot make multi-step edits directly in your workbook are the default experience for Copilot subscribers and are also available to Personal and Family plans via Microsoft365.com/copilot or the mobile app, per Microsoft's Copilot blog.

Step 2: Move your files to the cloud. Copilot in Excel only works with files saved to OneDrive or SharePoint, as a training guide on Excel's AI features explains. If your workbook lives on a local desktop or a network drive, Copilot can't touch it — copy it to OneDrive first.

Step 3: Format your data as an Excel Table. This is the requirement most people trip over. Copilot doesn't read loose ranges of cells well; select your data and insert a Table so the AI understands your structure.

Step 4: Open Copilot from the ribbon. Click the Copilot button in the Excel ribbon to open the side chat pane, then start asking questions or requesting edits.

A few practical notes as you set this up:

• If you were using the experimental =COPILOT formula function, know that it retires on September 14, 2026, and the side pane is the durable interface going forward.
• Analyze Data, the license-free insights feature, works only on datasets of 1.5 million cells or fewer.
• Microsoft's own guidance is blunt: "Copilot is not a replacement for human judgment. Always review and validate the content it generates."

For workflows that go beyond a single spreadsheet — bulk processing across thousands of rows, where Copilot struggles — agent skills can automate the surrounding tasks. SkillzBench is building a free directory of security-scanned, benchmarked agent skills plus a free MCP connector, so you can browse and test them alongside your Excel setup.

AI Without a Copilot License: Free Features Already in Excel

You don't need a $30/user/month Copilot license to get AI-assisted help in Excel. Long before Copilot arrived, Microsoft shipped a set of intelligent features that quietly do pattern recognition, forecasting, and data enrichment inside every standard install.

Start with Flash Fill (Ctrl + E), which detects patterns in your typing and fills the rest of the column automatically. Type "John Smith" as "Smith, John" once or twice, hit Ctrl + E, and Excel infers the transformation across your data — no formulas required. It's the lowest-friction AI feature in the product, and it's been there for years.

• Analyze Data (formerly "Ideas") — ask natural-language questions about a table and get charts, pivot suggestions, and trends; it works on datasets of 1.5 million cells or fewer.
• Power Query — automates messy data cleanup and reshaping, learning your transformation steps so they replay on refreshed data.
• Forecast Sheet — projects future values from historical time-series data using built-in statistical models.
• Geography and Stocks Data Types — type a country, city, or ticker, and Excel pulls in live, linked reference data.

These features matter more than you might think given current adoption trends. A Gallup survey of 22,000+ U.S. workers found only about 12% of employed adults use AI daily, while roughly 6.1 million workers — disproportionately older women in clerical roles — may struggle with AI adoption. Features like Flash Fill offer a gentle on-ramp: no chat pane, no prompt-writing skills, no license conversation.

For small businesses watching budget, that matters. Gusto's research across 400,000+ small businesses found AI adopters seeing up to 20% productivity gains, but the barrier is often getting comfortable with the tools at all. Per training-provider ONLC's inventory, these built-in features deliver AI-assisted value without any additional spend.

One caveat: even Microsoft notes AI outputs should be reviewed, as they "can occasionally be inaccurate" — a habit worth building now. And once you outgrow the spreadsheet itself, agent skills can automate the surrounding workflow; SkillzBench is building a free directory with security scanning, benchmarking, and an MCP connector so you can test which ones actually help.

Honest Limitations and the Third-Party Alternatives

For all the genuine progress Copilot represents, pretending it's flawless would do readers a disservice. The honest picture matters more than the marketing one.

Start with what Microsoft itself says. The company's own guidance is blunt: "Copilot is not a replacement for human judgment. Always review and validate the content it generates, as it can occasionally be inaccurate" (per ONLC's feature inventory). Even the agentic capabilities that reached general availability in April 2026 come framed around review and control — Microsoft's Sumit Chauhan emphasizes that "control is non-negotiable" and users must be able to review changes (Microsoft Copilot Blog).

Then there's scale. A vendor comparison notes that Copilot cannot reliably apply prompts across thousands of rows — it excels at conversational, whole-workbook assistance rather than bulk transformation. Even the older Analyze Data feature caps out at 1.5 million cells (Microsoft Learn, via ONLC). For heavy repetitive work, the built-in tools hit walls.

That's where third-party add-ins come in:

• Claude for Excel — Anthropic's official add-in, out of beta in 2026; reads multi-tab workbooks and includes cell-level citations.
• ChatGPT for Excel & Sheets — generally available since May 5, 2026, and works on every ChatGPT plan including Free.
• GPT for Work — built for bulk processing, handling up to 1 million rows in Excel at roughly 1,000 rows per minute, from $25/month.

One caveat deserves its own paragraph: nearly every head-to-head number you'll see online comes from a vendor with skin in the game. One July 2026 benchmark comparing add-ins across 20 finance tasks was published by a company selling a competing tool — the source itself flags it as a vendor claim, not a neutral test. Treat such figures as directional at best.

The same skepticism applies to Microsoft's side. Its Copilot materials cite "increased engagement, retention, and satisfaction" without publishing actual figures. Neither camp's benchmarks settle the question; independent testing does — which is exactly the gap SkillzBench is building toward, with sandboxed, same-model benchmarking of agent tools and skills, plus security scanning (published research found roughly 26% of agent skills carry at least one vulnerability).

The practical takeaway: use Copilot for exploration, analysis, and edits you can eyeball. For bulk row-by-row work, test the add-ins — and validate every output against the source data, whoever generated it.

Beyond the Grid: Automating the Workflow Around Excel

Even with agentic Copilot now generally available in Excel, there's a hard boundary to where it works: inside the workbook. AI can't reliably process thousands of rows in bulk, and Microsoft's own guidance reminds users that Copilot is not a replacement for human judgment — outputs should always be reviewed and validated.

That matters because real spreadsheet work rarely stops at the grid. The most time-consuming parts of any reporting workflow happen around Excel: cleaning raw exports, reconciling figures across files, generating recurring reports, and double-checking the numbers before anyone else sees them. These are repetitive, multi-step tasks — exactly the kind of work that in-spreadsheet AI assistants weren't built to handle at scale.

This is where AI agent skills come in. Agent skills are instruction packages that extend coding agents and chat-app agents (Claude Code, Codex, Cursor, Gemini CLI and more) to perform defined tasks — things like data prep, report generation, and validation steps that feed into or pull from your spreadsheets. Instead of asking Copilot to do one more thing inside the file, an agent handles the surrounding workflow end to end.

But there's a catch worth taking seriously. Published research found that roughly 26% of agent skills carry at least one vulnerability — so grabbing skills at random from the internet introduces real risk into your workflow. Verification matters.

That's the problem SkillzBench is being built to solve. Currently in pre-launch, SkillzBench is a free, independent directory of AI agent skills that will:

• Continuously discover and dedupe skills from sources like GitHub
• Security-scan every skill, license-check it, and pin each version to a commit SHA
• Benchmark skills in a sandbox — with and without the skill — and publish the performance lift in percentage points
• Ship a free MCP connector so any agent can use only the skills you've chosen
• Track upstream changes, re-scan and re-benchmark, and notify you when something shifts

Every skill gets a trust score from 0-100 based on security, quality, license, maintenance and community signals — with performance lift always shown separately, and money never touching the scores. The directory, the MCP connector, benchmarks and alerts will all be free.

So the answer to "is there AI in Excel now?" is a genuine yes — Copilot handles the in-grid work, from formulas to visuals. For everything beyond the grid, verified agent skills are the natural next step. If that resonates, you can join the SkillzBench waitlist to be notified when the directory and free MCP connector go live.