xlwings VS Grist

I don't have, but looked into this. You would have to use microsoft VBA (Visual Basic for Applications) or even cleaner python with NumPy (xlwings.org) to do your modeling. Excel for input and viewing results. Source: over 2 years ago

Grist Labs | Systems Engineer | Full-time | NYC OR REMOTE +/- 3hrs | https://getgrist.com We're looking for someone to make our modern spreadsheet software run everywhere. To apply, there's a puzzle. Just do:. - Source: Hacker News / 2 months ago

[Baserow], [APITable], [Grist], and [Rowy] are all open source Airtable alternatives which offer hosted SaaS versions that include API access, though it's a bit difficult to compare the API rate limits across all these products. Self-hosting an app like this would allow you to bypass API rate limits altogether, if you're open to it. All the above products can be self-hosted — and you might want to look at [NocoDB]... - Source: Hacker News / 12 months ago

There's also Grist (https://getgrist.com) - SQLite based with Excel-like formulae in Python. - Source: Hacker News / about 1 year ago

The only things I have found are Baserow which is basically the best one I've found so far, but it doesn't allow search between columns, importing columns from other tables and I can't restrict users from editing and perhaps corrupting the data. NocoDB doesn't import CSVs and seems to be buggy for some reason. Grist allows restriction for people but it does not have as good filters as Baserow and I can't save my... Source: about 2 years ago

Phenomenal capabilities exceed Excel, Google Sheets, Airtable. Allows app-like views on spreadsheet data, with drag-n-drop configuration. Supports Python-based formulas with familiar Excel functions. Access rules allow sharing a single row or any subset of data. Open-source, and can be self-hosted. https://getgrist.com. Source: about 2 years ago