Use Python when Editing with Copilot in Excel
[Windows, Mac, Web]
Edit with Copilot helps you work with Python in Excel by executing Python code for advanced analysis, automation, and data transformation with results outputted directly in your workbook.
Details:
What changed:
You can now use Edit with Copilot to perform advanced data analysis (statistics, simulations, advanced visualizations etc.) with your workbook data. Existing security and execution controls continue to help manage how code runs.
Why:
Python is widely used for data analysis, visualization, and automation. Bringing Copilot-assisted Python editing into Excel helps users move from intent to working analysis faster without switching tools.
Try this:
Open an Excel workbook with data you want to analyze.
Open Edit with Copilot.
Ask Copilot to complete a task like summarizing trends, cleaning data, or creating a visualization with Python.
Review the output and inspect the results in Excel.
Why this matters:
This makes advanced analysis more approachable by pairing Python’s flexibility with Copilot’s assistance and Excel’s familiar workspace.
Business impact:
Teams can accelerate reporting, analysis, and repeatable data workflows in Excel, helping reduce manual effort and improve consistency.
Personal impact:
You can complete more advanced data tasks in Excel with Copilot’s help.