# This repository adheres to the publiccode.yml standard by including this # metadata file that makes public software easily discoverable. # More info at https://github.com/italia/publiccode.yml publiccodeYmlVersion: '0.2' categories: - data-collection - crm - compliance-management - office dependsOn: open: - name: NodeJS optional: false version: '' versionMax: '' versionMin: '18' - name: Python optional: false version: '' versionMax: '' versionMin: '3.9' - name: Yarn optional: true version: '' versionMax: '' versionMin: '' - name: Postgresql optional: true version: '' versionMax: '' versionMin: '' - name: Redis optional: true version: '' versionMax: '' versionMin: '' description: en: apiDocumentation: 'https://support.getgrist.com/api/' documentation: 'https://support.getgrist.com/' features: - database - spreadsheet - low-code - no-code - form generation - webhook - calendar - map - python formulas genericName: collaborative spreadsheet longDescription: | Grist is a hybrid database/spreadsheet, meaning that: - Columns work like they do in databases: they are named, and they hold one kind of data. - Columns can be filled by formula, spreadsheet-style, with automatic updates when referenced cells change. This difference can confuse people coming directly from Excel or Google Sheets. Give it a chance! There's also a [Grist for Spreadsheet Users](https://www.getgrist.com/blog/grist-for-spreadsheet-users/) article to help get you oriented. If you're coming from Airtable, you'll find the model familiar (and there's also our [Grist vs Airtable](https://www.getgrist.com/blog/grist-v-airtable/) article for a direct comparison). Here are some specific feature highlights of Grist: - Python formulas. - Full [Python syntax is supported](https://support.getgrist.com/formulas/#python), including the standard library. - Many [Excel functions](https://support.getgrist.com/functions/) also available. - An [AI Assistant](https://www.getgrist.com/ai-formula-assistant/) specifically tuned for formula generation (using OpenAI gpt-3.5-turbo or [Llama](https://ai.meta.com/llama/) via [llama-cpp-python](https://github.com/abetlen/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](https://support.getgrist.com/exports/#backing-up-an-entire-document) that you can confidently restore in full. - Great for moving between different hosts. - Can be displayed on a static website with [`grist-static`](https://github.com/gristlabs/grist-static) – no special server needed. - A self-contained desktop app for viewing and editing locally: [`grist-electron`](https://github.com/gristlabs/grist-electron). - Convenient editing and formatting features. - Choices and [choice lists](https://support.getgrist.com/col-types/#choice-list-columns), for adding colorful tags to records. - [References](https://support.getgrist.com/col-refs/#creating-a-new-reference-list-column) and reference lists, for cross-referencing records in other tables. - [Attachments](https://support.getgrist.com/col-types/#attachment-columns), 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](https://support.getgrist.com/conditional-formatting/), letting you control the style of cells with formulas to draw attention to important information. - Drag-and-drop dashboards. - [Charts](https://support.getgrist.com/widget-chart/), [card views](https://support.getgrist.com/widget-card/) and a [calendar widget](https://support.getgrist.com/widget-calendar/) for visualization. - [Summary tables](https://support.getgrist.com/summary-tables/) for summing and counting across groups. - [Widget linking](https://support.getgrist.com/linking-widgets/) 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](https://support.getgrist.com/search-sort-filter/#filter-buttons) for quick slicing and dicing. - [Incremental imports](https://support.getgrist.com/imports/#updating-existing-records). - 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](https://support.getgrist.com/api/), [Zapier actions/triggers](https://support.getgrist.com/integrators/#integrations-via-zapier), and support from similar [integrators](https://support.getgrist.com/integrators/). - Import/export to Google drive, Excel format, CSV. - Link data with [custom widgets](https://support.getgrist.com/widget-custom/#_top), hosted externally. - Configurable outgoing webhooks. - [Many templates](https://templates.getgrist.com/) 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`](https://github.com/gristlabs/grist-omnibus) has a prepackaged solution if configuring this feels daunting) - Share [individual documents](https://support.getgrist.com/sharing/), workspaces, or [team sites](https://support.getgrist.com/team-sharing/). - Control access to [individual rows, columns, and tables](https://support.getgrist.com/access-rules/). - 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](https://github.com/google/gvisor) sandboxing at the individual document level. - On macOS, you can use native sandboxing. - On any OS, including Windows, you can use a wasm-based sandbox. - Translated to many languages. - `F1` key brings up some quick help. This used to go without saying, but in general Grist has good keyboard support. shortDescription: |- Grist is a modern relational spreadsheet. It combines the flexibility of a spreadsheet with the robustness of a database. videos: - 'https://www.youtube.com/watch?v=XYZ_ZGSxU00' developmentStatus: stable inputTypes: - application/vnd.openxmlformats-officedocument.spreadsheetml.sheet - text/csv it: conforme: gdpr: false lineeGuidaDesign: false misureMinimeSicurezza: false modelloInteroperabilita: false countryExtensionVersion: '0.2' piattaforme: anpr: false cie: false pagopa: false spid: false landingURL: 'https://getgrist.com' legal: license: Apache-2.0 localisation: availableLanguages: - en - fr - ru - de - es - pt - zh - it - ja - 'no' - ro - sl - uk localisationReady: true logo: |- https://raw.githubusercontent.com/gristlabs/grist-core/master/static/img/logo-grist.png maintenance: contacts: - affiliation: Grist Labs email: paul@getgrist.com name: Paul Fitzpatrick type: internal name: Grist outputTypes: - application/x-sqlite3 platforms: - web releaseDate: '2024-06-12' roadmap: 'https://github.com/gristlabs/grist-core/projects/1' softwareType: standalone/other softwareVersion: 1.1.15 url: 'https://github.com/gristlabs/grist-core' usedBy: - 'ANCT (https://anct.gouv.fr)' - 'DINUM (https://www.numerique.gouv.fr/dinum/)'