Python for Excel. Free & open source.

Latest Release: v0.10.0 (Sep 20, 2016): Introducing dynamic array formulas.

xlwings

NEW: Learn xlwings from the people who made it!

BOOK YOUR WEBINAR NOW

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).