The popular programming language Python will now be accessible in Excel. Available directly in the Excel ribbon, Python can be used to conduct advanced data analysis, including manipulating and exploring data. The insights can be further refined using Excel’s own formulas, charts and PivotTables.
Python will be available in Excel as part of the software’s built-in connectors and Power Query, which means that users won’t need to separately download a software or set up an add-on to access it. Popular Python libraries like pandas, statsmodels, and Matplotlib will also be accessible in Excel.
Additionally, users will be able to view their Python data within the grid of their Excel spreadsheet, as a result of a new PY function. All Python calculations will take place in the Microsoft Cloud and the results will return to the Excel spreadsheets.
The Python integration in Excel is currently only available as a preview and is included in the Microsoft 365 subscription. Microsoft says that the functionality will be first launched to Windows and later to other platforms as well.