I am trying to set up an excel sheet to collect data that I will be converting to a JSON for import. In Excel how do I format so multiple search attributes export to a json with this format? I’ve tried adding the multiple attributes into one cell using commas which doesn’t work. I’m not that much of an excel person. Thanks for any help. How do those brackets translate from Excel under the multiple options for “actors”.
“title”: “Mystic River”,
“director”: “Clint Eastwood”,
“actors”: [“Sean Penn”, “Tim Robbins”, “Kevin Bacon”, “Laurence Fishburne”]