Answers.Body: <p>The data for importing options needs to be in a single cell. So if your field is COLOUR, then you need a single column for that data in your import file, and you need data such as </p>
  
  <ul>
  <li>red,blue,orange</li>
  <li>red,orange</li>
  <li>etc</li>
  </ul>
  
  <p>If you need to concatenate your data you may end up with examples like below, but they should also import fine</p>
  
  <ul>
  <li>red,blue,orange</li>
  <li>red,,orange</li>
  <li>,blue,orange</li>
  <li>,,orange</li>
  <li>red,,</li>
  </ul>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-18T19:39:39.940Z
Answers.LastActivityDate: 2015-12-18T19:39:39.940Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>Right now I have a custom data set set up that has 3 custom fields inside of it. Inside each custom field is a list of options that can be checked. (checkbox is the option)</p>
  
  <p>In my spreadsheet that I import I have the correct columns and appropriate values in for the options I need to be checked for each contact. </p>
  
  <p>So lets say here are my 3 custom fields with 3 different options (example):
  Custom field A contains blue, red, and white in that exact order on the spreadsheet. Custom field B contains purple, orange, yellow in that order on the spreadsheet. Custom field C contains cow, cat, dog in that order on the spreadsheet. </p>
  
  <p>If Example Contact 1 has blue marked, purple marked, and cow marked it will check those off appropriately.</p>
  
  <p>If Example contact 2 has blue marked, yellow marked, and cat marked only blue will import.</p>
  
  <p>I did multiple tests and have come to the conclusion that only the first value of each custom field will import if it is marked. Anything else marked will not be imported.</p>
  
  <p>Is there something I can do to fix this?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-12-18T00:13:47.010Z
Comments.Text: how does the data look in your import? ie is blue in one column and red in another, or is it in one cell with commas ie blue,red. I would expect the latter to work, and the former to fail. if that is the case i will reset this as answer
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-12-18T14:19:04.780Z
Comments.Text: blue in one column, red in another, and so on. So if I separate by commas in one column rather than a different column per item it should work? If that is true, will it check the appropriate things? Does it have to be in a specific order?
Comments.UserDisplayName: SproutMediaLab
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2015-12-18T19:21:31.437Z
Comments.Text: I tested it with commas in one cell and it worked, thank you for that suggestion!
Comments.UserDisplayName: SproutMediaLab
Tags: <contacts><custom-fields><import>
Title: checkbox import problems
ThreadText: # checkbox import problems
  
  (Asked by: username_0 on 2015-12-17)
  
  Right now I have a custom data set set up that has 3 custom fields inside of it. Inside each custom field is a list of options that can be checked. (checkbox is the option)
  
  In my spreadsheet that I import I have the correct columns and appropriate values in for the options I need to be checked for each contact.
  
  So lets say here are my 3 custom fields with 3 different options (example):
  Custom field A contains blue, red, and white in that exact order on the spreadsheet. Custom field B contains purple, orange, yellow in that order on the spreadsheet. Custom field C contains cow, cat, dog in that order on the spreadsheet.
  
  If Example Contact 1 has blue marked, purple marked, and cow marked it will check those off appropriately.
  
  If Example contact 2 has blue marked, yellow marked, and cat marked only blue will import.
  
  I did multiple tests and have come to the conclusion that only the first value of each custom field will import if it is marked. Anything else marked will not be imported.
  
  Is there something I can do to fix this?
  
  **Tags:** contacts, custom-fields, import
  
  > **Comments:**
  > **username_1**: how does the data look in your import? ie is blue in one column and red in another, or is it in one cell with commas ie blue,red. I would expect the latter to work, and the former to fail. if that is the case i will reset this as answer  
  > **username_0**: blue in one column, red in another, and so on. So if I separate by commas in one column rather than a different column per item it should work? If that is true, will it check the appropriate things? Does it have to be in a specific order?  
  > **username_0**: I tested it with commas in one cell and it worked, thank you for that suggestion!  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2015-12-18. Score: 4 | Accepted answer
  
  The data for importing options needs to be in a single cell. So if your field is COLOUR, then you need a single column for that data in your import file, and you need data such as
  
  * red,blue,orange
  * red,orange
  * etc
  
  If you need to concatenate your data you may end up with examples like below, but they should also import fine
  
  * red,blue,orange
  * red,,orange
  * ,blue,orange
  * ,,orange
  * red,,
  
  
  ---
  
  