Answers.Body: <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>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-11-12T14:07:35.180Z
Answers.Text: This worked - thank you!
Answers.UserDisplayName: user2945489
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-11-05T07:11:53.627Z
Answers.LastActivityDate: 2020-11-05T07:11:53.627Z
Answers.UserDisplayName: Oli
Body: <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>
  
Tags: <plugin-feedme>
Title: Import CSV with FeedMe - multiple categories
ThreadText: # 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](https://docs.craftcms.com/feed-me/v4/get-started/configuration.html)).
  
  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!  
  
  ---
  
  