Grist is a modern relational spreadsheet.
It combines the flexibility of a spreadsheet with the robustness of a database. It consists of a spreadsheet hosting server, a cross-platform desktop app for viewing and editing spreadsheets stored locally, as well as a fully in-browser build for displaying spreadsheets on a website without back-end support.
This is free and open source software.
Key Features
- Python formulas
- Full Python syntax is supported, including the standard library.
- Many Excel functions are also available.
- An AI Assistant specifically tuned for formula generation (using OpenAI gpt-3.5-turbo or Llama via llama-cpp-python).
- A portable, self-contained format.
- Based on SQLite, the most widely deployed database engine.
- Any tool that can read SQLite can read numeric and text data from a Grist file.
- Enables backups that you can confidently restore in full.
- Can be displayed on a static website with grist-static – no special server needed.
- A self-contained desktop app for viewing and editing locally: grist-electron.
- Convenient editing and formatting features.
- Choices and choice lists, for adding colorful tags to records.
- References and reference lists, for cross-referencing records in other tables.
- Attachments, to include media or document files in records.
- Dates and times, toggles, and special numerics such as currency all have specialized editors and formatting options.
- Conditional Formatting, letting you control the style of cells with formulas to draw attention to important information.
- Drag-and-drop dashboards.
- Charts, card views and a calendar widget for visualization.
- Summary tables for summing and counting across groups.
- Widget linking streamlines filtering and editing data. Grist has a unique approach to visualization, where you can lay out and link distinct widgets to show together, without cramming mixed material into a table.
- Filter bar for quick slicing and dicing.
- Incremental imports.
- Import a CSV of the last three months activity from your bank……and import new activity a month later without fuss or duplication.
- Integrations.
- A REST API, Zapier actions/triggers, and support from similar integrators.
- Import/export to Google drive, Excel format, CSV.
- Link data with custom widgets, hosted externally.
- Configurable outgoing webhooks.
- Many templates to get you started, from investment research to organizing treasure hunts.
- Access control options.
- (You’ll need SSO logins set up to make use of these options; grist-omnibus has a prepackaged solution if configuring this feels daunting)
- Share individual documents, workspaces, or team sites.
- Control access to individual rows, columns, and tables.
- Control access based on cell values and user attributes.
- Self-maintainable.
- Useful for intranet operation and specific compliance requirements.
- Sandboxing options for untrusted documents.
- On Linux or with Docker, you can enable gVisor sandboxing at the individual document level.
- Translated to many languages.
Website: www.getgrist.com
Support: GitHub Code Repository
Developer: Grist Labs
License: Apache License 2.0
Grist is written in TypeScript and Python. Learn TypeScript with our recommended free books and free tutorials. Learn Python with our recommended free books and free tutorials.
Related Software
| No-Code Database Tools | |
|---|---|
| NocoDB | Build databases as spreadsheets |
| Teable | Manage your data and connect your team |
| Baserow | No-code database and Airtable alternative |
| Directus | Real-time API and App dashboard for managing SQL database content |
| Grist | Modern relational spreadsheet |
| rowy | Low-code backend in the browser |
| Mathesar | Spreadsheet-like tool for Postgres data |
| UNDB | No-code platform that can also serve as a Backend as a Service |
Read our verdict in the software roundup.
 Explore our comprehensive directory of recommended free and open source software. Our carefully curated collection spans every major software category.This directory is part of our ongoing series of informative articles for Linux enthusiasts. It features hundreds of detailed reviews, along with open source alternatives to proprietary solutions from major corporations such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. You’ll also find interesting projects to try, hardware coverage, free programming books and tutorials, and much more. Discovered a useful open source Linux program that we haven’t covered yet? Let us know by completing this form. |