# x2bool/xlite

Query Excel spredsheets (.xlsx, .xls, .ods) using SQLite

Repository: https://github.com/x2bool/xlite
Canonical: https://ross.abutalabs.com/products/xlite
Language: Rust
License: MIT
License Family: permissive
Topics: excel, sql, sqlite, sqlite3, xls, xlsx, ods, sqlite-extension, sqlite-virtual-table
Last push: 2025-03-09T18:33:20+00:00

## Health v2 (maintenance only)
Score: 27/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 10, release rhythm 8, longevity 100
- inputs: {"age_days": 1530, "days_push": 542, "days_rel": 542, "gap_med": null, "n_releases_24m": 1}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1304, forks 50 (observed 2026-08-28T04:04:18.427555+00:00)

## What it is
XLite is a SQLite extension written in Rust that exposes Excel (.xlsx, .xls) and Open Document (.ods) spreadsheets as SQLite virtual tables. It lets users run standard SQL queries against spreadsheet files directly from SQLite without converting them first.

## Use cases
- query excel spreadsheets with sql
- run sqlite queries on xlsx files
- analyze spreadsheet data without converting to csv
- join spreadsheet data with other sqlite tables
- filter and aggregate excel data using sql
- load ods files into sqlite as virtual tables

## When to choose
- you already work in SQLite and want to query spreadsheet files in place
- you need SQL features like joins, grouping, and filtering on Excel data
- you want a lightweight loadable extension rather than a full ETL pipeline

## When to avoid
- you need to write or modify spreadsheets, not just read them
- you need a pure-Python or pure-JS library embedded in an application runtime
- you cannot load native SQLite extensions in your environment

## Facets
- artifact type: library
- maturity: active
- function: database, parser, developer-tools
- domain: spreadsheets, databases, files, developer-tools
- platform: windows, cli
- tags: sqlite-extension, virtual-table, xlsx, ods, spreadsheet-querying, rust, linux, macos

## Member repositories
- x2bool/xlite (main) score 27

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:04:18.427555+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-30T04:51:09.258761+00:00, confidence not recorded.
  - readme: https://github.com/x2bool/xlite (fetched 2026-08-28T04:04:18.427555+00:00, sha bea0356cb852)
- Data as of 2026-08-30T08:39:29.467469+00:00.