READ THIS: Do You Have Python in Excel?

⚠️ Do You Actually Have Python in Excel?

Microsoft has not rolled this feature out to everyone. Take 10 seconds to check before you start.

The 10-second test:

Open Excel → click any empty cell → type: =PY(

  • "PY" pops up in the list → You're good.
  • Nothing pops up → Keep reading.

You need a PAID Microsoft 365 subscription to use this feature.

✅ What works: Microsoft 365 Personal, Family, Business (Basic / Standard / Premium), and work or school plans

❌ What DOESN’T work (no workaround currently exists):

  • Office 2019, 2021, or 2024 (the one-time purchase versions)
  • Free Excel on the web
  • Excel on iPad, iPhone, or Android

Where it runs: Windows, Mac, and Excel on the web - with an internet connection. Your code runs on Microsoft's servers, so there is no offline mode.

You have a paid plan, but =PY( still doesn't appear? Try in this order:

  1. Update Excel: File → Account → Update Options → Update Now. Restart Excel.
  2. Check that you're signed in with the subscription account: File → Account.
  3. Turn on connected experiences: File → Account → Manage Settings → enable the option for experiences that analyze your content. (This one fixes it surprisingly often.)
  4. Work or school laptop? Your IT admin may have switched it off; ask them.

Ignore the "premium compute" upsell.

Python in Excel is already included in your subscription at no extra cost.

Excel may show a message about a monthly premium-compute limit and a paid add-on (about $24/month). You do not need it for this section. If you hit the limit, calculations just run slower; nothing actually stops working.

Two limits to know up front:

  • No pip install. You get a fixed library set - pandas, NumPy, Matplotlib, seaborn, statsmodels, scikit-learn, SciPy and more - loaded with normal import statements.
  • No offline work. Being connected to the internet is absolutely required to use this feature.

Microsoft still labels this "preview" on Personal, Family, and Education plans. It works the same; the label just means Microsoft is still changing things. If something here doesn't match what you see, this note is newer than the course videos; trust this note.