I have a JSON array , how can i represent it in a spread sheet

{
"name":"John",
"age":30,
"cars":[ "Ford", "BMW", "Fiat" ]
}

In excel it is

r/webdev - How to represent JSON array in excel sheet

cars array with dash portion

Another way of representing is comma separated (But comma can be in the text also)

r/webdev - How to represent JSON array in excel sheet

comma separated array

Another Way is separating with <space> |||<space>

r/webdev - How to represent JSON array in excel sheet

Dash separated

Any other way or any standards?



Source link

Write A Comment