Aug 23, 2023 12:10:00

Microsoft announces that it will be possible to use Python in Excel

Microsoft has announced that it will be possible to run Python on the spreadsheet software 'Excel'. Python is already available in beta versions of Excel available through

the Microsoft 365 Insider Program .

Announcing Python in Excel
https://techcommunity.microsoft.com/t5/excel-blog/announcing-python-in-excel-combining-the-power-of-python-and-the/ba-p/3893439

With the newly introduced 'PY' function, you can write Python scripts directly in cells, and the written scripts will be executed on the Microsoft Cloud and the results will be displayed in the sheet. A library for data analysis is already installed in Python running on the server, and a data frame can be created instantly as shown in the figure below.


Graphing libraries such as Matplotlib and seaborn are also installed, so it is possible to create various graphs as shown below.

In addition, it is also possible to use libraries such as

scikit-learn and statsmodels to perform time series modeling and regression analysis predictions, as well as machine learning.

You can also easily perform data cleaning, such as identifying missing values, standardizing formats, removing duplicates, and pattern-based transformations with regular expressions.


The Python code entered in Excel is executed on the cloud, so security is paid full attention, and Python is executed in an isolated container for each Excel file. Also, it is stated that the Python execution environment is safely built with the cooperation of

Anaconda .

Even Excel files that use Python can be co-edited, commented, and mentioned by multiple people as before. Even if Python is introduced into an Excel file with a sensitivity label , it will remain compliant with the organization's information protection policy.

At the time of writing, the Python execution function is available in beta versions of Excel distributed through the Microsoft 365 Insider Program, which anyone with a Microsoft 365 license can participate in. It will be released to the public after further adjustments are made. In addition, it is stated that you would like us to provide feedback through the in-app feedback function, feedback forum , and GitHub repository .