Answers.Body: <p>I do not know of anything that can be done via CiviCRM UI to address this, so I think you would be better to manipulate it after exporting.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-13T20:40:02.213Z
Answers.LastActivityDate: 2016-03-13T20:40:02.213Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>Does anyone know how to export a multiple choice field into a spreadsheet in a way that filters each response into a different column?</p>
  
  <p>For example, a field has options:</p>
  
  <ol>
  <li>apple</li>
  <li>banana</li>
  <li>pineapple</li>
  </ol>
  
  <p>A contact record has "apple" and "banana" selected for the field.</p>
  
  <p>In exporting their record, I would like three columns to represent the data in the field, one column for apple, one for banana, one for pinapple.</p>
  
  <p>Is there a way to do this in CiviCRM, or would I need to export and then run a script in Excel?</p>
  
  <p>Thanks!</p>
  
Tags: <custom-fields><export>
Title: Exporting multiple choice fields
ThreadText: # Exporting multiple choice fields
  
  (Asked by: username_0 on 2016-03-11)
  
  Does anyone know how to export a multiple choice field into a spreadsheet in a way that filters each response into a different column?
  
  For example, a field has options:
  
  1. apple
  2. banana
  3. pineapple
  
  A contact record has "apple" and "banana" selected for the field.
  
  In exporting their record, I would like three columns to represent the data in the field, one column for apple, one for banana, one for pinapple.
  
  Is there a way to do this in CiviCRM, or would I need to export and then run a script in Excel?
  
  Thanks!
  
  **Tags:** custom-fields, export
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-03-13. Score: 1
  
  I do not know of anything that can be done via CiviCRM UI to address this, so I think you would be better to manipulate it after exporting.
  
  
  ---
  
  