Python in Excel

Question

Where do I find Python in Excel? I want to use it for QR code.

Answer 1

Hi @Michele Black,

You can access Python directly within Excel by going to the Formulas tab and selecting Insert Python. Another quick way is to simply type =PY( into a cell, which will activate Python functionality right away.

I recommend reviewing the following documentation to better understand which platforms support this feature based on your subscription: Python in Excel availability - Microsoft Support 

Note: Python in Excel is currently not supported on mobile platforms, including Excel on iPad, iPhone, and Android devices

You may also find this article helpful: Get started with Python in Excel - Microsoft Support

Thank you very much for your time.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.  

Answer 2

Python in Excel is built into Excel for Microsoft 365 (Windows, Mac, and web) and runs in the Microsoft cloud. It is not available on Excel for iPad, iPhone, or Android.

To find and enable Python in Excel on Windows desktop:

1. Open Excel and create a blank workbook.
2. On the ribbon, go to Formulas.
3. Select Insert Python.
   • Alternatively, click in a cell, type =PY, and choose PY from the AutoComplete list.

Once Python is enabled, Python formulas can be used in cells to run Python code, including code that uses the built-in qrcode library (provided via Anaconda) to generate QR codes as images.

Note that Python in Excel requires an internet connection because calculations run in the Microsoft cloud.

---

References:

• Introduction to Python in Excel
• Open-source libraries and Python in Excel