Separate the submission data on Excel exported data

  • Profile Image
    Asked on January 29, 2020 at 07:48 PM

    Hello, Is there a way to better separate to data within the excel export. Current result below

    [Quantity: 15, Month: 7, Year: 19Quantity: 8, Month: 6, Year: 19]

    Currently no separation of the two sets of data

    This is a re-post of a comment on How to Set Up the Configurable List Widget

  • Profile Image
    Answered on January 29, 2020 at 09:31 PM

    Unfortunately this how the exported to Excel data of configurable list widget work for now.

    Because the widget is considered a single field, all the data in the widget will be contained also on within a single column/cell in the Excel submission data.

    The option you can do is to separate the data using your Excel application. You can use the Split text into different columns function in Excel.

  • Profile Image
    Answered on February 15, 2020 at 07:07 AM

    Just in case you'd like to try this option for your next forms, you can use Input Table instead. It will create one column in the spreadsheet for each cell of the Input Table. Though note that it cannot give the dynamic number of rows that a configurable list provides.