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

  • 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 Screenshot 10

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

    Jotform Thread 1945137 Screenshot
  • John Support Team Lead
    Replied 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 Screenshot 10