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.


"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.

  • You have a problem with the second screenshot. – harrymc Sep 18 '18 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 '18 at 11:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.