If you’ve ever felt limited by Microsoft Excel’s data manipulation capabilities, you’re in for a treat. Python can now be used within your spreadsheets, offering a whole new level of functionality. This exciting integration was recently launched as a public preview by Microsoft. The best part? It’s completely native within Excel, making it incredibly easy to use.
To access this feature, you need to be part of the Microsoft 365 Insider program, which allows you to access preview features in Office apps. Once you’re in, you can start typing Python code directly into cells using the new “=PY()” function. The code is then executed in the cloud, and the results are displayed in the worksheet. Imagine the possibilities!
In the examples provided by Microsoft, common actions like creating pivot tables and charts can now be done using Python. Plus, Microsoft’s partnership with Anaconda, a Python repository, enables more advanced visualizations by providing access to popular libraries like Matplotlib, pandas, and scikit-learn.
However, it’s important to note that everything runs in the cloud. You won’t be able to access local installations of Python or any customizations you may have made. This is primarily for security purposes, as Python in Excel is secured through the use of isolated containers. The code runs in a hypervisor in Azure, and online workbooks are opened in separate containers, ensuring the safety of your data.
To get started, you’ll need to be part of the Beta channel for Insiders and running Excel for Windows (build 16.0.16818.20000). While support for Python in Excel on other platforms will be available at a later date, the feature is currently being rolled out gradually. Even Windows users may not have immediate access. Additionally, certain functionality may be gated off for paid license holders, although more details will be announced closer to the official launch.
If you want to experience unrestricted access to Python in Excel during the testing phase, now is the perfect time to try it out. Don’t miss this opportunity to explore the exciting possibilities that this integration brings to data manipulation in Microsoft Excel.
Contents
Can I use Python in Excel without being part of the Microsoft 365 Insider program?
No, you need to be part of the program to access the preview features in Office apps, including Python integration in Excel.
Will I be able to use my custom Python installations and configurations with Python in Excel?
Unfortunately, no. Python in Excel runs in the cloud and doesn’t provide access to local installations or customizations.
Are there any security measures in place for Python in Excel?
Yes, Microsoft has implemented isolated containers and a hypervisor in Azure to ensure the security of Python in Excel. Online workbooks are also opened in separate containers.
When will Python in Excel be available for platforms other than Windows?
Microsoft plans to release support for Python in Excel on other platforms at a later date. Stay tuned for updates.
Will all functionality be available for free, or will there be limitations for paid license holders?
Certain functionality may be gated off for paid license holders. More details will be provided closer to the official launch of Python in Excel.
