json to excel, values of top keys should be in once cell each

0

I am looking for a non copy-paste way to convert a json file to an excel table, such that I am having the top keys in one column, and the rest in another column. Now the "rest" might be a single value, or another nested structure. Regardless, the "values" should be in a single cell each.

Example:

"fsGroup": {
    "ranges": [
        {
        "max": 65535,
        "min": 1,
        "type": "/v3/schemas/idRange"
        }
    ],
    "rule": "MustRunAs",
    "type": "/v3/schemas/fsGroupStrategyOptions"
},
"hostIPC": false,

This should look like enter image description here

I have created this example manually, I would like to have a way to import the json into excel and have it show up like this.

Isaac

Posted 2018-09-18T10:09:40.633

Reputation: 944

You have a problem with the second screenshot. – harrymc – 2018-09-18T10:13:27.257

What is the problem? it shows 4 cells, the way I want them formatted. Its surely not the worlds most beautiful snip ... – Isaac – 2018-09-18T11:01:32.850

No answers