Skip to content

Python in Excel for Microsoft 365 Consumers: Available Now

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

Python

Excel gets Python – who, when and why

Python Meets Pixels: Excel Now Analyzes Images Like a Pro

About this author

Office-Watch.com

Office Watch is the independent source of Microsoft Office news, tips and help since 1996. Don't miss our famous free newsletter.