Unreadable content when opening CSV file download of form submission data

  • Profile Image
    ajardel
    Asked on April 26, 2014 at 08: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"?)

  • Profile Image
    EltonCris
    Answered 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!