There are lots of guis that make editing a sqlite db almost as easy as editing a spreadsheet.

Didn't know about that, thanks! Might use some in my own work.

A sqlite db is just a file. So at that level it is exactly like a spreadsheet. It's just a much more powerful storage format. But for the app opening it it can be presented much like a spreadsheet.