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

    How to have new fields on the form appear last in Excel Reports

    Asked by afcpool on April 06, 2016 at 11:13 PM

    I erred in the past in deleting a field from a form instead of disabling or hiding it, so that my Excel reports were out of sync for submissions after that change.

    I now need to add some fields, and am concerned that I will get a similar result. Is there any way to force new fields to become the last columns of the form, even if they aren't the last fields in the form?

    Page URL:
    http://www.arlingtonforestclub.org/membership/registration.php

    excel additional fields additional Without
  • Profile Image
    JotForm Support

    Answered by Boris on April 07, 2016 at 03:20 AM

    I'm afraid that our Excel reports, as well as any other kind of reports, will list the fields in the same order that they are placed n the form. If newly added fields are placed at the middle of the form, the Excel report will be created with these new fields at the middle.

    If you want for the Excel report to be generated with new fields being last, you will need to add them to the end of the form.

    Alternatively, once you download the Excel, you can also reorder the columns as described in this post:

    https://www.ablebits.com/office-addins-blog/2014/01/23/swap-excel-columns/

    If the above instructions do not apply to the Excel software you use, these instructions should help:

    http://www.wikihow.com/Move-Columns-in-Excel

    If you need any further assistance, please let us know.