Microsoft is introducing the widely used programming language Python to its Excel software. This development, known as Python in Excel, is now being rolled out as a public preview specifically for Microsoft 365 Insiders in the Beta Channel. Initially, this feature will be accessible only on Windows systems, with plans to extend availability to other platforms in the future.
This functionality is designed to be user-friendly, eliminating the need for additional software installations or add-ons. Python integration will seamlessly integrate into Excel through its built-in connectors and Power Query.
A new function called “PY” is also being introduced, allowing Python data to be integrated into the Excel spreadsheet grid. This integration is facilitated by partnering with Anaconda, a prominent enterprise Python repository, thereby enabling access to popular Python libraries like pandas, statsmodels, and Matplotlib directly within Excel.
Image source: Microsoft
Given the widespread use of both Excel and Python in enterprise settings, many data science teams already rely on Python scripts to analyze data within their spreadsheets. Previously, these scripts required a separate code editor for writing and execution, causing data scientists to frequently switch between tabs.
With the integration of Python support directly into Excel, this workflow is set to become significantly smoother. According to Microsoft, users can seamlessly incorporate Python code into a spreadsheet without leaving the Excel interface. This is achieved by selecting a cell within the spreadsheet, entering code with the prefix “=py,” and defining the specific data on which the code should operate.
Python in Excel operates within the Microsoft Cloud, delivering enterprise-grade security through an integrated M365 experience. Teams using Excel can collaborate easily by sharing workbooks and Python analytics through platforms like Microsoft Teams and Outlook. Team members can refresh Python analytics for up-to-date data, even without activating Python in Excel.
During the preview phase, Microsoft confirms that Python in Excel will be included as part of a Microsoft 365 subscription. However, certain functionalities may be subject to limitations without a paid license following the conclusion of the preview period.
Featured image credits: Image by rawpixel.com on Freepik
Read next: Microsoft announces the winners of Microsoft Security Excellence Awards 2023
