Python power in Excel 365 is getting closer to full public release. It’s now available for Microsoft 365 Current Channel (Preview), the last step before going out to all users.
Python in Excel is possibly the most important improvement to Excel for a long time. All the power of Python libraries and code samples can be included in Excel worksheets.
At a stroke, Excel gets much better charting, data normalization and data analysis functions.
Requirements
As usual, Microsoft is boasting about the availability of a feature while ‘forgetting’ to mention the vital requirements.
Python in Excel is only available in Microsoft 365 for Windows. No mention of Excel for Mac or Web.
You need a Microsoft 365 Business or Enterprise licence – not Microsoft 365 consumer plans (Family or Personal).
Do I have Python in Excel?
Update your Microsoft 365 to ensure you have the latest release
Then see if Excel 365 has the PY() function which is the gateway to Python services.
Two Important Differences to Know about the Python Excel Trial Release
Excel gets Python – who, when and why
Great guide to harnessing Python in Excel
Get Python in Google Sheets
