Trivial answer is Google Docs and equivalents. Etherpad is one such equivalent that has some advantages in respecting privacy and self-hosting. Seems likely you've considered cloud-based office software and found it lacking, though.
Personal knowledge management software like Roam, Obsidian, Logseq, etc., is generally trying to offer this level of generality. Many of these variants store data in simple data types, allow several different structures (markup languages, tables with formulas, nested lists, embedding of quick drawings, and so on, with OneNote as one of the most flexible on this point), and strong searching and crosslinking. Automation is less well-supported, both in running scripts internally and in interfacing with an API. Collaboration is very... (read more)
Trivial answer is Google Docs and equivalents. Etherpad is one such equivalent that has some advantages in respecting privacy and self-hosting. Seems likely you've considered cloud-based office software and found it lacking, though.
Personal knowledge management software like Roam, Obsidian, Logseq, etc., is generally trying to offer this level of generality. Many of these variants store data in simple data types, allow several different structures (markup languages, tables with formulas, nested lists, embedding of quick drawings, and so on, with OneNote as one of the most flexible on this point), and strong searching and crosslinking. Automation is less well-supported, both in running scripts internally and in interfacing with an API. Collaboration is very... (read more)