This is the Trace Id: 8986f613d923cfa270cef28e37797fc9
Skip to main content Excel For home For business Data analysis Expense tracking Gantt charts Inventory spreadsheet Python in Excel Spreadsheets Copilot learning center More Microsoft 365 Français Try for free Sign in
Read the announcement.

Python in Excel

Supercharge your data analysis and tell better stories with Python in Excel.
See plans and pricing
A screenshot of a Microsoft Excel window with a spreadsheet containing data charts and a table with product sales information.
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.
    A screenshot of an Excel spreadsheet on a computer monitor with coding software visible in the background.
  • Always have the latest data and run what-if analyses by quickly recalculating your workbook.
    An image of a spreadsheet program with rows and columns, suggesting financial data analysis.
  • Easily share reports with coworkers and refresh them without worrying about dependencies or installing additional tools.
    A stylized screenshot of a user interface with a notification bar indicating a file shared by Amanda Brady.
  • 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.
    A screenshot of a computer interface displaying a bar chart with two bars in different colors, within a data analysis software environment.
PLANS & PRICING

Excel and Python, better together

Learn more

Microsoft 365

Included
See eligible Microsoft 365 plans

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

Python in Excel add-on

CAD $32.52
user/month
(Monthly subscription—auto renews)1
Plus applicable tax
Buy now

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

CAD $325.20
user/year
(Annual subscription—auto renews)1
Plus applicable tax
Buy now

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
 
CUSTOMER STORIES

See what our customers are saying

  1. Logo of McKinney with a stylized red hexagon containing the letter 'M'.
  2. Logo of McGraw Hill on a red background.
Person in a dark sweater working on a laptop in an office setting
Logo of McKinney with a stylized red hexagon containing the letter 'M'.
“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
Three professionals collaborating over a laptop in a modern office setting.
Logo of McGraw Hill on a red background.
“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
Back to CUSTOMER STORIES section
Resources

More from Microsoft 365

  1.
Person working on a computer in an office setting.

Discover what’s happening with Excel

Stay up to date with the latest product announcements and updates in the Excel blog.
Read the blog
Person holding a tablet in an office environment with other individuals working in the background.

Discover other Microsoft 365 apps

Create your best work on all your devices using the tools you need for home and business.
Browse apps
Person working at a desk with two computer monitors, one displaying a login screen and the other showing an email inbox.

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.
Get support
Person using a laptop and holding a mug at a wooden table.