Grist
A spreadsheet whose formula language is real Python - full syntax plus the standard library,
alongside familiar all-caps Excel functions: Grist is an open-source relational spreadsheet.
Data lives in tables with typed columns and reference links, queried in formulas through
lookupRecords and lookupOne, so one document can model what would otherwise take several
joined spreadsheets. Trigger formulas compute values on conditions you define (timestamps,
authorship, data cleanup, smart defaults), and an AI Formula Assistant generates formulas via
OpenAI, Llama, or any OpenAI-compatible endpoint. Each document is a self-contained SQLite
file, readable by any SQLite tool and trivially portable between hosts, with automatic
snapshots and full-history exports. Layouts combine card, table, and chart widgets into
dashboards, and granular role-based access rules restrict who sees which rows and columns - a
design that made Grist a foundation of France's sovereign LaSuite workspace with 20,000+
government users. The Apache-2.0 grist-core edition ships SSO via OIDC and SAML, a REST API,
webhooks, and forms; formula execution can be sandboxed with gVisor so untrusted documents
cannot reach the network or each other.
Deploy