Microsoft licensing and availability can be, let’s say, a little complicated.
And with a tool like Python in Excel, essentially one tool sitting inside another, it is reasonable to wonder: Do I already have access? Do I need to pay extra? Are there licensing limitations I should know about?
In this post, I want to briefly walk through how Python in Excel availability and licensing work so you can get started without getting tripped up by the logistical details.
Availability
First, do you even have access to Python in Excel?
Python in Excel requires a paid Microsoft 365 subscription that includes the desktop apps. Microsoft keeps the current availability list updated, but for most Business, Enterprise, Family, and Personal users, you probably already have it.
Perpetual versions like Excel 2021, Excel 2024, and Office LTSC are out. So is the free version of Excel for the web.
A couple of enterprise setups can also cause problems: device-based licenses and shared computer activation are not supported, which is worth knowing if you are on a shared workstation or virtual desktop.
Windows and Excel for the web have the broadest support. Mac support came later, and mobile apps can view saved Python results but cannot recalculate them.
One other important detail: Python in Excel runs in the Microsoft Cloud, not on your computer. So it requires an internet connection and Microsoft 365 connected experiences to be enabled. Microsoft has more on that here: Data security and Python in Excel.
What you get out of the box
One nice thing is that the core Python in Excel experience is already included with your Microsoft 365 subscription. You can write Python formulas, use libraries like pandas and Matplotlib, build visualizations, and share workbooks without paying anything extra.
What Microsoft meters, and what you may end up paying extra for, is compute speed. Your subscription includes a monthly allowance of premium compute. Once you use that up, Python keeps working at standard speed until the allowance resets.
I think of it like a phone plan: you use up your high-speed allowance, then get throttled rather than cut off.
The paid Python in Excel add-on, currently $24/user/month or $240/year, gives you more premium compute and also unlocks manual and partial calculation modes. That can be especially useful in larger workbooks where you do not want every edit triggering a Python recalculation.
Microsoft has more purchasing and admin details in the add-on licensing FAQ.
How the premium compute package works
Now for some opacity: Microsoft does not publish the size of the included premium compute allowance or even how it is measured. You just get a warning when you are getting close, then another when you have used it up.
Two limits are documented: a single Python calculation can process up to 100 MB of data, and long-running calculations can hit a timeout that you can adjust in Excel’s calculation settings.
For what it is worth, I have never had a student hit the premium compute ceiling during a class, even in longer sessions. It seems much more likely to matter if you are repeatedly refreshing large Python-heavy models throughout the day.
The one-page version
I put all of this on a single page you can print, keep, or hand to whoever asks you next:
If the licensing question is really a question about how to start using the feature, that is what my Python in Excel Crash Course covers. It runs under an hour and it is about mechanics: the initialization environment, how objects behave so you can reuse them, and the several ways of getting your data into a PY() cell.
