Exported CSV is not displaying properly in Excel

  • Profile Image
    kdmirandaa
    Asked on January 24, 2018 at 01: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?

    Screenshot
  • Profile Image
    Jan
    Answered on January 24, 2018 at 02: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.

  • Profile Image
    kdmirandaa
    Answered on January 24, 2018 at 09: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,

  • Profile Image
    EltonCris
    Answered on January 25, 2018 at 01: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