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

Microsoft is set to release Excel Canvas later this year, a feature that will convert workbook data into polished reports complete with visualizations, metrics, and insights. According to Microsoft, these reports will automatically update as the data they are based on changes. To create these reports, users will need access to Copilot in Excel and can further refine them using natural language prompts.

This move is part of Microsoft's ongoing efforts to enhance Excel's capabilities. Recently, the company introduced an opt-in feature that allows multiple values in a single cell, which could complicate matters for third-party tools that are designed to expect only one value per cell. In the past, some of Microsoft's Copilot additions have faced resistance or been removed from Excel.

For instance, a Copilot Dynamic Action Button was abruptly added to users' workspaces earlier this year, prompting widespread criticism. In response, Microsoft provided users with the option to remove the feature from their workspaces.

Moreover, Microsoft withdrew the COPILOT() function in August 2021, just 12 months after its introduction. The company cited the need for users to verify the accuracy of the function's output, especially when it was being used for business decisions or reports. This decision was met with skepticism, given that the spreadsheet is often used to inform financial accounts.

Although Excel Canvas enters a competitive market, as businesses already rely on dashboard tools for data visualization, these automated reports could save users time. The effectiveness of these reports will depend on Copilot's ability to identify relevant metrics and charts.