Excel or CSV reports are not generated clean

  • Profile Image
    AA_C
    Asked 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
    Kiran
    Answered 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
    AA_C
    Answered 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
    Kiran
    Answered 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!