Microsoft is bringing popular programming language Python to Excel. A public preview of the feature is available today, allowing Excel users to manipulate and analyze data from Python.
You won’t need to install any additional software or set up an add-on to access the functionality, as Python integration in Excel will be part of Excel’s built-in connectors and Power Query. Microsoft is also adding a new PY function that allows Python data to be exposed within the grid of an Excel spreadsheet. Through a partnership with Anaconda, an enterprise Python repository, popular Python libraries like pandas, statsmodels, and Matplotlib will be available in Excel.
Python calculations run in the Microsoft Cloud,
Ah shit, so close.
I truly wonder why. I mean, others just package a python installation, but Microsoft wants to use the cloud. Very peculiar.
Running in the cloud is another reason to keep paying them every month in perpetuity, rather than just once. Helps keep revenues stable and indefinite.
It also allows them to completely gate the feature via tiers, like they do with other things in their environment. I’ve written about Power Platform since it is a pretty accessible tool for a lot of people. But it is also a shining example of Microsoft’s almost microtransaction-like enterprise vision of the future. Everything is great in the preview. While they collect usage data. Then they tuck the most useful and common functionality behind various paywalls, including per usage paywalls. They leave just enough in the base tier to draw people in and get them committed to the platform.
It will not surprise me in the least if basic features are removed and paywalled after the preview. It would not surprise me in the least if they repeat what they’ve already done and prevent users from using built-in python functions unless the user pays up.
I work as a cybersecurity consultant.
This is going to be excellent for business.
Finally. Another step to automate my work.
Excel formulas are way too limited and VBA is a nightmare to work with.
Will this actually automate your workflow?
It seems that this Python integration expects that the source data already exists within the Excel file and Python can essentially just be used to create either visuals or new tables within the same Excel file.
If that’s accurate, then this is intended exclusively for data analysis and not process automation. I don’t think this will allow people to enhance their existing Python based ETL jobs or create new ones because of this new integration. This does not seem to be a replacement/substitute for VBA or OfficeScripts. It also does not seem to be an alternative to Power Query. If anything, this seems to be most similar to Power Pivot.
After preview it will be a paid subscription additional to Office365, the same strategy as Office Copilot. I hate this policy of pay for a product then still paid for more functionalities… at the end of the year you will have paid a lot.
Microsoft says Python in Excel will be included in a Microsoft 365 subscription during the preview, but “some functionality will be restricted without a paid license” after the preview ends.
Yeah this is typical Microsoft looking at ways to force people up the price ladder. They did it with Power Platform in very obvious ways. They have completely gutted things like Power Apps and Power Automate by making almost all functions non-delegable… unless you are a paying a premium on top of a premium for costly dataverses in which case more than like 7 functions are magically delegable again. But then there are the pay-per-user/pay-per-use connections to access your own data, even if you host it yourself as an enterprise.
They should’ve been broken up in the late 90s.
But why does it need to run in the cloud?
I’m not a fan of it either, but I’m not sure how else this could work seamlessly. How would you ensure that everyone you share your Excel file that utilizes Python has the expected Python setup on their machine? What if they have an older version of a library you used that breaks your script? What if they don’t have Python installed at all?
While this will only work on Windows desktop at first, Microsoft plans to roll this out to “other platforms” over time. Is there any other way for this integration to work for Excel for web, iPad, and/or Teams?
That’s true. It wouldn’t solve the dependency issue though (eg - I’m using Pandas v1.5.3, you’re using Pandas v2.0.3) and I’m not sure how well it would work for some platforms like the web or Teams.