Grist

What is Grist?

Grist is an open source relational spreadsheet that combines a familiar grid with the structure of a real database. You work in tables with typed columns and reference links between them, write formulas in Python instead of a spreadsheet dialect, and build dashboards from the same data — all in a document you can self-host or run in the cloud.

What is Grist best for?

Teams that have outgrown flat spreadsheets but don’t want a heavyweight database or per-seat SaaS. It fits anyone tracking structured, related data — CRMs, inventories, project trackers, budgets — who wants spreadsheet ease plus data integrity, Python formulas, and the option to keep everything on their own servers.

What can Grist do?

• Link tables with reference columns and two-way relationships, so data stays consistent instead of copy-pasted
• Write formulas in real Python, with Excel-compatible functions, rather than a limited spreadsheet formula language
• Build dashboards from charts, card views, calendars, and linked widgets that filter each other
• Store each document as a portable SQLite file you can open with standard database tools
• Set row-, column-, and table-level access rules to control exactly what each user sees
• Collect data with native forms (including file attachments) and import CSVs incrementally without duplicates
• Automate and integrate through a REST API, webhooks, and Zapier

Where does Grist fall short?

• Several features are held back in the open source grist-core edition — SSO (OIDC/SAML), audit log streaming, advanced admin controls, the broader AI Assistant, and built-in automations/email notifications are Enterprise-only.
• Its Python-formula and relational model is more to learn than a plain spreadsheet; casual users who just want cells and quick math may find it heavier than they need.
• Very large datasets hit practical limits — the hosted Free tier caps documents at 5,000 records, and even paid tiers cap around 100,000–150,000 records per document, so it’s not a warehouse for millions of rows.

Is Grist free?

Yes — the community edition (grist-core) is free and open source under Apache-2.0, and you can self-host it at no license cost. Grist also offers a hosted cloud with a free tier (up to 5,000 records per document) and paid Pro ($8–$10/user/mo) and Business ($24–$30/user/mo) plans. A paid self-hosted Enterprise edition ($24–$30/user/mo) unlocks SSO, audit logs, and automations.

What does Grist replace?

Grist is a self-hosted alternative to Airtable, Google Sheets, and Smartsheet. It covers the same spreadsheet-database ground — structured tables, forms, dashboards, and sharing — but you can run it on your own infrastructure and keep full ownership of your data. Other open source options in this space include NocoDB and Teable.

FAQ

Is Grist open source? Yes. The core (grist-core) is released under the Apache-2.0 license, so it’s genuinely open source and free to self-host. Some advanced features (SSO, audit logs, automations) are reserved for the paid Enterprise edition.

Can I self-host Grist for free? Yes. The community edition runs free via Docker or Node.js. You only pay for your own server, or for the Enterprise edition if you need SSO and admin features.

Is Grist a good Airtable alternative? For teams that want data ownership and Python formulas, yes — it self-hosts and stores data in portable SQLite. Airtable offers a more polished hosted app and larger app-marketplace ecosystem if you’d rather not run servers.

What do I need to run Grist? A server with Docker (or Node.js) and Python 3.10–3.11 for formula execution, on port 8484 by default. Redis and S3-compatible storage are optional for sessions and attachment storage.