Pivot table text to yaml

Here’s a related thread that explains this better than I can:

Essentially, an Excel Pivot table allows me to easily view data, even though the raw data is just text.
It’s nice to navigate the data in Excel, but it’s not nice to edit data.

a csv to yaml converter can convert between these things.

  1. is there a workflow that integrates these 2 ways of looking at things?

  2. what keywords are related to this?

The main problem I’m trying to solve is that I can understand excel, but yaml is less visual, so I forget it, and basically can’t get my head around how to lay things out. The limitation of Excel’s grid gives me some structure to tbink inside.

Here a link to a plugin that goes in the other direction:

obsidian frontmatter