Python for Excel. Free & open source.

Latest Release: v0.10.2 (Dec 31, 2016): Python 3.6 support.

xlwings
Next webinar: Fri Jan 27th 2017

New white paper: "Make Excel Audit Proof! - How to Effectively Manage Spreadsheet Risk." Download!

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