Copilot in Excel with Python

Try it out 

To get started with Copilot in Excel​​​​​​​​​​​​​​ with Python, follow these steps: 

1. Open Excel on Windows and load your data.

2. Navigate to the Home tab, then select Copilot.

3. Select the Advanced analysis card in the task pane that opens.  ​​​​​​​

Alternatively, in the task pane you can use prompts like: 

• "Analyze this data using Python" 

• "Run advanced analysis using Python"

4. Select Start advanced analysis to enter advanced analysis mode. Once in this mode, a new sheet is created for your analysis and Copilot inserts any Python code needed for your analysis. You can ask follow-up questions, request explanations, or use the suggested prompts that appear above the chat input. 

5. To exit advanced analysis mode, select Stop advanced analysis. This takes Copilot out of the advanced analysis mode and back to its regular mode for other Copilot skills. 

​​​​​​​

Limited availability  

Copilot in Excel with Python is currently available in limited capacity.

For enterprise users, it's available only on Windows, in the United States, Australia, and the United Kingdom, in the Current Channel or Monthly Enterprise Channel, and in the English language starting with Version 2409 (Build 16.0.18025.00000).

For consumer users, it's available only on Windows, in the United States, Australia, and the United Kingdom, and in the English language starting with Version 2409 (Build 16.0.18025.00000).

Support for other platforms, global regions, and additional languages will be included in future iterations. To learn more, see Microsoft 365 Roadmap. 

See also 

Introduction to Python in Excel