Excel Canvas offers to turn your workbook into the boss's next report

Microsoft is set to introduce Excel Canvas, a feature that will convert spreadsheet data into professional reports, including visualizations, metrics, and insights, starting in October. According to the company, these reports will automatically update as the original data changes. Users must have access to Copilot in Excel and can modify the reports using natural language commands.

This development aligns with Microsoft's ongoing efforts to revamp Excel. Last week, the company unveiled an optional feature enabling multiple values in a single cell, which may complicate compatibility with third-party tools that traditionally require one value per cell. Previous attempts to incorporate Copilot into Excel have faced criticism or been discontinued.

For instance, a Copilot Dynamic Action Button was abruptly added to users' workspaces earlier this year, causing widespread dissatisfaction. Microsoft responded by allowing users to relocate the button to the toolbar. Additionally, the company discontinued the COPILOT() function just 12 months after its introduction, citing the need for users to verify the accuracy of the output, especially when it pertains to business decisions or reports.

While automatic report generation could streamline work processes, users will need to ensure Copilot is selecting the appropriate metrics and charts. Excel Canvas also enters a competitive arena, as businesses already utilizing dashboard tools may require a compelling reason to adopt another solution.