x2bool/xlite

Health v2 · maintenance only

Adoption not part of the score

1304 stars · 50 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

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

library · maturity active

database parser developer-tools spreadsheets databases files developer-tools windows cli sqlite-extension virtual-table xlsx ods spreadsheet-querying rust linux macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="x2bool/xlite")