Somewhere in America, a freelancer is rebuilding the same client dashboard for the fourth time this month. Microsoft just noticed. The October 2026 Copilot Excel update adds five new AI features that turn raw spreadsheets into self-updating dashboards, reusable workflows, and clean datasets — mostly in plain English.
This is the biggest Copilot in Excel upgrade of the year, and it is rolling out right now. Here is what each feature does, when you actually get it, and how to turn it into a productized service.
The 5 new features at a glance
| Feature | What it does | Availability (official) |
|---|---|---|
| Interactive Canvas | Natural-language dashboards that auto-update with your data | Microsoft 365 Insiders |
| Skill Builder | Describe a workflow → Copilot saves it as a reusable skill | General availability, rolling out in October |
| Skill Recorder | Record your actions → Copilot turns them into a reusable skill | Insiders by end of October |
| Get Data | Describe the data you need → structured import into Excel | General availability mid-October, via Excel for the web |
| Clean Data | Finds duplicates and inconsistent formatting automatically | General availability, rolling out in October |
Source: Microsoft’s official availability list. All features are subject to service capacity and usage limits, which Microsoft says may vary over time.
Interactive Canvas: dashboards that update themselves
Ask Copilot for an executive review, a project update, or a status report based on your workbook data. It generates a polished, interactive canvas of key visualizations, metrics, and insights — no chart-building required.
The key difference from a pasted chart: the canvas stays connected to the workbook. When the underlying data changes — edited by hand or pulled in from an external source — the report updates itself. A canvas built at the start of the month still reflects reality weeks later.
Not happy with the first draft? Refine it conversationally: ask Copilot to adjust the layout, highlight different insights, or change how information appears. No rebuilding charts by hand.
Skill Builder and Skill Recorder: teach Copilot once
These two features attack the most annoying part of AI assistance: retyping the same detailed prompt every single month. A skill is a saved set of instructions Copilot reuses whenever you invoke it.
Skill Builder — describe it
Describe a workflow in conversation, provide instructions, share previous prompts, or supply examples of finished work. Copilot converts all of that into a reusable skill you can call up anytime.
Skill Recorder — show it
Can’t explain the workflow? Just do it once. The recorder captures the actions you perform in Excel and turns them into a skill Copilot can execute later. Demonstration beats documentation.
Get Data and Clean Data: the end of manual Power Query pain
Get Data lets you describe the data you need, where it comes from, and how it should be structured — Microsoft’s replacement for hand-building Power Query queries.
Clean Data scans for duplicates, inconsistent formatting, and wrong data types. Microsoft’s example: “USA,” “US,” and “United States” in one column — flagged, with corrections recommended.
| Task | Old way | New way (October 2026) |
|---|---|---|
| Monthly dashboard | Rebuild charts by hand every month | Interactive Canvas auto-updates from the workbook |
| Repeat workflow | Retype the same long prompt monthly | Skill Builder / Recorder saves it once |
| Import data | Hand-build Power Query queries | Get Data from a plain-English description |
| Fix messy data | Hunt duplicates and typos manually | Clean Data flags issues and suggests fixes |
How to profit: productize monthly-report automation
Every small business has a report someone rebuilds by hand each month: marketing spend, sales pipeline, ecommerce P&L, contractor hours. These five features turn that chore into a product you can sell.
- Pick one report type in one niche. Marketing agencies need spend reports; ecommerce sellers need P&L summaries. One template, many clients.
- Build the pipeline once: Get Data pulls the numbers in, Clean Data standardizes them, a recorded skill runs the monthly transform.
- Deliver an Interactive Canvas, not a spreadsheet — a polished dashboard that refreshes itself, with near-zero maintenance.
- Charge a setup fee plus a monthly retainer for monitoring and tweaks. The client pays less than the hours they burned; you collect recurring revenue.
- Reuse the skill templates across clients in the same niche — each new client gets cheaper to serve. That is how a service becomes a product.
Keep Reading
Frequently asked questions
When will I actually get these features?
Skill Builder, Get Data (mid-October, web), and Clean Data roll out to GA during October 2026. Interactive Canvas is in Insiders now; Skill Recorder reaches Insiders by end of October. All subject to capacity and usage limits.
Do I need a special license for Copilot in Excel?
Yes — they build on Copilot in Excel, which needs a qualifying Microsoft 365 Copilot license. Your update channel and environment matter too.
Does Interactive Canvas work on desktop, web, or both?
Desktop and web, with GA completing during October. Get Data’s initial GA arrival is through Excel for the web.
What exactly is a Copilot “skill”?
A reusable set of instructions for a task you repeat — the steps, formatting, and structure Copilot should follow. Build one with Skill Builder (describe it) or Skill Recorder (demonstrate it), then invoke it instead of retyping long prompts.
Does Get Data fully replace Power Query?
Microsoft positions it as the replacement for hand-creating Power Query import queries. Power Query isn’t going away — Get Data is the friendlier front door.
Are there usage limits?
Yes — service capacity and usage limits that may vary over time. Check before promising clients unlimited automation.