Microsoft has begun rolling out Python in Excel—the powerful integration that allows users to write Python formulas directly inside Excel—to Microsoft 365 Family and Personal subscribers.
That’s great news because Python adds a lot to Excel, making available a lot of features that previously Excel users could only dream about.
What’s Available Now (Preview)
For consumer licenses (Personal or Family), Python in Excel is rolling out first to the preview or Insiders.
- Excel 365 for Windows (Current Channel): Family and Personal users running v2405 build 17628.20164 or later can access Python in Excel for Beta testers (Insiders).
- Excel for Mac (Current Channel): Family and Personal users running v2405 build 17628.20164 or later can access Python in Excel for Beta testers (Insiders). v16.95 build 25021921
- Excel for the Web: Available in preview for Family and Personal users.
If you don’t have the Insiders builds, it’ll only be a matter of time before the PY() function will become available.
What’s Already Generally Available
- Enterprise and Business subscribers with the Current Channel on Windows from v2408 build 17928.20114 and Monthly Enterprise Channel from v2408 build 17928.20216 can use Python in Excel with standard compute, without needing an add-on.
- Education subscribers can access Python in Excel via the Insider Program, selecting Current Channel (Preview) or Beta Channel, beginning with builds starting v2406 build 17726.20016 on Windows and v16.95 build 25021921) on Mac.
What’s Included
Python in Excel lets Family and Personal users:
- Author Python formulas directly inside the Excel grid
- But it’s much better to use the Python Editor add-on
- Use core open-source Python libraries (e.g., pandas, Matplotlib, seaborn, NumPy, statsmodels)
- Create visualizations and conduct robust data analysis, all within Excel
- See Excel gets Python – who, when and why for examples of what it can do.