Grist

Grist is an open-source, collaborative spreadsheet software designed to transform chaotic data into structured, relational applications. It combines the familiar interface of a spreadsheet with the power of a database, allowing users to build custom data tools without extensive coding. It caters to a wide range of users, from IT departments seeking to eliminate spreadsheet sprawl and control access, to research labs managing sensitive data, nonprofits needing affordable CRM, and developers looking for a self-hostable spreadsheet with database capabilities. Grist emphasizes data ownership, security, and flexibility, enabling users to create tailored solutions for their specific workflows. Key functionalities include an AI assistant for data analysis and formula generation, form and survey builders, flexible drag-and-drop layouts, granular access rules for collaboration, and dynamic data visualizations. It supports Python in formulas, offers extensive APIs and integrations, and can be self-managed for compliance or intranet operations, using a portable SQLite format.