Logo
Deploy Now

Stars

11,601

Forks

620

Watchers

68

Developer links

Grist

With over 11,200 GitHub stars and adoption by France's sovereign digital workspace LaSuite serving 20,000+ government users, Grist is the relational spreadsheet that ends the false choice between fragile Excel files and expensive custom database development — storing all data in portable SQLite files while providing true relational structure where VLOOKUPs become actual linked records that update instantly across entire documents. Python-powered formulas replace complex Excel syntax with clear, readable logic using the full Python standard library, while familiar Excel functions remain available for users who prefer them. Granular access rules control permissions at row, column, table, and cell levels — not just entire sheets — enabling multi-department documents where each team sees only their authorized data. The flexible layout system combines spreadsheets, card views, charts, calendars, and custom widgets on configurable dashboard pages that transform raw data into operational interfaces. Real-time collaboration lets multiple users edit simultaneously with automatic snapshot history capturing every change for full audit trails and point-in-time recovery. AI formula assistance connects to OpenAI, Llama, or any OpenAI-compatible endpoint via OpenRouter to generate formulas from natural language descriptions. The REST API and webhooks enable integration with n8n, Zapier, and custom automation, while incremental imports keep external data sources synchronized. Deployable via Docker with OIDC, SAML, and SCIM authentication support. Running on a dedicated VPS on RepoCloud with guaranteed CPU, RAM, and SSD, full root SSH access, and a browser serial console. Apache 2.0 licensed.

Grist
Grist
Grist
Grist
Grist

Benefits

  • True Relational Data Structure
  • Replace brittle VLOOKUP formulas with actual linked records that update instantly across your entire document — providing database-grade referential integrity within a familiar spreadsheet interface.
  • Granular Row-Level Access Control
  • Control permissions at row, column, table, and cell levels with conditional rules based on user roles and data values — enabling multi-department documents with per-team data visibility.
  • Portable SQLite Storage Format
  • Every Grist document is a standard SQLite database file that any SQLite-compatible tool can read, enabling confident backups, zero vendor lock-in, and seamless migration between hosting environments.
  • Python-Powered Formula Engine
  • Write formulas using full Python syntax and standard library instead of complex Excel functions, with AI assistance from OpenAI or local LLMs generating formulas from natural language descriptions.

Features

  • Flexible Dashboard Layouts
  • Combine spreadsheet views, card lists, charts, calendars, and custom widgets on configurable pages that transform raw data into operational interfaces without code.
  • Real-Time Collaboration
  • Multiple users edit simultaneously with automatic conflict resolution, cell-level comments, change suggestions, and complete snapshot history for full audit trails.
  • Custom Widgets and API
  • Build custom interactive widgets with HTML/JavaScript, connect external services via REST API and webhooks, and integrate with n8n, Zapier, and automation platforms.
  • Incremental Data Imports
  • Synchronize external CSV, Excel, and JSON data sources with merge keys that update existing records rather than duplicating them on each import cycle.
  • AI Formula Assistance
  • Connect OpenAI, Llama, or any OpenAI-compatible endpoint to generate Python formulas from natural language descriptions and explain existing formula logic.