Microsoft Excel now lets you run Python scripts on images to detect sharpness, edit visuals, and analyze metadata.

With Python scripts, you can even create new Excel workbooks, add or delete worksheets, merge data from different files, and more. Suppose you work in finance and need to combine monthly sales ...

Until now, users had to run Python code on Microsoft Azure’s cloud servers. To provide Python in Excel locally, Anaconda used Microsoft’s existing Excel plugin capabilities combined with their own ...

Some members of the Microsoft 365 Insiders program can now try out the combination of Python, Excel and the Anaconda Python repository.

Microsoft is integrating Python into its Excel app. A public preview is available for Microsoft 365 subscribers now and all the Python code runs on the Microsoft Cloud.

Excel gets containerized, cloud-based Python analytics and visualization powers Visualization and analytics tools available in preview, but may be paywalled.

To share the script so that anyone can run it, click the three dots button and choose Share. This simple how-to is a good place to start, but Office Scripts offers a whole new world of opportunities.

This will enable users to perform complex statistical analysis, advanced visualizations, predictive analytics, and machine learning in Excel.