What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Unreadable content when opening CSV file download of form submission data

    Asked by ajardel 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
    JotForm Support

    Answered by EltonCris 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!