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

    Excel or CSV reports are not generated clean

    Asked by AA_C on February 09, 2016 at 10:21 PM

    One thing of note is that I find the reports generator tool generates a much cleaner excel sheet then using the view submissions,excel option.

    Same for the csv option there, it can make a very messy file also, mine were useless.

    I haven't tried the Reports csv option yet.

    Perhaps its just me... Just my 2 cents... wait we don't have pennies in Canada any more so I guess a nickles worth then.

    Robert

  • Profile Image
    JotForm Support

    Answered by Kiran on February 09, 2016 at 10:26 PM

    The reports generated using the option from Submissions view or Reports sections should be the same. However, we have some additional optional available from Reports to choose the fields to be exported as per your requirement. Whereas the export option from the submissions view shall export all the fields by default. 

    If you can let us know the form ID that you are experiencing the issue, we would be happy to take a look and provide you with necessary assistance.

    Thank you! 

  • Profile Image

    Answered by AA_C on February 09, 2016 at 11:03 PM

    One thing I found in particular with csv is it created a column for every word. It drove me nuts.

    For example formID=52934584917973. I had very good success using the Reports section vs the submissions. I was quickly able to create a MySQL table. Using the alternative method was very messy.

    Robert

  • Profile Image
    JotForm Support

    Answered by Kiran on February 10, 2016 at 07:40 AM

    Glad to see that you were able to create the table by using the report from Reports section. I have tried to download the submissions both from Reports and submissions view and see that the both reports have the same column count. Since Excel reports are properly formatted unlike CSV due to the text format type, CSV report might not be looking clean. If you are referring to something different or need any further assistance, please let us know.

    Thank you!