In a significant move, Microsoft has unveiled the public preview of Python integration in Excel. This breakthrough feature empowers advanced spreadsheet users to combine the capabilities of the widely-used Python language with their familiar Excel formulas, all within the same workbook.
Bringing Python and Excel Together
The integration of Python in Excel is set to revolutionize data analysis within the Excel environment. Initially available to Microsoft 365 Insiders as part of the Excel for Windows beta channel, this feature heralds a new era of streamlined data processing and analysis.
Seamless Cloud-Powered Calculations
While the Python integration will debut in the desktop version of Excel, Microsoft has taken a unique approach by leveraging the power of the cloud for Python calculations. Despite Python’s compatibility with modern PCs, the calculations will be executed within the Microsoft Cloud infrastructure.
Access Python with Ease
Stefan Kinnestrand, the GM for Modern Work at Microsoft, highlights the accessibility of Python within Excel. With no setup or installation required, users can perform advanced data analysis tasks by directly accessing Python from the Excel ribbon. This seamless integration is facilitated by Excel’s built-in connectors and Power Query.
Collaboration with Anaconda
To bring this groundbreaking feature to life, Microsoft partnered with Anaconda, a prominent data science platform. By utilizing the Anaconda Python distribution running in Azure, Microsoft ensures the incorporation of popular Python libraries, including Matplotlib and Seaborn for enhanced data visualization.
Getting Started
To experience the power of Python in Excel, enthusiasts can join the Microsoft 365 Insider Program and opt for the beta channel to access the latest Excel builds. Initiating the process is as simple as selecting “insert Python” from the Formulas ribbon.
Expanding Possibilities
While various libraries have facilitated Python’s interaction with Excel files and paid add-ons like PyXLL has brought Python’s capabilities to Microsoft’s spreadsheets, the native integration of Python within Excel marks an exciting leap forward.