Copilot will automatically insert Python code into your Excel spreadsheet at your command

The Python capabilities in Excel, released earlier this year (including a Python Editor within the platform) will be enhanced capabilities, as Microsoft announced Copilot in Excel with Python.

In a blog post, the Redmond-based tech giant says Copilot in Excel with Python is now in public preview. However, according to the latest entry in the Microsoft 365 Roadmap, it will start rolling out to users in November 2024.

With it, users will be able to use natural language to describe the actions they want to perform, and Copilot will automatically generate, explain, and insert Python code into the Excel spreadsheet.

Microsoft says the integration also unlocks powerful Python tools for visualizations, data cleaning, machine learning, and predictive analytics.

We’re announcing Copilot in Excel with Python, combining the power of Python—one of the world’s most popular programming languages for working with data—with Copilot in Excel. Now, anyone can work with Copilot to conduct advanced analysis like forecasting, risk analysis, machine learning, and visualizing complex data—all using natural language, no coding required. It’s like adding a skilled data analyst to the team. Copilot in Excel with Python is in public preview.

This has been a huge week for Copilot. On Monday, the Redmond-based tech giant announced Copilot Pages and Copilot agents, two new AI tools that can help companies thrive and enhance productivity worldwide.