Mar 23 2022 07:25 AM
Hello,
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.
Title | Category | Keywords |
Healthcare: It’s Down to Our Genes | Education | Advocacy, Cost Management, Pharmacy, Blog |
Whenever I export I am missing the [ ] brackets and it's not formatted correctly like the json example above. Thanks for any help.