Microsoft Brings Python Integration to Excel—Here's What to Expect

John Lopez, Tech Times 22 August 2023, 01:08 pm

Microsoft has launched an interesting new feature that combines Python programming with Excel spreadsheets. This is great news for data enthusiasts and analysts.

The Verge reports that this newest integration, termed "Python in Excel," has been introduced as a public preview, allowing users to seamlessly harness the power of Python scripts within Excel.

How the New Feature Works

Stefan Kinnestrand, the General Manager of Modern Work at Microsoft, explains that "You can manipulate and explore data in Excel using Python plots and libraries, and then use Excel's formulas, charts, and PivotTables to further refine your insights."

A standout feature of this integration is its accessibility. Unlike traditional add-ons or plugins, Python in Excel does not demand any additional software installations. It is natively integrated into Excel's ecosystem, and accessible through the Excel ribbon.

This direct access simplifies the process for users who may not have extensive technical expertise, enabling them to perform advanced data analysis using Python's capabilities without the steep learning curve.

Made for Data Analysts

Notably, Microsoft has collaborated with Anaconda, a renowned data science platform, to infuse Python in Excel with a rich selection of popular Python libraries. This includes heavyweights like pandas, statsmodels, and Matplotlib, which are essential tools for data manipulation, statistical analysis, and data visualization.

By offering these libraries, Microsoft aims to empower Excel users to delve into complex data operations, further expanding the utility of the software.

One intriguing aspect is the decision to execute Python calculations in the Microsoft Cloud. While Python's computational capabilities are well-suited to run on modern PCs, Microsoft has opted for cloud-based execution. This approach ensures efficient processing and prevents local machine limitations from hindering the potential of Python's computational might.

User Experience

Guido van Rossum, Python's creator and now a Microsoft distinguished engineer, expressed his enthusiasm for the collaboration, stating, "I expect that both communities will find interesting new uses in this collaboration, amplifying each partner's abilities."

As for the user experience, Microsoft has seamlessly integrated Python with Excel's features. Users can manipulate and explore data using Python libraries, then refine insights with Excel's powerful formulas, charts, and PivotTables.

The integration even extends to data visualization, with the inclusion of charting libraries like Matplotlib and Seaborn for creating intricate visual representations of data, from heatmaps to violin plots.

Take Note

TechCrunch tells us that the Python in Excel feature is set to make its debut as a public preview exclusively for Microsoft 365 Insiders in the Beta Channel. While it is currently limited to the Windows version of Excel, Microsoft has plans to expand its availability to other platforms in the future.

During the preview phase, Python in Excel will be available as part of the Microsoft 365 subscription. However, it is important to note that certain functionalities might be restricted without a paid license after the preview period concludes.

Stay posted here at Tech Times.