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 get the Excel file without some fields in it?

    Asked by capcar2016 on January 06, 2016 at 02:11 PM
    About the spreadcheat I guess each time I download I can delete the fields with Município and leave only the Cidade that I will have what I want. Easy enough.
  • Profile Image

    Answered by Ben on January 06, 2016 at 02:22 PM

    2 approaches come to mind so that you do not need to download the fields each time manually.

    1st - for Google Spreadsheet integration

    - Instead of hiding the column, you can simply delete it. Once removed (by right clicking on column header) the same data will not be passed to the spreadsheet by the integration and if you download the Excel file from it, it would not hold the same. This would mean that after that initial removal of the field, no more removals would be needed.

    2nd - using Excel Report

    Unlike getting Excel from the Submissions Panel, the Excel Report allows you to select what are the details that you want to see in it once it is downloaded. This makes it a nice option if you are interested in the same, especially since a link is created from which you can get the latest version of the submissions in the same layout as you had selected, making it easy to be grabbed by some software, etc.

    You can see more about the report here: How to create an Excel Report?

    Of course if you have any questions, do let us know Pedro and we would be happy to assist with the same :)