New Tutorial: Connect Google Sheets to SQLite

Python for Excel and Google Sheets

Latest xlwings release: v0.27.12

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

Our paid plans give you direct support and additional features including 1-click installers, template-based reporting, and the ability to install Python on a Linux server/cloud with support for Google Sheets, Excel on the web, and Desktop Excel.

Responsive image

What Our Users Say

Jolanda Stadelmann
quote

We use xlwings to automate the data feeds of one of our analytical spreadsheet tools, which saves us 1–2 days of tedious manual work every month. Data sources include REST APIs, CSV files via SFTP, and web scraping.

Jolanda Stadelmann, Founding Partner, zCapital

Adam Wood, CFA
quote

xlwings has saved me hundreds of hours in my current role. I replaced the VBA reporting with it and instead of taking 20–30 hours a month I can get the reports run in 6–7 hours.

Adam Wood, CFA, Analyst at a large U.S. custody bank

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, Trad. Chinese, Simpl. Chinese, Korean, Serbian, Polish, and German (Q3 2022).

You're in good company

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.

xlwings Newsletter

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