'Need Excel help setting up multiple search values
I'm using Algolia to set up a search site and am trying to figure out how to enter multiple attributes into one cell. I'm converting the excel sheet to a json to upload my data. To get it to work right the json needs to be configured like this: "keywords" have multiple values.
[ { "Title": "Healthcare: It’s Down to Our Genes", "Category": "Education", "Keywords": ["Advocacy", "Cost Management", "Pharmacy", "Blog"] },
I have multiple values for keywords that need to convert. Each row will be a publication that will be searchable. How would I set up the excel cells to accomplish multiple attributes for "keywords" at export? Mine is coming out like this:
[ { "Title": "Healthcare: It’s Down to Our Genes", "Category": "Education", "Keywords": "Advocacy, Cost Management, Pharmacy, Blog" } ]
These are how the fields are set up. I am an Excel Illiterate so sorry in advance.
Whenever I export I am missing the [ ] brackets and it's not formatted correctly like the json example above. Thanks for any help.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|