Grist

Grist combines spreadsheet flexibility with relational database capabilities, letting users define named columns that hold a single data type and populate them with spreadsheet‑style formulas that update automatically when referenced cells change. It supports full Python syntax in formulas, includes many Excel‑compatible functions, and offers an AI‑assisted formula generator that works with various language‑model endpoints. Data is stored in a portable SQLite‑based format, enabling straightforward backups, migration between hosts, and direct reading by any tool that can handle SQLite files.

The project provides three open‑source components: a server‑side core for self‑hosting, a cross‑platform desktop application for local editing, and a static‑site build that can display spreadsheets in a browser without a back‑end. Access control can be expressed through formulas, and the interface includes choice lists, references, and drag‑and‑drop layout widgets for building custom views and dashboards.

Grist is targeted at teams and individuals who need collaborative, relational data management without a subscription model, including developers, researchers, nonprofits, and small businesses. Its Apache‑2.0 license and self‑contained format make it suitable for on‑premises deployment, while the open‑source codebase allows extensions and integration with existing workflows.