how to separate data

  • julianngaudette
    Asked on August 8, 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

    Jotform Thread 1920527 Screenshot
  • denis_calin Jotform Support
    Replied on August 8, 2019 at 1: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 Screenshot 10

    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 Screenshot 21

    Please let us know if you have any questions.