Microsoft integrates Python natively into Excel – now in preview

2 min. read

Published onAugust 22, 2023

published onAugust 22, 2023

Share this article

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

Microsoft Excel has announced that it hasintegrated Python directly into its platformby releasing a Public Preview of Python in Excel. This integration enables users to employ Python’s analytical capabilities in Excel. By incorporating Python libraries, data visualization, and analysis can be conveniently executed in Excel. This comes after Microsoft Excelupdated one of the spreadsheet’s oldest featuresearlier this month.

Python in Excel is now natively integrated into the Excel grid. Users can input Python code directly into Excel cells using the new “=PY” function. Excel users can seamlessly use Python alongside formulas, charts, and PivotTables.

Python libraries such aspandas,matplotlib, andscikit-learnprovide a range of analytics capabilities, including data visualization, data cleaning, machine learning, and predictive analytics. This integration grants access to these capabilities via Python.

It leverages the Anaconda Distribution for Python, a widely-used repository for Python libraries. This ensures that users can access various popular Python libraries and tools that Anaconda securely built, tested, and supported.

Anaconda CEO and co-founder Peter Wang said

I am thrilled to announce the integration of Anaconda Distribution for Python into Microsoft Excel – a major breakthrough that will transform the workflow of millions of Excel users around the world.

Moreover, users can share workbooks containing Python code with teammates. Collaboration can occur through familiar tools such as Microsoft Teams and Outlook, and sensitivity labels ensure compliance with information protection policies.

Davesh Beri

User forum

0 messages

Sort by:LatestOldestMost Votes

Comment*

Name*

Email*

Commenting as.Not you?

Save information for future comments

Comment

Davesh Beri

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low#

Copilot in Outlook will generate personalized themes for you to customize the app#

Microsoft will raise the price of its 365 Suite to include AI capabilities#

Death Stranding Director’s Cut is now Xbox X|S at a huge discount#

Outlook will let users create custom account icons so they can tell their accounts apart easier#

Microsoft integrates Python natively into Excel – now in preview#

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low

Copilot in Outlook will generate personalized themes for you to customize the app

Microsoft will raise the price of its 365 Suite to include AI capabilities

Death Stranding Director’s Cut is now Xbox X|S at a huge discount

Outlook will let users create custom account icons so they can tell their accounts apart easier

Microsoft integrates Python natively into Excel – now in preview