grist-core
Spreadsheet server
A modern relational spreadsheet hosting server built with TypeScript
Grist is the evolution of spreadsheets.
7k stars
52 watching
322 forks
Language: TypeScript
last commit: 2 days ago awesomedatabasespreadsheet
Grist | |||
| grist-desktop | 172 | about 2 months ago | is a Linux/macOS/Windows desktop app for viewing and editing spreadsheets stored locally |
| grist-static | 91 | about 1 year ago | is a fully in-browser build of Grist for displaying spreadsheets on a website without back-end support |
Grist / Features / Python formulas | |||
| Python syntax is supported | Full , including the standard library | ||
| Excel functions | Many also available | ||
| AI Assistant | An specifically tuned for formula generation (using OpenAI gpt-3.5-turbo or via ) | ||
Grist / Features / A portable, self-contained format | |||
| backups | Enables that you can confidently restore in full | ||
Grist / Features | |||
| grist-static | 91 | about 1 year ago | Can be displayed on a static website with – no special server needed |
| grist-desktop | 172 | about 2 months ago | A self-contained desktop app for viewing and editing locally: |
Grist / Features / Convenient editing and formatting features | |||
| choice lists | Choices and , 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 | ||
| Conditional Formatting | , letting you control the style of cells with formulas to draw attention to important information | ||
Grist / Features / Drag-and-drop dashboards | |||
| Charts | , and a 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 | ||
Grist / Features | |||
| Incremental imports | |||
Grist / Features / Integrations | |||
| REST API | A , , and support from similar | ||
| custom widgets | Link data with , hosted externally | ||
Grist / Features | |||
| Many templates | to get you started, from investment research to organizing treasure hunts | ||
Grist / Features / Access control options | |||
| grist-omnibus | 59 | 3 months ago | (You'll need SSO logins set up to make use of these options; has a prepackaged solution if configuring this feels daunting) |
| individual documents | Share , workspaces, or | ||
| individual rows, columns, and tables | Control access to | ||
Grist / Features / Sandboxing options for untrusted documents | |||
| gVisor | 15,851 | 5 days ago | On Linux or with Docker, you can enable sandboxing at the individual document level |
Grist / Features | |||
| 𝕏 or Twitter or whatever | We post progress on and publish | ||
Grist / Using Grist | |||
| docs.getgrist.com | You can try Grist out at the hosted service run by Grist Labs at (no registration needed) | ||
| gristlabs.github.io/grist-static | Or you can see a fully in-browser build of Grist at | ||
| github.com/gristlabs/grist-desktop | 172 | about 2 months ago | Or you can download Grist as a desktop app from |
Grist / Building from source | |||
| gVisor's runsc | 15,851 | 5 days ago | On Linux with installed, is an option |
Grist / Why free and open source software | |||
| Custom Widgets | For developers, having the source open makes it easier to build extensions (such as ). You can more easily include Grist in your pipeline. And if a feature is missing, you can just take the source code and build on top of it | ||
Grist / Reviews | |||
| Grist on ProductHunt | |||
| Grist on AppSumo | (life-time deal is sold out) | ||
| Capterra | , , | ||
Grist / Environment variables | |||
| Work on a copy | Maximum number of rows allowed in ActionHistory before pruning (up to a 1.25 grace factor). Defaults to 1000. ⚠️ A too low value may make the " " feature | ||
| Work on a copy | Maximum number of rows allowed in ActionHistory before pruning (up to a 1.25 grace factor). Defaults to 1Gb. ⚠️ A too low value may make the " " feature | ||
| here | optional. Synonym for ASSISTANT_API_KEY that assumes an OpenAI endpoint is being used. Sign up for an account on OpenAI and then generate a secret key | ||
| grist-widget | 57 | 9 days ago | The file should be in the format produced by the repository, and should be placed in the same directory as . Any material in will be served by Grist, and relative URLs can be used in |