I have 2 fields in my Zoho Creator form, called Form1:

FieldA is a plain text field which contains names (example: Apple, Banana, Grapes)

FieldB is a Lookup field, which is a multiple select list. This looks up a name from Form2 (example: Red,Yellow,Green,Delicious,Disgusting).Visually, this is displayed in the Zoho view as a comma-separated list for that field.

My Excel file that I use for the Zoho Migration Tool looks like this (the pipes represent column separators):

The Zoho Migration tool runs and says the import was successful, but the data is not updated. How do I need to format my Excel file format so I can import multiple values into FieldB?