How to separate the Spreadsheet widget's data to columns when exported to Excel?

  • Profile Image
    Sthembumusa
    Asked on August 29, 2019 at 11:50 AM

    I want the data collected by this preadsheep to be excell in the submission. 1567093182Screenshot_20190829-173802.jpg

    Currently, when i download the excel it gives the data from this form in 1 culumn instead of this above format 

    Screenshot
  • Profile Image
    JohnRex
    Answered on August 29, 2019 at 12:57 PM

    Unfortunately, there is no way to export the information entered into the Spreadsheet widget to Excel file as rows and columns. Every form field's entry is being put into one cell only.

    A workaround for that is to use the Excel's Text-to-Columns feature after you export the submission to an excel file. Please refer to this guide about this feature:

    https://www.excel-easy.com/examples/text-to-columns.html

    Here's a quick demo for that:

    1567097807texttocolumn.gif