What Copilot for Excel Does
Microsoft Copilot for Excel is the AI assistant built into Microsoft 365: it turns natural-language requests into formulas, summarizes and analyzes ranges, and works with Python in Excel — all inside the spreadsheet application you already open every day.
In practice that means the usual Excel AI tasks — write a formula, explain this column, spot the outliers, generate a chart — are a prompt away, with answers shown in a sidebar rather than a separate app. For someone who lives in the Microsoft stack, Copilot is the lowest-friction AI available: no add-in to install, no second account, no platform switch.
Its reach extends beyond the cell grid. Because it is attached to your tenant, it can draw on the same data, permissions, and governance as the rest of your Microsoft 365 estate — which matters for teams more than for solo users.
Where Copilot sits against the other brands is covered in the Copilot vs ChatGPT vs Claude comparison; the short version is that Copilot's Agent Mode, generally available since April 2026, is one of the paths by which the cloud brands now execute in the workbook.
How It Runs: M365, Cloud, and Versions
Copilot for Excel runs as a cloud service with a Microsoft 365 subscription underneath. Your workbook data is processed in Microsoft's cloud, which is what enables its scale — and it is also the main thing to weigh before you connect sensitive files.
Version matters more than with most tools. Copilot needs a reasonably current Microsoft 365 build, and Python in Excel — its signature capability for analysts — is gated to specific channels and plans, not available on every subscription. Check your version before expecting the full feature set.
For automation work, Copilot sits alongside rather than inside the VBA world: it can generate the code and even run scripted steps through its automation surface, but it does not replace the macro system for repeatable, versioned processes. The automate Excel without VBA guide walks through the alternatives, including local execution.
Pricing & Plans
| Plan | Price | What's included |
|---|---|---|
| Microsoft 365 Premium | ~$19.99/mo (or ~$200/yr) | Personal/Family (up to 6 people); full in-app Copilot + highest AI usage |
| Microsoft 365 Copilot Business | ~$18/user/mo (promo, list ~$21) | Business (up to 300 users); requires a qualifying Microsoft 365 Business plan |
| Microsoft 365 Copilot (Enterprise) | ~$30/user/mo | Enterprise; requires a qualifying E3/E5 plan |
| Microsoft 365 base | from ~$7–22+/user/mo | The base subscription Copilot layers on — Excel AI needs both |
The headline number for Excel work lands at about $18–32 per user per month on annual billing, on top of a Microsoft 365 plan — so the real cost of Copilot for Excel is the subscription plus the add-on. For individuals, the standalone Copilot Pro is gone — the path is now Microsoft 365 Premium (~$20/mo) — while the business side splits into Copilot Business (promo ~$18, list ~$21) and Enterprise (~$30). Microsoft Copilot pricing publishes the current per-user rates, which vary by region and billing cycle and are checked quarterly — the Business promo currently runs to September 30, 2026.
The M365 dependency is the pricing story most summaries miss: Copilot is not a standalone Excel AI. You are buying an add-on to a plan you may already hold, which makes it cheap if you are already there and expensive if you are starting from nothing.
Is Copilot for Excel Worth It?
- If you already pay for Microsoft 365, Copilot is worth evaluating — the add-on is incremental over a cost you already carry, though it processes your workbook in the cloud.
- If you need formulas only occasionally, a free tool is enough — a subscription for sporadic use is wasted spend.
- If you want the task executed in your file with data staying local, a local agent like Mica is the different choice.
The honest test is whether Copilot changes your workflow or just decorates it. For an analyst already in M365 who wants formula speed and Python access, it can pay for itself quickly. For someone who opens Excel for a weekly report, the same money buys nothing you would notice.
There is also a genuine watch-item: Agent Mode — generally available since April 2026 — is the part to understand. It plans a multi-step operation, asks for your approval through Plan with Copilot, and then runs it in your workbook, modifying formulas, pivot tables, and charts. The execution happens in the cloud within Microsoft 365, and your data is processed there.
Copilot vs Local Execution
The line between 'suggests' and 'executes' has shifted: Agent Mode has Copilot executing multi-step work in your workbook with your approval. The distinction that remains is architectural — Copilot executes in the cloud, with your data processed through Microsoft's services; Mica executes on your machine, with the file never uploaded.
The local alternative flips both variables at once: Mica executes in your workbook and does it on your machine, so there is no file upload, no subscription, and no cloud dependency for your workbook. It is the same category promise — AI that works on your Excel files — delivered with different architecture.
For what cloud processing actually means for your files, the is uploading to AI safe guide breaks down what leaves your machine and what does not.
Mica's local processing documents the local-first alternative in full, including how to verify it yourself.
Frequently Asked Questions
Does Copilot for Excel work without Microsoft 365?
No. Copilot is an add-on to Microsoft 365, so you need a subscription before the Excel AI becomes available.
Does Copilot execute tasks in my workbook?
Yes — Agent Mode, generally available since April 2026, plans multi-step operations and runs them in your workbook with your approval through Plan with Copilot. The execution happens in the cloud, and your data is processed within Microsoft 365.
Is my Excel data uploaded to the cloud with Copilot?
Yes — Copilot processes your data in Microsoft's cloud as part of the Microsoft 365 service.