Configurable list download to excel - all data in one colum

  • Profile Image
    tracyalexander
    Asked on April 01, 2016 at 05:21 PM

    The configurable list is brilliant but when I download to excel it is a terrible let down as all the data from the configurable list is in one colum.  

    Is there anyway this data can be split up.

    It looks great in the PDF download but the download to spreadsheet is such a powerful tool and the info is just useless in the current form as I can filter/sort/manipulate it

    Thanks v much

     

     

  • Profile Image
    EltonCris
    Answered on April 01, 2016 at 06:08 PM

    Since they are on a single field or column as shown also on the submissions data grid, I'm afraid there's no way they can be separated into multiple columns on Excel export. This also minimizes the server process during the compilation of data.

    The workaround is to use the Excel feature if you want to separate them into columns. Here's one that will work https://www.jotform.com/answers/409905.

    Hope this still helps!