-
SthembumusaAsked on August 29, 2019 at 11:50 AM
I want the data collected by this preadsheep to be excell in the submission.
Currently, when i download the excel it gives the data from this form in 1 culumn instead of this above format
-
John Support Team LeadReplied 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: