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

  • Profile Image
    Jon
    Asked on January 09, 2020 at 03: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?



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

  • Profile Image
    Jed_C
    Answered on January 09, 2020 at 06: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.