Can you export into a CSV or Excel file with commas separating the answers within each cell?

  • Profile Image
    Justin 
    Asked on June 24, 2020 at 08:31 PM

    For questions that allow multiple responses (such as a checkbox), I would like the csv export to show responses within each cell with commas after each item the form response checked off. For example, if the form question is:

    What are your favorite colors?

    [] Red

    [] Blue

    [] Green

    And if someone responds that they like all three colors by checking them all off, I would like the export for that cell to show:

    Red, Blue, Green

    Currently, I see this within a cell when exporting the form responses:

    Red

    Blue

    Green

  • Profile Image
    Mike_G
    Answered on June 24, 2020 at 09:45 PM

    I would like to apologize for any inconvenience, but there is no option to update the output of the Multiple Choice field in the exported Excel/CSV file within the form.

    A workaround is to pass the value to a Short Text field in the form using conditions and refer to that Short Text field in the Excel/CSV file.

    Reference Guide: How-to-Insert-Text-or-Mathematical-Calculation-into-a-field-using-a-Condition

    1593049427zt200624_214328.gif

    Feel free to let us know if you need any further assistance.