Grist

Grist is a modern relational spreadsheet application that combines the flexibility of spreadsheets with the robustness of databases. Grist allows users to create, edit and manage complex data tables, supports Python formulas and complete Python syntax, including standard libraries and many Excel functions. The main features of Grist include: 1. ** Data management **: Columns work like databases, have naming functions, and can hold one type of data. Columns can be populated with formulas like a spreadsheet and automatically updated when referenced cells change. 2. ** Portability **: Based on SQLite, Grist files can be read by any tool capable of reading SQLite, making it easy to backup and move between different hosts. 3. ** Editing and formatting functions **: Provides editing and formatting options for special number types such as select and select lists, references and reference lists, attachments, dates and times, switches, currencies, and conditional formatting. 4. ** Visualization **: Supports drag-and-drop dashboards, charts, card views and calendar widgets, provides summary tables for group summary and counting, and simplifies data filtering and editing through widget links. 5. ** Integration **: Provides REST APIs, Zapier operations/triggers, supports import/export of Google Drive, Excel format and CSV, and configures externally hosted widgets and external webhooks. 6. ** Access control **: Supports single sign-on (SSO) configuration, allows sharing of documents, workspaces, or team sites, and controls access based on cell values and user attributes. 7. ** Self-maintenance **: Applies to intranet operations and specific compliance requirements, supports gVisor sandboxes on Linux or Docker, local sandboxes on macOS, and wasm-based sandboxes on any operating system.