I'm building an internal tool and want a spreadsheet UX, not a full database stack

If you want a spreadsheet UX without turning it into a full database product, the sweet spot is usually:

What you probably want

A tool that feels like:

• editable grid
• sorting / filtering
• formulas or computed fields
• linked records
• views per team/use case
• basic permissions
• import/export to CSV/XLSX

But not:

• custom schema migrations
• complex joins everywhere
• ORM-heavy backend
• full-blown reporting/BI layer

Good architecture options

1) Spreadsheet-first product layer on top of a simple datastore

Use:

• Postgres as the backend
• a thin API
• a grid UI library

This gives you spreadsheet-like interaction while keeping the data reliable.

Good when you need:

• collaboration
• auditability
• permissions
• data consistency

2) Use an existing spreadsheet-like app framework

If you want to ship faster, look at:

• Airtable-like platforms
• Retool / Appsmith / Budibase
• NocoDB / Baserow for spreadsheet-style CRUD

Good when:

• internal tool
• low/medium complexity
• you don’t want to build the editor from scratch

3) Embed a grid component and keep the backend simple

Frontend:

• AG Grid
• Handsontable
• React Data Grid
• Glide Data Grid

Backend:

• CRUD endpoints
• search/filter/sort
• maybe version history

Good when:

• you want a custom UX
• need spreadsheet feel without spreadsheet semantics

Key design choice

Decide whether cells are:

• just editable data fields
  or
• true spreadsheet cells with formulas/references

If you only need internal ops workflows, I’d strongly recommend editable fields + computed columns, not full Excel-style formulas everywhere. That’s much easier to maintain.

Minimal “not a database stack” stack

A practical lightweight setup:

• Frontend: Next.js + AG Grid (or Handsontable)
• Backend: Node/Express or Next API routes
• DB: Postgres
• Auth: Clerk/Auth.js/Supabase Auth
• Deploy: Vercel/Fly/Render
• Extras: row-level permissions, CSV import/export

If you want the fastest path

Use:

• Retool if it’s purely internal and you need it now
• NocoDB/Baserow if you want Airtable-like behavior self-hosted
• AG Grid + Postgres if you need custom but still lightweight

Rule of thumb

• Need custom workflows + internal users only → Retool/Appsmith
• Need Airtable-like product for teams → Baserow/NocoDB
• Need polished custom UX → build with a grid component

If you want, I can recommend a specific stack based on:

1. number of users
2. whether it needs collaboration
3. whether formulas are required
4. self-hosted vs managed