Xlwings Lite – Python in Excel Using Pyodide

Summary

Toggle Light / Dark / Auto color theme Toggle table of contents sidebar xlwings Lite xlwings Lite brings the VBA experience into the modern age by offering a privacy-first, secure, and developer-friendly way to automate Excel and write custom functions with Python. Free & easy to install: Available for free in the Office add-in store for both personal and commercial use. No registration or login required, simply install and create amazing things! Cross-platform: Works on Windows, macOS, and Excel for the web. It’s compatible with Microsoft 365 as well as recent perpetual versions like Office 2024. No Python installation required: You don’t need to have Python installed as Python runs inside the browser that powers modern Excel add-ins (using WebAssembly via Pyodide). Easy distribution: Python code is stored inside the workbook, making the xlwings Lite add-in the only requirement to run your workbook. Custom functions & scripts: Define native custom functions (a.k.a. user-defined functions “UDFs”) and run automation scripts by clicking a button. Excel object model: Access the Excel object model to insert a new sheet, format an Excel range as table, set the color of a cell, etc. Install packages: Install and use libraries like pandas, Polars, DuckDB, or even your own custom Python packages. Web API access: Fetch data from APIs that support CORS. Lightning-fast: All code runs locally on your machine, eliminating network latency and delivering lightning-fast performance! Fully local & private: Runs entirely on your computer without sending data out. The only exception is Microsoft’s mandatory telemetry, which you can eliminate through self-hosting. Familiar & powerful editor: xlwings Lite uses the same editor as VS Code, supporting many of the same keyboard shortcuts to make you more efficient. Self-hosting: For maximum security, you can deploy xlwings Lite on your own infrastructure, behind your firewall (“on-premise installation”). Works offline: xlwings Lite only req...