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

    Can the spreadsheet that is created by the jot form be broken out?

    Asked by TMyersRandstad on July 17, 2017 at 12:16 PM

    I have several entries put on this jot form monthly and I would like the take the old entries and move them to a new sheet in the workbook and only have the entries for a given month be on current worksheet "sheet1" that is being captured.

    I want to take everything from row 131 and up and move it to a newly created sheet (sheet2) and only have the entries for the current month on sheet 1.

    Will this break anything if I do that?  Can this be done?

    Screenshot
  • Profile Image
    JotForm Support

    Answered by Welvin on July 17, 2017 at 01:36 PM

    We don't recommend doing any modification in the Google Spreadsheet file if you are referring to this integration. If it's the excel file that is generated when you click on the Excel download button, then that's fine. 

    You may consider moving the Data into a different spreadsheet file via the ImportRange feature (https://support.google.com/docs/answer/3093340?hl=en). 

    Or, you may consider downloading the submissions as an excel file the delete the submissions keeping the newest ones.

    https://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel