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

    Is there a way to have the matrix form not put all the data in the same row?

    Asked by diligentfollowup on November 18, 2016 at 01:23 PM

    Is there a way to not have the matrix form put all the data in the same row?  I notice when the CSV file is created it put's each field in a different column.  This poses a problem when I try to upload the matrix submission to another software where it's supposed to pull the info in.  It can't find the matrix data.  Is this because I have other fields like Address and a message section in addition to the matrix section?  It'd be nice if I could get the address and message to show in the submission email field with only the matrix data in the CSV file.  Thoughts?

    Page URL:
    http://www.diligentfollowup.com/enter-prospective-buyers/

    Screenshot
    same row same all in
  • Profile Image
    JotForm Support

    Answered by david on November 18, 2016 at 03:39 PM

    Field data is exported as one field per cell.  If you need the data separated out into separate cells by default, it would require capturing one piece of data per field, rather than using fields that capture multiple types of data.  You could set up multiple sets of single fields and show those sets conditionally.

    Here is what your form would look like with everything split to separate fields:

    https://form.jotform.com/63226104752954

    You can clone it to your account if you would like a copy:

    https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    The problem with exporting a single field to multiple cells would be splitting a single set of data out to multiple sets to be exported.