<p>You can do this with CSV by setting a <code>dataDelimiter</code> in a <code>config/feed-me.php</code> files (see <a href="https://docs.craftcms.com/feed-me/v4/get-started/configuration.html" rel="noreferrer">docs</a>).</p>
<p>If you set the <code>dataDelimiter</code> to be <code>|</code> for example, then your CSV could be:</p>
<pre><code>&quot;title&quot;, &quot;Categories&quot;
&quot;Some title&quot;, &quot;Category1|Category2&quot;
</code></pre>
<p>Doing this should let you import multiple categories from CSV.</p>

CC BY-SA 4.0
2020-11-12T14:07:35.180Z
This worked - thank you!
user2945489
CC BY-SA 4.0
2020-11-05T07:11:53.627Z
2020-11-05T07:11:53.627Z
Oli
<p>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 <code>category1,category2</code> 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?</p>
<p>If I convert the sheet to a json, it produces: <code>&quot;Categories&quot;: &quot;Category1, Category2&quot;</code> which does not work either - however if I edit the json to be <code>&quot;Categories&quot;: [&quot;Category1&quot;, &quot;Category2&quot;]</code> that works - but manually editing it is not really an option on my final spreadsheet as it will have over a 1000 entries.</p>
<p>If there's an easy way to convert the sheet/csv to correct Json I'd be open to that too.</p>
<p>Any help would be appreciated.</p>

<plugin-feedme>
Import CSV with FeedMe - multiple categories
# Import CSV with FeedMe - multiple categories

(Asked by: username_0 on 2020-11-04)

I'm attempting to use FeedMe to import a CSV list of entries exported from Google Sheets. I have a column labeled "Categories" 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 "category1,category2" -- 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: `"Categories": "Category1, Category2"` which does not work either - however if I edit the json to be `"Categories": ["Category1", "Category2"]` 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.

**Tags:** plugin-feedme

---

## 1 answers

### Answer by username_1 on 2020-11-05. Score: 5 | Accepted answer

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:
"title", "Categories"
"Some title", "Category1|Category2"

Doing this should let you import multiple categories from CSV.

> **Comments:**
> **username_0**: This worked - thank you!  

---

