Microsoft CopilotfeaturePython in Edit with Copilot for Excel
Copilot in Excel can now write and run Python against your workbook data, with results landing back in the sheet.
Details
- Edit with Copilot executes Python code against your workbook and writes the output directly into Excel, so there is no export and re-import step
- Covers advanced analysis, automation, and data transformation, including statistics, simulations, and visualizations
- The existing security and execution controls for Python in Excel still govern how the code runs
- Available on Windows, Mac, and Web
Best for
Analysis that outgrows formulas: statistics, simulations, data cleaning, and charts Excel cannot build on its own.
When to use it
You know what analysis you want but not the Python to get there, and you do not want to leave the workbook.
Who benefits
Analysts and marketers who live in Excel and have been exporting to a notebook to do the harder work.
Join the newsletter to get ahead with AI.
I share strategies, new modules, free guides, and tools to get you better at using AI in your work.
Leading a team? See team programs →