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

    Is it possible to stream the data from different sections to different tabs on excel

    Asked by Els7278 on December 09, 2016 at 10:17 AM

    Hi, I have set up a form with multiple sections and I would like data from each section to be streamed to a separate tab on excel with the name fields being repeated in each section. Is this possible?

    Many thanks,

    Elizabeth

    Page URL:
    https://eu.jotform.com//?formID=63413113857352

  • Profile Image
    JotForm Support

    Answered by Welvin on December 09, 2016 at 12:12 PM

    Unfortunately, this is not possible in the form builder. All data are all saved in one single worksheet in the excel/google spreadsheet. 

    Your workaround would be to do the integration through Zapier. Zapier allows you to select what worksheet to pass the data and also allows you what fields to pass.

    https://zapier.com/zapbook/zaps/1924/add-new-jotform-submissions-to-a-google-sheets-spreadsheet/

    You need to make a Zap for each section in Zapier.