Question on Excel to nested Json creation

[kkchan189]

I have a big issue in using the CSV to Json tool. My requirement is to use Excel file to build nested Json and I cannot find the guide to do it.

My requirement is something like this (a nested json of list, "listing line"):

{
"order": [
{
"id": "1",
"due_date": "20220624",
"description": "large",
"listing line": [
{
"price": "20"
"item code": "ABC123"
"quantity": "5"
"total": "100"
},
{
"price": "120"
"item code": "ddd333"
"quantity": "1"
"total": "120"
}
]
},
{
"id": "2",
"due_date": "20220624",
"description": "small",
"listing line": [
{
"price": "50"
"item code": "YYY655"
"quantity": "5"
"total": "250"
}
]
}
]
}

Please advise if it is possible to do so on your platform.

Please help and thanks a lot...

Thanks..
KK

[kkchan189]

please advise how the excel file be set up as well.