Microsoft is bringing Python to Excel


Share post:

Microsoft today announced the public preview of Python in Excel, which will allow advanced spreadsheet users to combine scripts in the popular Python language and their usual Excel formulas in the same workbook.

This feature will first roll out to Microsoft 365 Insiders as part of the Excel for Windows beta channel. Yet while the feature will first only be available in the desktop version of Excel, Microsoft notes that the Python calculations will run in the Microsoft Cloud. Python runs perfectly well on any modern PC, so I’m not sure why Microsoft went the cloud route here.

“Now you can do advanced data analysis in the familiar Excel environment by accessing Python directly from the Excel ribbon,” Stefan Kinnestrand, the GM for Modern Work at Microsoft, explains. “No set up or installation is required. Using Excel’s built-in connectors and Power Query, you can easily bring external data into Python in Excel workflows.”

Image Credits: Microsoft

Microsoft partnered with data science platform Anaconda to bring this feature to life. The company is using the Anaconda Python distribution — running in Azure — to bring the most popular Python libraries to Excel, including the likes of Matplotlib and seaborn for data visualization.

To try this out, you’ll have to join the Microsoft 365 Insider Program and opt for the beta channel to get the latest Excel builds. From there, it’s just a question of selecting “insert Python” in the Formulas ribbon to get started.

It’s worth noting that there have long been libraries that allowed Python users to work with Excel files, as well as (paid) Excel add-ons like PyXLL that bring Python’s functionality to Microsoft’s spreadsheets, too.

Source link


Please enter your comment!
Please enter your name here

Related articles

Defense startup Mach Industries closes $79M Series A at $335M valuation

Defense tech darling Mach Industries has closed a $79 million Series A led by Bedrock Capital in...

Google’s Pixel 8 brings new camera tricks, better display and a thermometer

When it comes to hardware releases, Google zigs where the competition zags. Leaks are a virtual inevitability...

Google’s Pixel Watch 2 brings new sensors for improved health tracking

After years of rumors and reports, Google finally released its first smartwatch last year. It was a...

Pixel 8 Pro’s upgraded camera system offers dream specs for mobile photographers

Google made its Pixel 8 smartphone lineup official today, including the Pixel 8 Pro. This year, the...