open-refine-multi-value-templating.md

Sample data -- the multi-value connector is the plus sign (+):

col1	col2	col3
one	blah	scott
two	blah	scott+jessica
three	blah	jessica+scott

Under templating, use this if-statement in your row template:

   {
      "col1" : {{jsonize(cells["col1"].value)}},
      "col2" : {{jsonize(cells["col2"].value)}},
      "col3" : {{if((cells["col3"].value.contains("+")),(jsonize(cells["col3"].value.split("+"))),(jsonize(cells["col3"].value)))}}
    } 

The result is valid JSON:

{
  "rows" : [
    {
      "col1" : "one",
      "col2" : "blah",
      "col3" : "scott"
    },
    {
      "col1" : "two",
      "col2" : "blah",
      "col3" : ["scott","jessica"]
    },
    {
      "col1" : "three",
      "col2" : "blah",
      "col3" : ["jessica","scott"]
    }
  ]
}