Skip to main content
  • 7,238 Posts
  • 26,620 Replies
7238 Posts
How can I create a nested JSON from an Excel- or CSV-file?

I have a Excel-file with the following content: group1group2group3nameinfoGeneralNation Philinfo1GeneralNation Kareninfo2GeneralMunicipality Billinfo3GeneralMunicipality Paulinfo4SpecificProvince Patrickinfo5SpecificProvince Maikelinfo6SpecificProvinceGovernanceMikeinfo7SpecificProvinceGovernanceLukeinfo8SpecificDistrict Mariainfo9SpecificDistrict Davidinfo10 The attributes can be adjusted it is a Excel-file; I create the file myself.I would like to automatically create a nested JSON file. This should look like this:  "name": "Overview",    "children": [{        "name": "General",             "children": [                { "name": "Nation",                    "children": [                        {"name": "Phil", "info": "info1"},                        {"name": "Karen", "info": "info2"}                     ]                },

Badge Winners

Show all badges

Community Stats

32,448
Posts
123,298
Replies
40,601
Members