2-Dimensional Configuration Files

I often find myself in this situation: I get specs in the form of a table, or several tables, from a non-technical person. This is usually Excel or Word. Because of the messiness of reading MS files, I’ll translate those tables into nested YAML files. Then I get updated specs with a new schema and now I basically need to remake the YAML files from scratch.

A table is a great way to store information about the details of several related things… And I always feel a little silly making these nested configs that are difficult to edit and much less readable. A CVS is … better? But it’s a whole other can of worms.

All that to say, is there a format/tool with the computer readability like YAML but that can be viewed and edited by a human as a table? Or a GUI to view and edit YAML/JSON files as a table?

4 Likes