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

    Export matrix table to excel in the same format on the form

    Asked by noli414 on December 06, 2013 at 04:33 PM

    I understand how to export and when I do, the data is formatted in headers and not at all like the grid I see. Is there a way to see the grid instead of it converting the store locations into headers? The form is in grid view, the pdf is in grid view, even the submissions are in grid view, but then I export and it doesn't keep the same format. Please tell me I can keep the same format. http://form.jotform.us/form/33391889469171



    This is a re-post of a comment on How to Export Form Data to Excel

    Submissions JotForm format same
  • Profile Image
    JotForm Support

    Answered by KadeJM on December 06, 2013 at 05:22 PM

    Which Grid are you looking at? Did you mean that you are looking at the Matrix you are using on your form? And then asking if it will be the same elsewhere such as in your Submissions and then also to Excel? Or?

     

    The Gridview for your Data is going to appear differently since it is exported differently in a different format. The Excel Option (.xls) and (.csv) on the otherhand works differently since it is a separate format being that this is a Spreadsheet and not that of the grid so it'll appear differently. If you are trying to adjust the Excel you would have to do that manually with Formulas and other Inserts to modify it that way. The PDF Version on the other hand has been designed to retain the Matrix format.

  • Profile Image

    Answered by noli414 on December 10, 2013 at 11:51 PM

    Yes, I'd like to keep the matrix format that appears on the form and in the .pdf.  Since it looks like a table I assumed that it would retain the same format.  Currently, I have to manually copy and paste the data into an excel spreadsheet.  I thought I had found a solution with Jotform in trying to create a multi field form that would somehow export the data to an excel spreadsheet.  I even tried to link it too Google Spreadsheets, with the same outcome, the data was appearing in column headers.  Do you have any other suggestions for multi field forms so that the store locations appear in column A, Qty's in Column B, C, D.  or some type of exporting tips I can use so the data appears in the same format as the form?

    Thank you!

  • Profile Image
    JotForm Support

    Answered by EltonCris on December 11, 2013 at 04:11 AM

    Hi,

    Unfortunately, we cannot provide you any other way other than the features found on the form builder. Since  exporting of submissions data is a system side generated, there's nothing we can do to provide you assistance about this. Modifying the excel file locally is the best workaround we could offer for now and then use a formula to lessen your workload.

    You can search basic excel formulas for copying data from sheet to another sheet.

    Example:

    =Submissions!B2:B100

    Hope this still helps. Thank you!