Configurable list download to excel - all data in one colum

  • tracyalexander
    Asked on April 1, 2016 at 5: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

     

    Configurable list download to excel   all data in one colum Image 1 Screenshot 20

     

  • Elton Support Team Lead
    Replied on April 1, 2016 at 6: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.

    Configurable list download to excel   all data in one colum Image 1 Screenshot 20

    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!