
Airtable
Cloud collaboration platform combining the flexibility of a spreadsheet with database power
Discover top open-source software, updated regularly with real-world adoption signals.

Modern relational spreadsheet combining database power with spreadsheet flexibility
Grist merges spreadsheet ease with database structure. Named columns, Python formulas, portable SQLite format, REST API, and granular access controls for teams and individuals.

Grist is a hybrid database-spreadsheet platform designed for users who need more structure than traditional spreadsheets offer but want to avoid the complexity of full database systems. Columns are typed and named like database fields, yet formulas update automatically like spreadsheets. This architecture appeals to data-savvy teams, analysts, and developers managing everything from operational dashboards to collaborative workflows.
Grist supports Python formulas with the full standard library, a portable SQLite-based format for reliable backups and migration, and drag-and-drop dashboards with charts, calendar widgets, and summary tables. Incremental CSV imports prevent duplication, while native forms feed data directly into tables. Access control extends to rows, columns, and tables—ideal for multi-tenant or compliance-sensitive environments. Integration options include a REST API, webhooks, Zapier triggers, and custom widgets.
Run grist-core as a self-hosted server via Docker, deploy grist-desktop for offline editing on Linux, macOS, or Windows, or embed grist-static in a website with no backend. Sandboxing via gVisor (Linux/Docker), native macOS sandboxing, or WebAssembly protects against untrusted documents. SSO via OIDC and SAML is built in; templates and multi-language support accelerate onboarding.
When teams consider Grist, these hosted platforms usually appear on the same shortlist.

Cloud collaboration platform combining the flexibility of a spreadsheet with database power

No-code app builder to create data-driven web & mobile apps from sheets and databases

Open-source low-code platform for rapidly building internal tools and CRUD web applications with minimal coding
Looking for a hosted option? These are the services engineering teams benchmark against before choosing open source.
Incremental Bank Transaction Imports
Import monthly CSV exports without duplication, maintaining a cumulative financial ledger with automatic formula updates.
Multi-Tenant Operational Dashboard
Build dashboards with row-level access control so each client sees only their data, enforced by user attributes and SSO.
Offline Field Data Collection
Deploy grist-desktop on laptops for field teams to edit locally, then sync SQLite files back to a central server.
Public Data Explorer on Static Site
Embed grist-static in a website to let visitors filter and visualize datasets without provisioning backend infrastructure.
Grist columns are typed and named like database fields. Formulas use Python syntax, and the underlying storage is SQLite, making data more structured and portable.
Yes. Use grist-desktop to view and edit spreadsheets locally on Linux, macOS, or Windows with no server dependency.
Linux and Docker support gVisor sandboxing, macOS offers native sandboxing, and all platforms including Windows can use WebAssembly-based isolation.
Yes. OIDC and SAML authentication are built in, along with row, column, and table-level access rules. Configure SSO to activate these features.
Use the REST API for programmatic access, configure outgoing webhooks for event-driven workflows, or connect via Zapier and similar platforms.
Project at a glance
ActiveLast synced 4 days ago