Excel and CSV exported submissions - answers going to same column

  • Profile Image
    yanaluae
    Asked on August 28, 2015 at 11:52 AM
    3. For fields where multiple check-boxes are selected - each checkbox should be a separate export column upon export rather than one column with the fields separated by ';' (semi-colons). This would make data analysis upon export much simpler.
  • Profile Image
    Boris
    Answered on August 28, 2015 at 12:31 PM

    I am sorry if this may not look intuitive to your workflow, but such an implementation would unfortunately be incompatible with third-party services and integrations, such as the Google Spreadsheet integration as an example, and would pose significant difficulties for many common tasks.

    The reason is that for programmatic data manipulation, field columns and their headers should remain consistent. If we were inserting new columns in the spreadsheet for each of the multiple answers that are selected to a single question, that would make the spreadsheet columns variable and unpredictable, preventing many functions that depend on having solid position of data (such as formulas depending that answers to specific questions are in column D for example, or Import Range functions for importing data from one spreadsheet into another).

    For this reason, answers to a single field/question always go to one column. If you wish to split data from one column to multiple columns, you can create empty columns after the initial column, and use the Text To Columns function:

    https://support.office.com/en-us/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7

    I hope this helps. Please let us know if you need further assistance.