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.

2
  • You have a problem with the second screenshot.
    – harrymc
    Sep 18, 2018 at 10:13
  • What is the problem? it shows 4 cells, the way I want them formatted. Its surely not the worlds most beautiful snip ...
    – Isaac
    Sep 18, 2018 at 11:01

0

You must log in to answer this question.

Browse other questions tagged .