excel-to-json
excel-to-json copied to clipboard
Remove opening and closing []
Is it possible to remove the opening and closing square brackets?
Yes, please!
Do you want just one object? In that case you could use a single object sheet.
My output should be like this:
{
"Platform1" :
[
{
"Locale" :
{
"pt-BR" : "Localization 1",
"en-US" : "Localization 2"
},
"URL" : "http://someurl.com",
"Type" : 1
},
{
"Locale" :
{
"pt-BR" : "Localization 1",
"en-US" : "Localization 2"
},
"URL" : "http://someurl.com",
"Day" : 11,
"Month" : 10,
"Year" : 2021,
"Type" : 2
}
],
"Platform2" :
[
{
"Locale" :
{
"pt-BR" : "Localization 1",
"en-US" : "Localization 2"
},
"URL" : "http://someurl.com",
"Type" : 1
},
{
"Locale" :
{
"pt-BR" : "Localization 1",
"en-US" : "Localization 2"
},
"URL" : "http://someurl.com",
"Day" : 11,
"Month" : 10,
"Year" : 2021,
"Type" : 2
}
]
}
I cannot use single object sheet because I need the others tab to nest the content. Also, do you have any idea on how to achieve
"Platform1" :
[
I think what you want is currently not possible (unless you can combine the single object sheet and the keyed/list sub properties somehow but I doubt it). Removing the outer brackets would produce invalid JSON so that is also not supported.
My best advise (because the tool is no longer maintained) is to either fork it and send a pull request with new features, or use an external tool (like jq
) to tweak the JSON after it is produced.