Just as an example of the tree<->table issue:

If you input this JSON tree:

{ "Color": "Blue", "Part": [ { "Type": "A", "Number": [ "1", "2" ] }, { "Type": "B", "Number": [ "1" ] } ]

It can be converted to a table as:

Color,Part.Type,Part.Number

Blue,A,1

Blue,A,2

Blue,B,1

Which is fine is you then want to output as Excel, CSV etc. But if you then output that back to JSON you get:

[ { "Color": "Blue", "Part": { "Type": "A", "Number": "1" } }, { "Color": "Blue", "Part": { "Type": "A", "Number": "2" } }, { "Color": "Blue", "Part": { "Type": "B", "Number": "1" } } ]

Which is conceptually equivalent, but less compact (similarly for XML). I am hoping to fix this issue. But if anyone has any links to how to unflatten a table into a compact tree, I'm all ears.