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

    The format of Matrix table data when downloaded to CSV or Excell is not usable without Manipulating it.

    Asked by chrispls on August 21, 2014 at 08:04 AM

    I created a form to report totals for student performance by course using the matrix.  I need to download it to CVS or Excel and have it retain those columns and rows.  However it places each submission on one row with the row above the data having all the heading.  I have proved a screen shot of the form and the CVS format.  is there any way to get it to download and retain the columns and rows?

     

    format excel heading rows matrix table
  • Profile Image
    JotForm Support

    Answered by jonathan on August 21, 2014 at 10:01 AM

    Hi,

    This is a limitation on the Matrix table field. When you download the data of Matrix table, the content/data of the matrix is being considered as one column/field only.

    This is why you will need to manually manipulate or edit the matrix field/column to add a separator/delimiter so that it become usable again.

    This is how the CSV download appears when opened with an editor

    As you can see, the data is a bit cryptic for immediate use. So, editing of the data is still required.

    What I suggest you try as an alternative to Matrix table is the Configurable List Widget instead.

    Use the widget to create multiple textboxes and mimic the matrix table functionality.

    Then test the downloaded data with the Configurable List widget.

    Hope this help. Please inform us if you need further assistance.

    Thanks.

     

     

     

     

  • Profile Image

    Answered by chrispls on August 21, 2014 at 07:47 PM

    The configurable list widget did not work.  It puts all the data in one cell in CVS format

  • Profile Image
    JotForm Support

    Answered by jonathan on August 21, 2014 at 09:23 PM

    Hi,

    Yes you were right. I was also able to check on this further.

    It actually is the same for both the Matrix and Configurable list -- that is, the data of the table are all in one cell.

     

    You may also want to try using the Spreadsheet Widget.

    Although data are still within a single column, the output is more organized than the matrix or configurable list.

     

    But if you really need the output of a table to be in a separate column/header -- then you must use multiple individual Textboxes field instead.  The output will surely assign separate column header for each individual textbox field.

    You can just mimic the positioning of each textboxes like a matrix table by arranging them in column formation using field positioning

    Hope this help. Inform us if you need further assistance.

    Thanks.