Python 3.14 has a new feature called the template string, or t-string, type. A t-string superficially resembles an f-string, but it’s designed to do something very different.

“No set up or installation is required. Using Excel’s built-in connectors and Power Query, you can easily bring external data into Python in Excel workflows.” Image Credits: Microsoft ...

Python, a high-level programming language known for its simplicity and versatility, has been incorporated into Excel through Anaconda’s secure distribution for Python packages.

With this new feature, users can type in Python code in the Excel app. The calculations are then run on a Microsoft cloud server and are returned to the Excel app, with plots and visualizations.

Python is now integrated into Excel via Microsoft 365, allowing users to write Python code directly in spreadsheets using the `=PY` formula, enhancing data analysis and visualization capabilities.

Open Excel, and you will see a new tab in the ribbon at the top that says PyXLL.

Microsoft says support for Python in Excel for other platforms will come “at a later date.” The feature is being rolled out gradually, however, so even Windows users may not immediately have ...

The public preview of the Python integration on Microsoft Excel will be available to Microsoft 365 Insiders using the Beta Channel in Excel for Windows.