Grist

Great middle-ground between a spreadsheet and a relational DB:

• Easily structure and enrich your data
• Easily create relationships between items
• Easily view your data in different ways
• Easily create derivative columns/properties through Python
• Extensible through custom HTML/CSS/JS widgets (some already exist in the community)
• Interoperable through the API
• Focus on privacy and giving back the power to the user (free/libre licence, self-host and local versions, documents are portable as SQLite DB)
• Efficient and reliable (based on the repository, it seems testing is taken seriously)

You will need to practice a bit to understand the logic and possibilities of the app, especially if you come from spreadsheets. Though, there are a lot of resources available and the community is welcoming.

Where it could be improved:

• It could do better to look nice and neat at first sight
• Complex logic for forms is not possible yet
• Ergonomics and functionalities are already great but could always be further improved

Still, the repo is accepting contributions and the community is vibrant. So I hope the app will continue to grow for the years to come!

This web app offers many features built into the spreadsheet UI without requiring any extensions. I like it.

The problem is the lack or inconvenience of frequently used core features like AutoFill. For example, you set the A column property to Date. Enter today's date in the first cell. You want to enter dates consecutively in the remaining rows. In Google Sheets and MS Excel, you simply click the dot in the bottom right corner of the cell and drag it to the desired rows. How about Grist? I don't know.

Used Grist for the last 2 years. Haven't touched spreadsheets anymore, be it economics or technical. For everyone who is in need of a a secure and manageable database platform, incl. version control - Grist will be your best choice.

Great tool, you can do so much really easily & its open-source!

Open-source, efficient, customizable

Great versatile tool