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?


1 Answer 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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.