Copilot in Excel with Python
Applies To
Office for business Microsoft OfficeCopilot in Excel with Python is a tool that leverages the capabilities of AI (artificial intelligence) to get deeper insights from your data and take advantage of Python in Excel without being a Python or Excel expert. To learn more about the capabilities of Copilot in Excel with Python, check out the Microsoft Community Hub blog post.
Try it out
To get started with Copilot in Excel with Python, follow these steps:
-
Open Excel on Windows and load your data.
-
Navigate to the Home tab, then select Copilot.
-
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.
Note: Copilot in Excel is compliant with data protection standards. To learn more, see Data, Privacy, and Security for Microsoft 365 Copilot.
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.
Availability
Copilot in Excel with Python is available worldwide on Windows platform for all enterprise and consumer users in English, Simplified Chinese, French, German, Italian, Japanese, Brazilian Portuguese, and Spanish languages with the following version requirements:
-
Current Channel starting with Version 2409 (Build 16.0.18025.00000)
-
Monthly Enterprise Channel starting with Version 2410 (Build 16.0.18227.00000)
Note: Availability of Python in Excel is required to access this feature. For more details, see Python in Excel availability.
Support for other platforms, and additional languages will be included in future iterations. To learn more, see Microsoft 365 Roadmap.