convert complex/nested json object to excel table

Question

I've got a nested json object. For the sake of simplicity:

data = {'key1': 1, 'key2': 2, 'key3': {'nestedKey1': 3, 'nestedKey2': 4}}

A real object is bigger but the point is that it's a nested one. Values may be strings, numbers or other objects. Now I need to get an excel table that (for this specific json would look like this):

|----------------------------------------
| key1 | key2 |           key3          |
|      |      |--------------------------
|      |      | nestedKey1 | nestedKey2 |
|----------------------------------------
|  1   |  2   |     3      |      4     |
|----------------------------------------

Other formats are also acceptable. But this one is most preferable. How do I do that?

Cpt Kitkat · Accepted Answer · 2019-06-18 08:48:20Z

0

You can convert online(don't know the size limit they allow)

Although it is not exactly in the same format you expect but it is very much similar, you can do little bit of modification from the output you get here. Here is a sample screenshot of the output I got when I inserted your json.

Stackoverflow

If you want to write a Service on your own then you can refer to this question on SOF. It is something similar to what you want and it is written in JavaScript.

JQuery

Here is a JQuery script on this page for converting JSON to excel.

Working Stackblitz

edited Jun 18, 2019 at 8:48

answered Jun 18, 2019 at 4:59

Cpt Kitkat

1,4024 gold badges36 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

GoBear Over a year ago

No, I can't do that, I need to write a service that does just that. I tried using 'xlsx' but I can't figure out how to make it write the table in the right format

Cpt Kitkat Over a year ago

You need to write it in which language. I mean which tools and framework are you working on ?

GoBear Over a year ago

Ah, sorry I forgot to mention it. The framework is angular, the language is typescript.

Cpt Kitkat Over a year ago

@GoBear Ihave updated my answer have a look at the stackblitz example. I think that should be sufficient for your requirement

Akriti Anand · Accepted Answer · 2020-09-26 18:17:38Z

0

I have written a python package that you can use to convert complex json into excel. https://github.com/akritianand/JsonToExcel

answered Sep 26, 2020 at 18:17

Akriti Anand

1861 gold badge4 silver badges17 bronze badges

Collectives™ on Stack Overflow

convert complex/nested json object to excel table

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related