In August 2023, Microsoft launched a beta version of built-in Python in Microsoft 365 Excel, adding Python as a scripting option alongside VBA.
Introduction to Python in Excel
Unlike expectations, built-in Python works as formulas. It runs on Microsoft Cloud (no local Python/package installation), ensuring consistency, security, and version control. Internet connectivity is required.
It supports 20 popular packages (e.g., pandas, Scipy, Sympy, statsmodels, Matplotlib, Seaborn) for data analysis. Chapters 3–8 detail its usage.
Using ChatGPT-Generated Code in Built-in Python
Section 1.4.2 notes Python + pandas yields the best ChatGPT code. Since built-in Python fully supports pandas, using such code is ideal.
Note: Data input/output in built-in Python differs from standard Python IDEs, so code requires minor adjustments.