490212 – Microsoft Copilot (Microsoft 365): Improved Python-powered answers in Copilot in Excel

Product:

Copilot, Microsoft 365 Apps

Platform:

Web, World tenant

Status:

Launched

Change type:

Links:

Details:

Copilot in Excel now provides improved direct answers to your data analysis questions, using Python.

Change Category:
XXXXXXX ... free basic plan only

Scope:
XXXXXXX ... free basic plan only

Release Phase:
General Availability

Created:
2025-07-02

updated:
2026-01-08

Docu to Check

XXXXXXX ... free basic plan only

MS workload name

XXXXXXX ... free basic plan only

summary for non-techies**

XXXXXXX ... free basic plan only

Direct effects for Operations**

User Experience Degradation
If the integration of Python-powered answers in Copilot is not properly prepared, users may experience confusion or frustration due to unexpected changes in functionality or interface, leading to decreased productivity.
   - roles: Data Analysts, Business Users
   - references: https://www.microsoft.com/en-us/microsoft-365/blog/2023/10/01/introducing-microsoft-copilot-in-excel/, https://www.techradar.com/news/microsoft-copilot-in-excel-what-you-need-to-know

Increased Error Rates
Without adequate preparation, the new Python functionalities may lead to increased error rates in data analysis, as users may not be familiar with the new features or how to utilize them effectively, resulting in incorrect data interpretations.
   - roles: Data Analysts, IT Support
   - references: https://www.microsoft.com/en-us/microsoft-365/blog/2023/10/01/introducing-microsoft-copilot-in-excel/, https://www.zdnet.com/article/microsoft-copilot-in-excel-what-you-need-to-know/

Configutation Options**

XXXXXXX ... paid membership only

explanation for non-techies**

Microsoft has introduced an enhancement to its Copilot feature in Excel, which now leverages Python to provide more precise answers to data analysis questions. To understand this change, think of Excel as a sophisticated calculator that can handle complex data. Traditionally, you might have used Excel's built-in formulas and functions to analyze data, much like using a basic calculator to add or subtract numbers.

With the integration of Python, it's as if Excel has transformed into a powerful scientific calculator capable of handling more intricate calculations and providing deeper insights. Python is a programming language known for its strength in data analysis and manipulation. By incorporating Python, Excel can now perform more advanced data operations, akin to having a data analyst at your fingertips who can quickly process and interpret complex datasets.

For those in the legal, management, or HR fields, this means that Excel can now offer more detailed and accurate insights into data trends, employee performance metrics, or financial forecasts without needing extensive programming knowledge. It's like having a highly skilled assistant who can sift through large amounts of information and present you with clear, actionable insights.

This improvement in Copilot is particularly beneficial for making informed decisions based on data. Just as a GPS provides turn-by-turn directions to reach a destination efficiently, the enhanced Copilot in Excel guides you through your data, helping you navigate complex information and arrive at well-informed conclusions.