Excel AI in 2026: What Copilot in Excel Actually Does
Excel’s AI is Microsoft 365 Copilot, and in 2026 it is considerably more capable than the “write me a formula” demo most people saw first. It edits the workbook directly, builds PivotTables, and can go to the web for data.
What it still doesn’t do is start on its own. That distinction is the whole of this post.
What Copilot in Excel can do
From Microsoft’s own documentation, Copilot in Excel can:
- Edit worksheets. “Add, rename, and delete worksheets; insert and modify cell values and ranges.”
- Generate data and formulas. “Generate data based on your prompts, perform calculations and apply formulas across multiple sheets.”
- Build visuals. “Create and edit charts, PivotTables, and shapes,” with the output linked back to source data and still editable.
- Analyze. Ask questions about your data and get “insights as charts, PivotTables, summaries, trends, or outliers.”
- Manipulate. Sorting, filtering, conditional formatting and styling.
- Search the web. “Fetch information from the web to ground responses, with citations to the sources used.”
- Import external data from other workbooks or the web.
- Automate repeat work. “Use custom skills to define how Copilot should complete common processes and repeatable tasks.”
Microsoft is careful to note your content stays editable and under your control, which matters more than it sounds when an assistant is rewriting ranges.
That is a strong feature set. If your question is “can Excel’s AI do real spreadsheet work,” the answer is yes.
What the licence costs
Copilot in Excel needs an eligible Microsoft 365 subscription, and Microsoft is blunt that if you don’t see it, “it might not be included with your Microsoft 365 subscription or available based on your organization’s settings.”
For business, the relevant SKU is the Microsoft 365 Copilot add-on at $18.00 per user per month billed yearly, a promotional rate running through September 2026, normally $21.00. It’s an add-on, so it requires a qualifying Microsoft 365 plan underneath it, specifically Business Standard or Business Premium.
Two things worth flagging. Copilot is not one product, and the consumer Microsoft 365 plans include Copilot features in the apps on different terms from the business add-on, so a price you read for one does not apply to the other. And because it’s an add-on, the real per-seat number is the base plan plus $18, not $18.
Where Excel AI stops: nothing starts it
Here’s the structural limit, and it isn’t about capability. Copilot in Excel acts when you open the workbook and ask.
Nothing in Excel watches for the vendor’s file to land in your inbox on the 3rd of the month, opens it, reconciles it against last month’s tab, flags the three rows that moved more than 10%, and emails the summary to your finance lead. Every one of those steps is possible inside Excel. None of them starts by itself.
That’s why “excel automation” is a separate search from “excel ai.” The AI is in the workbook. The automation people actually want is around the workbook: a file arriving, a schedule firing, a threshold crossing, and something happening afterwards without a human opening the app.
Where Carly fits
Carly is a full AI executive assistant, and it covers exactly the part Copilot leaves to you: the trigger, and everything downstream of the spreadsheet.
- It connects to essentially everything. Microsoft Excel is a native connection, alongside around 260 apps across 45+ categories, and anything with a public API connects with your own key on Carly’s integrations. There is effectively nothing in your stack it can’t reach, which is what makes a single workflow able to span mail, file storage and a workbook.
- It reads and writes workbooks directly. Carly can read a OneDrive workbook and append rows to it as part of a run, so the spreadsheet is a step in the automation rather than the destination you open afterwards.
- It triggers on real events. A Carly workflow starts when the email with the attachment arrives, on a schedule, or on a webhook. It can pull the numbers, update the sheet, and send the summary without anyone opening Excel.
- It finishes the job. Carly’s agents run the mailbox, the calendar, the follow-ups and the filing around the workbook, so the report doesn’t stop at “generated.”
- The pricing shape is different. Free Zapier-style workflows; AI agents from $35/month.
- The MCP is free. Point ChatGPT or Claude at
carlyassistant.com/mcpand one conversation reaches your workbooks, your files and your mail together, at no cost.
Copilot in Excel is the better tool for the moment you’re in the spreadsheet. Carly is for the recurring process the spreadsheet sits inside. Most people who want “Excel automation” want the second one and go looking in the first place.
More in best AI assistants for Excel and Google Sheets vs Excel.
FAQ
What is Excel AI? In practice it’s Microsoft 365 Copilot working inside Excel. It edits worksheets, generates data and formulas across sheets, creates and edits charts and PivotTables, analyzes data into summaries and outliers, applies formatting, imports external data, and can ground answers with cited web sources.
How much does Copilot in Excel cost? For business, the Microsoft 365 Copilot add-on is $18.00 per user per month billed yearly on a promotional rate through September 2026, normally $21.00. It sits on top of a qualifying plan such as Business Standard or Business Premium, so budget the base plan plus the add-on.
Can Copilot write Excel formulas for me? Yes. It generates formulas and applies calculations across multiple sheets, and the results stay editable rather than being pasted in as static values.
Can Excel AI run automatically without me opening the file? No. Copilot in Excel responds when you ask it inside the workbook. To have a file arriving or a schedule start the work and finish it end to end, Carly connects Excel natively, reads and appends workbook rows, and runs the trigger.
What is the difference between Excel AI and Excel automation? Excel AI works inside the spreadsheet on request. Excel automation is the recurring process around it: a file lands, numbers get updated, someone gets emailed. Copilot covers the first, and a cross-app assistant like Carly covers the second.
More: Best AI assistants for Excel · Claude for Excel · Google Sheets vs Excel · Excel alternatives
Ready to automate your busywork?
Carly schedules, researches, and briefs you—so you can focus on what matters.
See what people say
"Before Carly, I relied on a Calendly link, but the whole process felt impersonal and not very professional. Carly changed that by handling all the back-and-forth, so I'm no longer stuck in endless email threads trying to line up schedules.
Now Carly reaches out to candidates, shares my real-time availability, lets them pick a slot, then sends a Zoom link and drops it straight into my calendar. She sends reminders to both of us before each call, which has significantly reduced no-shows and last-minute confusion.
On top of scheduling, Carly acts like a full executive assistant, sending me my schedule the night before so I can prepare for each call. It reminds me of the old x.ai assistant, but Carly is noticeably smarter, faster, and better suited to my healthcare recruitment business."
