Python is one of the most popular programming languages today, loved by businesses and students alike and Excel is an essential tool to organize, manipulate and analyze all kinds of data. But, until now, there hasn’t been an easy way to make those two worlds work together.
Today, Microsoft has introduced the Public Preview of Python in Excel – making it possible to integrate Python and Excel analytics within the same Excel grid for uninterrupted workflow.
Python in Excel combines Python’s powerful data analysis and visualization libraries with Excel’s features you know and love. 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.
Now you can do advanced data analysis in the familiar Excel environment by accessing Python directly from the Excel ribbon. 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.
Microsoft is partnering with Anaconda, a leading enterprise grade Python repository used by tens of millions of data practitioners worldwide. Python in Excel leverages Anaconda Distribution for Python running in Azure, which includes the most popular Python libraries such as pandas for data manipulation, statsmodels for advanced statistical modeling, and Matplotlib and seaborn for data visualization.
Share workbooks and Python analytics in your favorite tools like Microsoft Teams and Microsoft Outlook. Collaborate seamlessly with comments and @ mentions, and co-author with colleagues as you normally would in Excel. Teammates can refresh Python in Excel analytics for the most up-to-date information, even if they don’t have Python in Excel activated.
Get enterprise-level security automatically
Protecting your data is our utmost priority so Microsoft has infused security and privacy at the core of the design for Python in Excel. Python in Excel runs on the Microsoft Cloud with enterprise-level security as an M365 connected experience.