Python for Excel. Free & open source.

Latest Release: v0.15.1 (29 November 2018)

xlwings
Start our video course Open a priority ticket
New blog post: Collaborate On Excel Workbooks - The Definitive Guide

INTERACTION/AUTOMATION

 

Leverage Python's scientific stack for interactive data analysis using Jupyter Notebooks, NumPy, Pandas, scikit-learn etc. Or use xlwings to automate Excel reports with Python (Windows & Mac).

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

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

REST API

Expose your workbooks via REST API and access them from other computers in your corporate intranet or over the web. See the REST API docs.