# Microsoft releases Excel Copilot update with interactive reports and data cleaning tools

> Microsoft has announced an Excel Copilot update featuring new AI tools, including interactive visual reports, workflow automation, and automated data cleaning.

- Canonical URL: https://coreiten.com/en/article/excel-copilot-update-interactive-reports-data-cleaning
- Language: en
- Section: Excel
- Author: Sami
- Published: 2026-10-13T16:02:05+03:00
- Modified: 2026-10-13T16:02:05+03:00
- Publisher: CoreITen (https://coreiten.com)
- Keywords: Excel Copilot, Microsoft, Excel, Skill Builder, Skill Recorder, Get Data, Clean Data, Power Query

## Summary

Microsoft rolled out a new Excel Copilot update featuring interactive visual reports, automated workflow builders, and advanced data cleaning tools.

- Microsoft recently discontinued the specific "COPILOT" function inside cells, but the broader AI integration is expanding.
- A new Skill Builder launching globally in October lets users convert conversational instructions into reusable automated workflows.
- The Clean Data tool rolling out in October can automatically spot formatting issues like inconsistent country names and recommend standardizing them.

**Why it matters:** These updates aim to significantly reduce manual spreadsheet work by integrating natural language automation and smart data preparation directly into Excel.

---

Microsoft has announced a new suite of artificial intelligence features for Excel, focusing on interactive data reports and automated tools for cleaning complex information. According to [Microsoft](https://techcommunity.microsoft.com/blog/excelblog/beyond-analysis-copilot-gets-to-work-in-excel/4517581), while the company recently discontinued the specific "COPILOT" function that allowed users to invoke AI directly within cells, the broader integration of the technology across Excel continues to expand.

### Dynamic reports and canvases

A new interactive canvas feature allows users to transform spreadsheet data into visual reports using natural language commands. Users can ask Copilot to generate executive summaries or status updates based on existing information. The resulting report remains linked to the original data, updating automatically whenever the spreadsheet changes. Users can also request design modifications or highlight different perspectives without needing to rebuild the document. This feature is already available for Microsoft 365 Insiders.

### Automating repetitive workflows

To reduce manual work, Microsoft revealed two new tools: Skill Builder and Skill Recorder. Skill Builder, scheduled for a global launch in October, lets users describe a workflow in conversation by providing examples and instructions, which the AI then converts into a reusable skill. For processes that are difficult to explain via text, Skill Recorder allows users to simply demonstrate the task. The tool records the performed actions and turns them into an automated process. Skill Recorder will reach Insiders by the end of October.

### Data preparation and cleaning

Microsoft has also revamped how information is imported. A new Get Data function replaces the previous query creation method in Power Query. It allows users to describe the data they need, its source, and the desired structure. This feature will be available in mid-October on the web version of Excel.

Alongside the import updates, a new Clean Data tool is designed to automatically identify quality issues, such as duplicate records, inconsistent formatting, and incorrect data types. For example, the system can detect variations like "USA", "US", and "United States" within the same column and recommend standardizing them. The rollout for this tool begins in October.

## Sources

- [videocardz.com](https://tugatech.com.pt/t92586-microsoft-transforma-o-excel-com-relatorios-interativos-e-novas-ferramentas-do-copilot)

## Related topics

- [Power Query](https://coreiten.com/en/topic/power-query)