Copilot
Copilot in Excel
Copilot in Excel
Get an advanced data analysis using Copilot in Excel with Python
Applies To
Microsoft365.com Microsoft Office

You can conduct advanced analysis without being a Python or Excel expert by using Copilot in Excel with Python. Use natural language to describe the analysis you want to perform, and Copilot will automatically generate, explain, and insert Python code into your Excel spreadsheet.

Notes: 

  • Availability of Python in Excel is required to access this feature. For more details, see Python in Excel availability. Copilot in Excel with Python is available worldwide on Windows and web platforms for enterprise and consumer users in English, Simplified Chinese, French, German, Italian, Japanese, Brazilian Portuguese, and Spanish languages. Excel for Windows must meet the following version requirements:

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

  • Current Channel starting with Version 2409 (Build 16.0.18025.00000).

  • Monthly Enterprise Channel starting with Version 2410 (Build 16.0.18227.00000).

Run advanced analysis 

  1. Open Excel .

  2. Make sure to format your data in a table or supported range.

  3. Navigate to the Home tab, then select the Copilot  small image of the Copilot icon.​button​​​​​​​​​ in the ribbon.

  4. Choose Advanced analysis in the Copilot pane. If you don't see it, select See more.

  5. Select Start to enter advanced analysis mode. When you enter this mode, Copilot creates a new sheet for your analysis and inserts any necessary Python code.

  6. You can ask follow-up questions in your own words, or copy and paste this sample prompt:​​​​​​​

    Icon depicting a document with sparkles

    Get deeper analysis results using Python

  7. Choose the Think deeper button to tackle more complex analysis questions. Think deeper uses reasoning models to create a more comprehensive and structured plan for your analysis.  

    Note: Think deeper is rolling out gradually and may not be available to you yet. We're still exploring the best way to help you get great answers to both simple and complex analysis questions.

  8. When you're done, select Stop advanced analysis in the Copilot pane. This takes Copilot out of the advanced analysis mode so you can use other Copilot skills.

More ways to work with Python in Excel 

Introduction to Python in Excel 

Facebook LinkedIn Email

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center