Python for Excel. Free & open source.
Latest Release: v0.11.4 (Jul 23, 2017): Add-in & SQL Extension
INTERACTION / AUTOMATION
Leverage Python's scientific stack for interactive data analysis using Jupyter Notebooks, NumPy, Pandas, scikit-learn etc. As such, xlwings is a free alternative to tools like Power BI or Tableau (Windows & Mac).
MACROS / EXCEL TOOLS
Write Excel tools with Python instead of VBA and call your code directly from within Excel, e.g. via a button on the sheet. This also works great for prototyping web apps (Windows & Mac).
UDFs (USER DEFINED FUNCTIONS)
Write (array) UDFs in a breeze by taking advantage of all the functionality already available in libraries like NumPy and Pandas. Since v0.10, dynamic array formulas are supported (Windows only).
