Grist

Grist is a hybrid of a spreadsheet and a database. Columns are named and hold one kind of data, as in a database table, yet they can still be filled by formula and recalculate when a referenced cell changes. That combination rescues the spreadsheet that quietly became a system of record.

Formulas are written in Python, with the full syntax and standard library alongside many familiar Excel functions. A formula timer diagnoses the slow ones, and an AI formula assistant drafts them using OpenAI, Llama or any OpenAI-compatible endpoint.

This repository, the Community edition, carries most of what the product does.

• SQLite storage: a document is a self-contained SQLite file, readable by any tool that reads SQLite.
• Access rules: control access to individual rows, columns and tables, based on cell values and user attributes.
• Dashboards: charts, card views, calendars and summary tables, laid out as linked widgets instead of one crowded table.
• Native forms: forms feeding the spreadsheet directly, with attachments, hidden fields and pre-population.
• Collaboration: threaded cell comments with mentions, live presence, and suggested changes for review.

Integrations include a REST API with an interactive console, configurable outgoing webhooks, import and export with Google Drive, Excel and CSV, and SCIM provisioning. Incremental imports let you add a month of new bank activity without duplicating what is already there.

grist-core is Apache 2.0 and self-hostable, with a desktop app and an in-browser build in separate repositories. Features exclusive to the hosted edition are listed explicitly rather than left to discover.