Python arrives in Excel

Microsoft is adding the Python programming language to Excel. A public preview of this feature is available today, allowing Excel users to manipulate and analyze data using Python.

“You can manipulate and explore data in Excel with Python charts and libraries, and then use Excel’s formulas, charts, and PivotTables to further refine your findings,” explains Stefan Kinnestrand, General Manager of Modern Operations at Microsoft. “Now you can perform advanced data analysis in the familiar Excel environment by accessing Python directly from the Excel menu.”

To access this functionality, you do not need to install additional software or configure a plug-in, since the integration of Python into Excel will be carried out within the built-in Excel and Power Query connectors. Microsoft is also adding a new PY feature that allows you to display Python data in an Excel spreadsheet grid. Through a partnership with Anaconda, the corporate Python repository, popular Python libraries such as pandas, statsmodels and Matplotlib will be available in Excel.

Python calculations are performed in the Microsoft Cloud and the results are returned to an Excel worksheet. Excel users will be able to create formulas, PivotTables, and charts from Python data, as well as connect charting libraries such as Matplotlib and Seaborn to visualize heat maps, plots, and swarm charts.

“I’m thrilled that this excellent and tight integration of Python and Excel has now seen the light of day,” says Guido van Rossum, creator of Python and now a Microsoft engineer. “I expect both communities to find interesting new uses for this collaboration that enhance the capabilities of each partner. When I came to Microsoft three years ago, I never imagined that this was possible.”

Python in Excel is available today as a public preview for Microsoft 365 Insiders on the Beta Channel. At first, it will be available only for Windows, and then, “later”, it will become available for other platforms. Python in Excel will be included in a Microsoft 365 subscription during preview, but “some features will be limited to a paid license” after the preview ends, Microsoft said.