Responses exported to google sheets are populated all in one cell.

  • Jon
    Asked on January 9, 2020 at 3:49 AM

    Responses exported to google sheets are populated all in one cell. Is there a way to parse the response such that each field is a column and each row and one row in the configurable list?

  • Jed_C
    Replied on January 9, 2020 at 6:38 AM

    Unfortunately, configurable list widget will have only a single column header when viewed on spreadsheet app like Excel or Google Spreadsheet.

    But spreadsheet do have function that will allow you to separate each entity in column to multiple column. Use the function Text-to-Column in spreadsheets application.

    You can review the guide in the link below on how to use the Text-to-Column feature.

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

    Let us know if you have any questions or if you need further assistance.