Python for Excel

Latest xlwings release: v0.25.3

xlwings is open source and free, comes preinstalled with Anaconda and WinPython, and works on Windows and macOS.

Automate Excel via Python scripts or Jupyter notebooks, call Python from Excel via macros, and write user-defined functions (UDFs are Windows-only).

Help the project grow via our paid plans and get direct support and additional features including one-click installers and template-based reporting.

Responsive image

Get the O'Reilly Book

The book introduces you to:
Python, pandas, OpenPyXL, XlsxWriter, pyxlsb, xlrd, xlwt, xlutils and xlwings as well as Jupyter notebooks and Visual Studio Code. Available in English, French, Chinese, Serbian, and Polish.

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

Daniel Guetta

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

Daniel Guetta, Associate Professor, Columbia Business School

Scott Pritchard

The xlwings video course is excellent…it covers everything you need to know, from getting started all the way through to advanced topics.

Scott Pritchard, Credit Analyst, Finland

xlwings Newsletter

We help you excel with Microsoft Excel, see Past Issues.