Our next London Meetup is on 16 Jan 2020.

Python for Excel

and other innovative solutions for modern Excel developers

xlwings sample case

Latest release of the xlwings Python package: v0.16.0 (13 October 2019).
You're in good company:



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



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



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


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.

What our users say

xlwings has been invaluable in bringing the power of Python to the Excel front-end many business users are familiar with.

xlwings testimonial 1 Daniel Guetta
Senior Lecturer, Columbia Business School

The xlwings video course is excellent…it covers everything you need to know, from getting started all the way through to advanced topics. The explanations in the videos make the concepts crystal clear and the accompanying Jupyter notebooks provide an invaluable reference for simple to advanced use cases. My advice for anyone planning on using xlwings…save yourself the trouble of having to read more documentation and instead sit back, watch the videos, listen to explanations directly from the package’s creator, and start using xlwings right away.

scott Scott Pritchard
Credit Analyst, Finland