Import CSV with FeedMe - multiple categories I'm attempting to use FeedMe to import a CSV list of entries exported from Google Sheets. I have a column labeled &quot;Categories&quot; and an entry with category1,category2 as the value. I set up the feedMe job pointing to the CSV and the categories field to point to this column. However it is not importing/creating two categories (the expected behavior)rather it is just creating one category  with the name &quot;category1,category2&quot; -- am I doing something wrong as far as how to list out multiple categories in CSV? Can Feedme handle a comma separated list like this?
If I convert the sheet to a json, it produces: &quot;Categories&quot;: &quot;Category1, Category2&quot; which does not work either - however if I edit the json to be &quot;Categories&quot;: [&quot;Category1&quot;, &quot;Category2&quot;] that works - but manually editing it is not really an option on my final spreadsheet as it will have over a 1000 entries.
If there's an easy way to convert the sheet/csv to correct Json I'd be open to that too.
Any help would be appreciated.
You can do this with CSV by setting a dataDelimiter in a config/feed-me.php files (see docs).
If you set the dataDelimiter to be | for example, then your CSV could be:
&quot;title&quot;, &quot;Categories&quot;
&quot;Some title&quot;, &quot;Category1|Category2&quot;

Doing this should let you import multiple categories from CSV.