Trace Id is missing
Skip to main content
Microsoft 365

Learn more about Python in Excel. 

Read the announcement.

Python in Excel

Supercharge your data analysis and tell better stories with Python in Excel.

Python in Excel in desktop screen

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.

Combine familiar Excel formulas and functions with the custom calculations and plots of Python.

Anaconda graph within mobile phone

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. Access popular Python libraries provided by Anaconda including pandas, Matplotlib, scikit-learn, and seaborn.

See what our customers are saying

McKinney logo
“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 logo
“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

Excel and Python, better together

Microsoft 365

Originally starting from Included now starting from Included

Included Included

  • Python in Excel in Microsoft 365 includes the ability to:  

  • Write Python formulas directly in the Excel grid

  • Calculate Python formulas with standard 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

  • 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

Python in Excel add-on

Originally starting from $24.00 now starting from $24.00

$24.00 $24.00

user/month

(Monthly subscription—auto-renews)1

  • Includes everything in Python in Excel in Microsoft 365, plus: 

  • Calculate Python formulas with premium 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

Python in Excel add-on

Originally starting from $240.00 now starting from $240.00

$240.00 $240.00

user/year

(Annual subscription—auto-renews)1

  • Includes everything in Python in Excel in Microsoft 365, plus:

  • Calculate Python formulas with premium 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

Get started using Python in Excel

Follow Excel

Excel blog

Learn more about Excel

  • [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.

Follow Microsoft 365