Yes, Python can effectively replicate and often surpass Excel’s functionality with greater power, flexibility, and scalability. However, it’s not everyone’s cup of tea.

Microsoft Excel 365 now supports Python integration, allowing users to write Python scripts directly in Excel, with additional flexibility provided by tools like Anaconda and Jupyter Notebooks.

Microsoft Corp. is releasing a new version of Excel that will enable users to write and run Python code directly in the spreadsheet editor’s interface. Stefan Kinnestrand, a general manager for ...

This will enable users to perform complex statistical analysis, advanced visualizations, predictive analytics, and machine learning in Excel.

To provide Python in Excel locally, Anaconda used Microsoft’s existing Excel plugin capabilities combined with their own technologies. They used PyScript, a Python-on-WebAssembly (WASM) technology, to ...

Microsoft today announced the public preview of Python in Excel, which will allow advanced spreadsheet users to combine scripts in the popular Python language and their usual Excel formulas in the ...

Excel gets containerized, cloud-based Python analytics and visualization powers Visualization and analytics tools available in preview, but may be paywalled.