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

    When exporting my data into Excel, it presents the fields horizontally.

    Asked by NCUCapex on February 25, 2017 at 12:02 PM

    When exporting my data into Excel, it presents the fields horizontally. Is there a way to present the information in Excel so that it presents the fields vertically? Example:

    Field 1 Field 2 Field 3

    Want it like this:

    Field 1

    Field 2

    Field 3

    Thanks!



    This is a re-post of a comment on How to Create an Excel Report?

  • Profile Image
    JotForm Support

    Answered by Jim_R on February 25, 2017 at 02:50 PM

    I'm afraid the Submissions Data will always be exported in that manner. Form Fields act as the sheet column headers and it's the usual, most natural way of displaying data.

    What you can do is transpose the rows and columns in Excel if you prefer to view it the other way around.

    Related article: Transpose-rotate-data-from-rows-to-columns-or-vice-versa