Excel automation has historically been done with VBA, but is Python ready to take up the mantle?

Instead of dealing with complex Excel formulas to perform a specific data transformation, I can use Python scripts to get the job done in no time.

The new Anaconda Python Distribution in Excel, which is currently in beta, will bring Python data analysis and data science capabilities to the popular spreadsheet program from Microsoft. The ...

According to Wang, the ability to use Python in Excel was one of the most requested features from users, who wanted to run the system locally, and not rely on having a connection to Azure. The ...

Explore Excel's latest features for 2025, from AI-powered Copilot to Python integration, and transform your workflows.