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

  • Profile Image
    Asked 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

  • Profile Image
    Answered 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 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
    Answered on December 11, 2013 at 04:11 AM


    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.



    Hope this still helps. Thank you!