Learn more about Python in Excel.
Python in Excel
Supercharge your data analysis and tell better stories with Python in Excel.
Transform your data analytics with Python in Excel
Use Python libraries to clean up, explore and analyze data right within the familiar, secure Excel environment. Developed for both experienced Python users and those just getting started. No need to install anything.
Combine familiar Excel formulas and functions with the custom calculations and plots of Python.
Perform advanced analytics
Seamlessly access best-in-class analytics with Python for visualizations, machine learning, predictive analytics and other functions.
Stay up to date
Always have the latest data and run what-if analysis by quickly recalculating your workbook.
Work together
Collaborate easily with comments and @mentions. Share and refresh reports without worrying about dependencies or installing additional tools.
Get enterprise-level security automatically
Code runs securely, at high scale, within the Microsoft Cloud.
Python in Excel uses Anaconda's secure distribution for Python packages
Anaconda is a leading data science platform and trusted enterprise-grade Python distribution for analytics.
See what our customers are saying
“The ability to run Python in Excel simplifies McKinney's reporting workflows. We used to manipulate data structures, filter, and aggregate data in a Jupyter Notebook, and build visuals in Excel. Now we can manage the entire workflow in Excel. This is going to make Excel that much more powerful and make Python more accessible across the organization. Python support is the most exciting update for Excel in my career!”
—Greg Barnes, Executive Director of Data and Analytics, McKinney
“McGraw Hill’s ethos is education for all, and our partnership with Microsoft has helped improve student access to Excel tools, building career readiness. Python is one of the most in-demand skills we’re hearing from colleges and universities, and we’re thrilled that the Excel and Python pairing will provide educators and students with a powerful new gateway to move faster with analytics, enable greater collaboration and learning, and ultimately bridge students to even brighter futures.”
—Rebecca Olson, Sr. Portfolio Director, McGraw Hill Education
Get started using Python in Excel
Follow Microsoft 365