orderable list widget, is it possible to export data to multiple cells instead of a single cell?

  • trustinginduetime
    Asked on August 3, 2018 at 12:24 PM

    We have a widget that allows those who register to put their top priority in order from highest to least. The problem is when I go to export it exports all to one cell which then makes it hard to analyze the data. Is it possible to export these to separate cells?
    https://www.jotform.com/build/80506188584161

    For example, 1. Anxiety in cell A1 and then 2. Emotional Support in B1, etc etc?

    Jotform Thread 1544007 Screenshot
  • David JotForm Support
    Replied on August 3, 2018 at 1:27 PM

    Due to the programmatic way our system works, including generation of Excel files, each form field / form question always goes to its own cell in the Excel or CSV file.

    This applies to all form fields, even those that accept multiple inputs - such as Configurable List widget, Infinite List widget, or a regular Matrix field. Each widget or form field is technically one field, no matter how many "sub-fields" it may have, so all the data collected through that form field goes to one cell in the Excel output.

    Excel file must have a predictable number of columns, where it must know in advance which Excel column will hold data from which form field. If that weren't the case, the variable number of possible columns from the Configurable List widget would cause all the columns that come after Orderable List to be placed on a different column in each row.

    When our system is generating the Excel file, it must generate it with each form field corresponding to a single cell in the sheet. If you want to split it up later on into multiple other columns/cells, you may want to use the Text-to-Columns function of your Excel software:

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