Unreadable content when opening CSV file download of form submission data

  • ajardel
    Asked on April 26, 2014 at 8:19 PM

    hi jonathan.

    On CSV, when i set "text to columns" separate by "," for some unknown reason it makes a "new lines" and dissarm the entire table.

    Example:

    http://www.jotform.com/submissions/33173901109953

     

    if you export on CVS you will see this: (do you notice those extrange "new lines"?)

  • Elton Support Team Lead
    Replied on April 26, 2014 at 10:56 PM

    Hi,

    We have moved your question to a separate thread, FYI.

    By the way, I just downloaded your submissions to excel and I cannot reproduce the unreadable content error. The submissions are all intact and no missing as far as I can see.

    Anyway, can you give us a walkthrough on how to reproduce the new lines after performing the text to columns? Are you using MS Excel program? Maybe because there are blank lines included?

    We'll await your reply. Thanks!