Looking to parse cell data in an excel report

  • jwardwel
    Asked on April 6, 2018 at 12:49 PM

    Hi,

      I'm using a configurable list widget as a calendaring option because it allows me to create recurring bookings.  When I create an excel report of the form submissions the data results for the "Delivery Date" question are listed all in one cell so I can't sort to look at just one particular day's deliveries.  Is it possible with one of your apps to create an excel report that will break out each delivery into his own row in excel so that I can sort chronologically or I can filter on a certain day and see all of that day's deliveries only?  <Pic attached>

    Thanks,
    Jeff


    Jotform Thread 1437539 Screenshot
  • Richie JotForm Support
    Replied on April 6, 2018 at 1:41 PM

    Unfortunately the configurable list or any other widgets with multiple options will normally be treated as as single field when exported to spreadsheet.

    Looking to parse cell data in an excel report  Image 1 Screenshot 30

    However, you can use the Split text to column by Google Sheets to separate the fields.

    Looking to parse cell data in an excel report  Image 2 Screenshot 41

    Hope this information helps.

    Please let us know if we can be of further assistance.