Trace Id is missing
Skip to main content
Microsoft 365
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 with Python in Excel.
    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

$24.00
user/month
(Monthly subscription—auto renews)1
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

$240.00
user/year
(Annual subscription—auto renews)1
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.

Explore Microsoft 365 for home

Access apps and cloud storage that help you protect what's important, elevate your content, and make everyday tasks easier.
Learn more
Person working on a computer with code on the screen.

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.
Learn more
Back to Resources section
More Microsoft 365

Learn more about Microsoft 365

Explore all apps
Microsoft Word application icon.
Microsoft Word

Elevate your writing and create beautiful documents—anywhere, anytime.

Learn more
Icon representing Microsoft Excel with a green 'X' on a pair of overlapping green rectangles.
Microsoft Excel

Turn data into insights with free and premium spreadsheets.

Learn more
Logo of Microsoft OneNote with a purple 'N' on a square background next to a stylized notebook design.
Microsoft OneNote

Keep your thoughts, content, and lists handy in one place.

Learn more
Logo of Microsoft Outlook featuring an envelope with the letter 'O' on a blue square background.
Microsoft Outlook

Manage your email, calendar, tasks, and contacts in one location.

Learn more
Blue shield icon with gradient effect.
Microsoft Defender

Simplify your online security.

Learn more
Stylized blue cloud icon with a flat design and subtle shading.
Microsoft OneDrive

Keep your files and memories protected, up to date, and easily accessible across all your devices.

Learn more
Abstract graphic with overlapping shapes in gradient colors of orange, pink, and blue.
Microsoft Designer

Create designs and edit photos in seconds with the power of AI.

Learn more
Logo of Microsoft Teams consisting of a letter 'T' on a purple background with abstract shapes.
Teams

Bring everyone together in one place to meet, chat, call, and collaborate.

Learn more
Back to MORE MICROSOFT 365 section
Two individuals in a business setting, one holding a tablet and the other gesturing with their hand.
Next steps

Get started with Microsoft 365

Improve productivity at home or in your business with Microsoft 365.
See plans and pricing
Abstract representation of digital media elements and interfaces floating against a pastel background.
Microsoft Copilot

Check out Microsoft 365 Copilot

Get more done faster with an AI assistant in your Microsoft 365 apps, documents, and meetings.
Learn more
Person in a green sweater working on a laptop in a room with natural light.
Free trial

Try Microsoft 365 for home

Enjoy the apps, security, and storage you need to accomplish your goals­—now free for one month.
Learn more
Two professionals in a discussion, one holding a digital tablet, in a bright office setting.
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.
Learn more
  1. [1]
    Within the Microsoft 365 admin center, global and billing administrators can choose either annual or monthly commitment plans.
  2. [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