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

    Difficult data from Matrix Dynamique

    Asked by AGTech on January 26, 2017 at 03:05 PM

    For the Matrix Dynamique question the format that the data is displayed in a CSV report is very difficult.  the Question shows up as one column of data, even if your question has more than one column (I realize that it is only one "question" but clearly multiple columns are created for a reason, so it would make sense to report them separately).  Each field in the data set then has the title or each column and the response, then the title of the next column and the response, etc.  We don't need the title...we put them there are know what they are, they really clutter up the data report.  

    Is there a way to improve data retrieval from this question type?  Reporting each column separately would be fantastic.  It will be very difficult to analyze user input data the way it is now...

     

    Thanks!

     

    Page URL:
    https://www.jotform.com//?formID=70236661168154

  • Profile Image
    JotForm Support

    Answered by Nik_C on January 26, 2017 at 04:39 PM

    Hello and thank you for contacting our Support.

    I did some tests, and yes, you are correct the data is showing in one row even though it is with multiple rows and columns. 

    And that is due to how our fields are representing in CSV and Excel spreadsheet. Actually, all fields from your form are represented as one field in Excel and CSV, so that's why they are in one cell.

    I'm afraid that it is difficult to edit how the data appears there. 

    I'll try to investigate more, but as far as I know CSV/Excel integration is as it is and not that editable. 

    But, again, let me check further and I'll get back to you with more information I hope.

    Thank you!