Answers.Body: <p>The correct answer is to put the text</p>
  
  <pre><code>Red,Blue
  </code></pre>
  
  <p>without quotes in a single cell of the CSV that you're trying to import.</p>
  
  <p>You also need to make sure that the field you're importing into allows multiple values to be set, not just a single value.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-06-24T19:04:32.203Z
Answers.Text: I'd like to note that inside the CSV, it will look like `"Red,Blue"`, if you enter it as `Red,Blue` in your spreadsheet. So everyone might want to keep that in mind if they are editing actual CSV files.
Answers.UserDisplayName: Kurt Leadley
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-06-23T05:16:51.000Z
Answers.LastActivityDate: 2016-06-23T05:16:51.000Z
Answers.UserDisplayName: Andrew Cormick-Dockery
Body: <p>I have setup a custom field with 4 options. In my spreadsheet I've tried various combinations of columns which would allow me to import data and select required options. But nothing is working! </p>
  
  <p>Custom Data - Checkbox Options - Red, Blue, Green, Black</p>
  
  <p>In my CSV file I've tried combinations such as</p>
  
  <p>"Red,Blue"</p>
  
  <p>'Red,Blue'</p>
  
  <p>Red,Blue</p>
  
  <p>Is it possible to import data for check box custom data?</p>
  
  <p>Thanks</p>
  
  <p>Alan</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-06-22T17:47:13.580Z
Comments.Text: Is your data in multiple columns or one column?  Do your CSV and Civi fields match?  See http://civicrm.stackexchange.com/q/8407/105 and http://civicrm.stackexchange.com/q/4333/105
Comments.UserDisplayName: Allen Hutchison
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-06-24T12:53:05.053Z
Comments.Text: Thanks for reply Allen. Got in working.
  Red,Blue in 1 column
  Multi Value Option turned on
  I only had check box labels setup. Once I added the values Red, Blue etc then it worked. Obvious when you see it!!!
Comments.UserDisplayName: user3045777
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-06-24T15:26:13.827Z
Comments.Text: Glad you got it sorted out!
Comments.UserDisplayName: Allen Hutchison
Tags: <custom-fields><import>
Title: Importing Custom Field Checkbox Data
ThreadText: # Importing Custom Field Checkbox Data
  
  (Asked by: username_0 on 2016-06-22)
  
  I have setup a custom field with 4 options. In my spreadsheet I've tried various combinations of columns which would allow me to import data and select required options. But nothing is working!
  
  Custom Data - Checkbox Options - Red, Blue, Green, Black
  
  In my CSV file I've tried combinations such as
  
  "Red,Blue"
  
  'Red,Blue'
  
  Red,Blue
  
  Is it possible to import data for check box custom data?
  
  Thanks
  
  Alan
  
  **Tags:** custom-fields, import
  
  > **Comments:**
  > **username_1**: Is your data in multiple columns or one column?  Do your CSV and Civi fields match?  See http://civicrm.stackexchange.com/q/8407/105 and http://civicrm.stackexchange.com/q/4333/105  
  > **username_0**: Thanks for reply username_1. Got in working. Red,Blue in 1 column Multi Value Option turned on I only had check box labels setup. Once I added the values Red, Blue etc then it worked. Obvious when you see it!!!  
  > **username_1**: Glad you got it sorted out!  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2016-06-23. Score: 5 | Accepted answer
  
  The correct answer is to put the text
  
  ```
  Red,Blue
  
  ```
  
  without quotes in a single cell of the CSV that you're trying to import.
  
  You also need to make sure that the field you're importing into allows multiple values to be set, not just a single value.
  
  > **Comments:**
  > **username_3**: I'd like to note that inside the CSV, it will look like `"Red,Blue"`, if you enter it as `Red,Blue` in your spreadsheet. So everyone might want to keep that in mind if they are editing actual CSV files.  
  
  ---
  
  