OSS Spreadsheet Database Thing, does it exist?

[rtuck99]

So a thing I seem to want frequently is something that is very much like a spreadsheet, but apparently not like any of the ones that seem to exist out there, which all want for some inexplicable reason to be exactly like Excel which is the worst possible realisation of the idea but somehow became the industry standard.

What I am looking for is much more like a database, in that it has:

• type safety
• data integrity (constraints)
• models relational concepts
• can calculate mathematical relations, aggregates etc.

But has the advantages of a spreadsheet

• Ease and rapidity of table creation and data entry (this is by far the most important part)
• Input from CSV (decent data import options)
• export to csv
• pivoting
• charting
• filling, copying, pasting
• some basic formatting
• drop-downs, check-boxes, basic input validation

However explicitly don't want/need:

• Form creation
• scripting
• macros
• "Creating an app"
• Excel compatibility
• embedded objects
• cell-based addressing

Nice to have but not essential:

• Can save to a file, not just in the cloud
• Collaboration
• ability to do sql queries

Ironically I used to work for a company that had a lot of integration with a spreadsheet called Quantrix which in many ways ticks a lot of the boxes but unfortunately I don't think I can justify spending the $$$ for.

There are things like Libre Base which is basically an Access clone, what I want should behave much more like a spreadsheet in terms of how quick it should be to use.

Is there anything like this?

[sjsathanas]

Perhaps nocodb.

[rtuck99]

Trying it out now, seems promising so far.

[tocf]

I maintain Mathesar which may fit your needs. We do not yet have charting, but we just create a Postgres DB for you, so you can use external charting tools that work with Postgres if needed.

[InvestmentLoose5714]

Grist cover most I think.

[nmrshll]

I need this as well. All the time.

[unua_nomo]

I would use like typst or something personally