Learn more about Python in Excel.
Python in Excel
Supercharge your data analysis and tell better stories with Python in Excel.
OVERVIEW
Transform your data analytics with Python in Excel
Use Python libraries—developed for Python users of all experience levels—to clean up, explore, and analyze data within the familiar, secure Excel environment. No need to install anything.
- Seamlessly access best-in-class analytics with Python for visualizations, machine learning, predictive analytics, and other functions.
- Always have the latest data and run what-if analyses by quickly recalculating your workbook.
- Easily share reports with coworkers and refresh them without worrying about dependencies or installing additional tools.
- Have peace of mind knowing that Python in Excel runs code securely, at high scale, within the Microsoft Cloud.
- Anaconda is a leading data science platform and trusted enterprise-grade Python distribution for analytics. Access popular Python libraries provided by Anaconda including pandas, Matplotlib, scikit-learn, and seaborn.
This product is not available in your market.
Python in Excel in Microsoft 365 includes the ability to:
- Write Python formulas directly in the Excel grid
- Calculate Python formulas withstandard compute
- Create advanced visualizations
- Perform complex data analysis
- Access popular Python libraries provided by Anaconda including pandas, Matplotlib, scikit-learn and seaborn
- Calculate Python formulas in automatic calculation mode
- Incorporate enterprise-level security
- Share and refresh reports with coworkers
To use the Python in Excel add-on, you must have an eligible Microsoft 365 subscription2
Includes everything in Python in Excel in Microsoft 365, plus:
- Calculate Python formulas withpremium compute, which means faster calculation times for more powerful data analysis
- Calculate Python formulas in manual, partial, or automatic calculation modes
To use the Python in Excel add-on, you must have an eligible Microsoft 365 subscription2
Includes everything in Python in Excel in Microsoft 365, plus:
- Calculate Python formulas withpremium compute, which means faster calculation times for more powerful data analysis
- Calculate Python formulas in manual, partial, or automatic calculation modes
To use the Python in Excel add-on, you must have an eligible Microsoft 365 subscription2
CUSTOMER STORIES
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
Resources
More from Microsoft 365
Discover what’s happening with Excel
Stay up to date with the latest product announcements and updates in the Excel blog.
Discover other Microsoft 365 apps
Create your best work on all your devices using the tools you need for home and business.
Get support for Microsoft 365 apps
Browse help topics to find the Microsoft 365 support you need, including articles on installation, payment management, and troubleshooting.
Explore Microsoft 365 for individuals
Access apps and cloud storage that help you protect what's important, elevate your content, and make everyday tasks easier.
Explore Microsoft 365 for business
Bring your business ideas to life with the tools you need to create and connect—now supercharged with AI from Microsoft 365 Copilot.
More Microsoft 365
Learn more about Microsoft 365
Microsoft Word
Elevate your writing and create beautiful documents—anywhere, anytime.
Microsoft Excel
Turn data into insights and simplify complex data into easy-to-read spreadsheets.
Microsoft OneNote
Keep your thoughts, content, and lists handy in one place.
Microsoft Outlook
Manage your email, calendar, tasks, and contacts in one location.
Microsoft Defender
Simplify your online security.
Microsoft OneDrive
Keep your files and memories protected, up to date, and easily accessible across all your devices.
Microsoft Designer
Create designs and edit photos in seconds with the power of AI.
Teams
Bring everyone together in one place to meet, chat, call, and collaborate.
Next steps
Get started with Microsoft 365
Improve productivity at home or in your business with Microsoft 365.
Microsoft Copilot
Check out Microsoft 365 Copilot
Get more done faster with an AI assistant in your Microsoft 365 apps, documents, and meetings.
Free trial
Try Microsoft 365 for individuals
Enjoy the apps, security, and storage you need to accomplish your goals—now free for one month.
Free trial
Try Microsoft 365 for business
Create, connect, and collaborate on web, desktop, and mobile apps to keep your business growing—try Microsoft 365 Business Standard for free for one month.
- [1]Within the Microsoft 365 admin center, global and billing administrators can choose either annual or monthly commitment plans.
- [2]To purchase, customers must have a qualifying plan for enterprise or business and have access to Excel for Windows.Learn more about the prerequisites for Python in Excel.
