xlwings Lite

xlwings Lite brings the power of Python to Excel through the popular xlwings package. Unlike the classic version of xlwings, xlwings Lite does not require a local Python installation. To do so, xlwings Lite runs Python locally in the browser that comes with modern Office add-ins. In a little more detail, xlwings Lite is based on Pyodide, which is a Python distribution for WebAssembly (Wasm). WebAssembly is a technology that allows running programming languages like Python directly in web browsers at near-native speed.

Features

• Compatible with Excel on Windows, macOS, and Excel on the web
• Install your own Python packages
• Make web API requests via requests, httpx, aiohttp, pandas.read_csv, etc.
• Write native custom functions a.k.a. user-defined functions (UDFs)
• Write automation scripts similar to Office Scripts with access to the Excel object model
• Runs locally on your own machine without sending data out
• Stores the Python code inside the workbook for easy distribution

xlwings Lite is free to use via the official Excel add-in store for both personal and commercial purposes.