The [[De Facto]] tool for most people when doing [[Exploratory Data Analysis]] is [[Spreadsheet|Microsoft Excel]]. Its power for flexibly handling data in a user-friendly, approachable way is only rivaled by other [[Spreadsheet]] apps that have come after it & largely imitated it. Excel is incredibly good for [[Tabular Data]]. Tabular data is only *one* kind of data, though. > [!tldr] There is no "Excel" for non-tabular data - [[CSV]]-like data → [[Spreadsheet|Excel]] The closest things I've found -- and none of them are close - [[JSON]]-like data → [JSON Crack](https://jsoncrack.com/editor) - [[Graph]]-like data → [Gephi](https://lite.gephi.org/v1.0.2/) There's no utilities like *formulas* and the *fill handle*. Everything I've ever found is aimed at making the **read** experience better... not the **write** one. So we are stuck where the best way to edit these types of data is to do it by hand or adopt the decisions and data schemes ideated by whoever made whatever tool you're using. I had a particularly good & impressive chat with ChatGPT on this one. Most of it went to the [[Plaintext Graph Data]] note, though. **** # More ## Source - [https://gephi.org](https://gephi.org/) - Chat with ChatGPT