Gamedev question for indies. How do folks handle their raw clumps of tabular data (e.g. big tables of monster or item stats)?

I'm currently using plain CSV files, but they're a pain to edit (openoffice is clunky, no good vscode plugins). It'd be neat to store such data in, say, google sheets or a Notion db - but those apps mostly don't work offline, and it would mean extra ad-hoc build steps to pull the data out into the game.

Any better options?

@fenomas One option would be SQLite. Pretty easy to pull the data into most languages (I've done it with C++, C#, Ruby).
But it depends on whether you find the free user interfaces to it like SQLiteStudio to be more or less clunky than openoffice.

(Plus SQL is annoying in general, at least to me)

@kojack Hmm, thanks for the thought. Not being particularly a DB person I suspect I'd find sqlite apps less convenient, but I'll give it a look!