Exported CSV is not displaying properly in Excel

  • kdmirandaa
    Asked on January 24, 2018 at 1:34 PM

    Hello All, I would like some help with Excel. I just got a new Lenovo laptop and I just downloaded a CSV type file but when I opened, all the data is in one row on the first column. How can I make it so every time I download all the data is on its respective row and column?

    Jotform Thread 1360796 Screenshot
  • Jan
    Replied on January 24, 2018 at 2:22 PM

    I checked your account and I did not find any forms on it. May I ask where did you download this CSV file? Please provide the form ID/URL so that we can test it.

    Normally, each form field has its own column. It is possible that your form using a widget which is why the data is showing only in 1 column.

    I suggest you also try downloading the form submissions as an Excel file. Here's a guide: How-to-Export-Form-Data-to-Excel.

    Thank you.

  • kdmirandaa
    Replied on January 24, 2018 at 9:02 PM

    I was downloading from an external website from work. they are results of a course some people took and I wanted to see the results and I had never had issues with it until today, the difference is that I was using an HP laptop and now I used a Lenovo Thinkpad,

  • Elton Support Team Lead
    Replied on January 25, 2018 at 1:43 AM

    Can you please let us know the form in question so we can check it here?

    If the form is embedded, please let us know the website URL where it is embedded.

    Thanks