Python with Edit with Copilot in Excel

Edit with Copilot in Excel can execute Python code against workbook data for advanced analysis, automation and data transformation, with results output directly into the workbook.

Recorded characteristics

Function

Allows a user to instruct Edit with Copilot in Excel to perform advanced analysis using Python, including statistics, simulations, advanced visualisations, automation and data transformation. Python results are output directly into the workbook.

Data access

The capability operates on data in the currently open Excel workbook. Access to other files, email or enterprise data is not established by the recorded evidence.

Actions

Can take actions

External actions

Unknown

Human confirmation

Not established

Permission basis

Not established

Administrative control

Existing Microsoft security and execution controls govern how Python code runs. Additional controls are not inferred beyond Microsoft documentation.

Default state

Not established

Availability

Microsoft documents the Python capability for Edit with Copilot in Excel on Windows, Mac and Web. Availability remains subject to applicable Copilot/Excel licensing and rollout.

Licensing

Use the applicable licensing information from Microsoft Edit with Copilot documentation. Licensing is not inferred beyond Microsoft documentation.

External model or provider

Not publicly established as a single model provider. Microsoft documents model selection within Edit with Copilot, including Microsoft-provided/default model selection and supported OpenAI and Anthropic models depending on eligibility and configuration.

Limitations and uncertainty

Only limitations directly supported by the evidence are recorded. The capability operates within the currently open workbook; this record does not generalise to other Microsoft 365 Copilot capabilities. The permission basis and external-action capability were not established from the public evidence reviewed.

Evidence

• Release Notes for Microsoft 365 Copilot

  Supports: Function · Data access · Actions · Availability · Admin controls · Primary source

  Release notes document Python execution for advanced analysis in Edit with Copilot in Excel.

  Release notes describe Python analysis operating on workbook data.

  Release notes describe Python code execution with results output into the workbook.

  Release notes record availability of the Python capability across Excel platforms.

  Release notes reference existing Microsoft security and execution controls governing Python code execution.

• Edit with Copilot in Excel

  Supports: Function · Data access · Licensing · External model · General · Primary source

  Support documentation describes Edit with Copilot in Excel capabilities including advanced analysis.

  Support documentation describes editing and analysis within the open workbook.

  Support documentation sets out applicable Copilot/Excel licensing for Edit with Copilot in Excel.

  Support documentation describes model selection within Edit with Copilot, including Microsoft-provided default selection and supported OpenAI and Anthropic models depending on eligibility and configuration.

  Support documentation provides the broader capability context for Edit with Copilot in Excel.