# xlwings/xlwings

xlwings is a Python library that makes it easy to call Python from Excel and vice versa. It works with Excel on Windows, macOS, and Excel on the web.

Repository: https://github.com/xlwings/xlwings
Canonical: https://ross.abutalabs.com/products/xlwings
Homepage: https://www.xlwings.org
Language: Python
License: NOASSERTION
License Family: other
Topics: python, excel, reporting, automation
Last push: 2026-08-24T19:24:04+00:00

## Health v2 (maintenance only)
Score: 99/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 99, release rhythm 98, longevity 100
- inputs: {"age_days": 4552, "days_push": 9, "days_rel": 16, "gap_med": 8.5, "n_releases_24m": 47}
- flags: no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 3396, forks 537 (observed 2026-08-28T04:08:02.458891+00:00)

## What it is
xlwings is a BSD-licensed Python library that lets you call Python from Excel and automate Excel from Python, replacing VBA macros with Python scripts, macros, and user-defined functions (UDFs). It supports NumPy and pandas, works with desktop Excel on Windows and macOS, and extends to Excel on the web via xlwings Lite and the commercial xlwings Server/PRO offerings.

## Use cases
- automate excel with python
- replace vba macros with python
- write excel user-defined functions in python
- read and write excel files with pandas
- build excel reports from python
- run python calculations from excel cells
- connect excel to databases and apis
- use python in excel on the web

## When to choose
- you want to automate Excel with Python instead of VBA
- you need pandas/NumPy data flowing between Python and spreadsheets
- you want Python-powered UDFs or macros in Excel
- you need template-based reporting or Excel automation on Windows and macOS

## When to avoid
- you only need to read Excel files without Excel installed and don't need the PRO Reader
- you need a fully open-source server-side solution without a commercial license
- you work primarily with Google Sheets or LibreOffice rather than Excel
- you need UDFs on macOS (Windows-only for classic UDFs)

## Facets
- artifact type: library
- maturity: active
- function: workflow-automation, data-science, etl, sdk
- domain: data-science, spreadsheets, developer-tools
- platform: windows, python, cross-platform
- tags: excel, spreadsheet-automation, vba-replacement, udf, pandas, numpy, jupyter, office-addin, reporting, pyodide, automation, macos, web-server

## Member repositories
- xlwings/xlwings (main) score 99

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:08:02.458891+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T18:38:56.065371+00:00, confidence not recorded.
  - readme: https://github.com/xlwings/xlwings (fetched 2026-08-28T04:08:02.458891+00:00, sha afcbe12ae01a)
  - homepage: https://www.xlwings.org (fetched 2026-08-29T09:34:37.790528+00:00, sha a4562d16d575)
  - site_page: https://www.xlwings.org/features (fetched 2026-08-29T09:34:37.794383+00:00, sha 90ae356ffcdd)
  - site_page: https://www.xlwings.org/pricing (fetched 2026-08-29T09:34:37.799413+00:00, sha 0f8be6a7f55c)
  - site_page: https://lite.xlwings.org (fetched 2026-08-29T09:34:37.803057+00:00, sha b968433292c4)
- Data as of 2026-08-30T08:39:29.467469+00:00.