Microsoft has integrated the popular Python programming language into Excel. The new feature is available for testing and no additional software needs to be installed.

“You can manipulate data in Excel using charts and Python libraries, and then use Excel formulas, charts, and pivot tables to further develop your ideas. You can now access Python directly from the Excel ribbon to perform advanced data analysis in the familiar Excel environment. “, said Microsoft representative Stefan Kinnestrand (Stefan Kinnestrand).

Microsoft has announced the integration of a new PY feature into Excel that lets you view Python data in an Excel spreadsheet grid. Thanks to the partnership with Anaconda, Excel will have access to popular libraries such as pandas, statsmodels and Matplotlib.

Microsoft 365 Insiders beta testers can evaluate how Python works in Excel. First, the function will be released in Excel for Windows and then available on other platforms. Python in Excel will be included in the Microsoft 365 trial subscription, but some features will be limited without a paid license.