grist-coreGrist is the evolution of spreadsheets.

grist-core

Grist is a modern relational spreadsheet that combines the flexibility of traditional spreadsheets with the robustness and structure of databases. It's a self-contained server application built on SQLite that enables teams to organize, analyze, and visualize data without the limitations of traditional spreadsheet software.

Key Features

• Python Formulas: Full Python syntax support with access to the standard library, plus Excel function compatibility and AI-assisted formula generation
• Portable Format: SQLite-based self-contained format that's readable by any SQLite tool, ensuring data portability and reliable backups
• Rich Data Types: Support for choices, references, attachments, dates, currency, and conditional formatting with specialized editors
• Dashboard & Visualization: Drag-and-drop dashboards with charts, card views, calendar widgets, summary tables, and widget linking
• Native Forms: Create data entry forms that feed directly into spreadsheets without additional setup
• Incremental Imports: Smart CSV import with update capabilities to handle recurring data syncs without duplication
• REST API: Full API integration support for connecting with external systems

Use Cases

• Data Organization: Replace traditional spreadsheets with a structured database approach for teams managing complex datasets
• Business Intelligence: Build dashboards and summary tables to visualize and analyze data across departments
• Form-Based Data Collection: Create custom forms for surveys, feedback, or structured data entry that automatically populates tables
• Financial Tracking: Manage bank imports and transaction data with incremental updates and formula-based calculations
• Self-Hosted Solutions: Deploy on personal infrastructure for organizations requiring data sovereignty and control

Who Is It For

Grist is ideal for teams and organizations that have outgrown traditional spreadsheets but want to avoid the complexity of custom database applications. It appeals to data analysts, small businesses, non-profits, government agencies, and anyone seeking a self-hosted alternative to cloud-based spreadsheet and database platforms.