how to separate data

  • Profile Image
    julianngaudette
    Asked on August 08, 2019 at 12:41 PM

    I need to separate the sizes, colors, etc. from my excel. It loaded all the information into one cell in my excel document.


    https://www.jotform.com/91776086014157

    Screenshot
  • Profile Image
    denis_calin
    Answered on August 08, 2019 at 01:50 PM

    Hi Juliann!

    I can see that the products are not separated intuitively in the CSV file, but if you download the submission data as the Excel file, each product will be on its own separate line (tested on Mac OS):

    1565286098Screen Shot 2019-08-08 at 10.4

    If you still would like to use the CSV file, you can manually edit each cell to make it more readable, like so:

    1565286590Screen Shot 2019-08-08 at 10.4

    Please let us know if you have any questions.