A dataframe named “DF1” is created via cell reference, using the new Excel function with an auto-generated headers parameter. The code can be outputted as a Python object or an Excel value.

It is as simple as typing =PY into an Excel cell. This single action unlocks a whole new world of data manipulation. Within the Python in Excel ... the pandas library to read in that messy data ...

(You can read more about Microsoft’s data security practices regarding Python in this support documentation.) To get started, you must be part of the Beta channel for Insiders, and running Excel ...

With Python in Excel, users will be able to type Python code directly into an Excel cell. The Python calculations will run on Microsoft’s cloud servers and be delivered back to the Excel sheet.