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

    Create a form to populate a downloadable Excel spreadsheet

    Asked by chris peabody  on April 06, 2016 at 07:44 AM

    Hi, 

    I'd like to create an online form which populates an excel spread sheet, with the responses going to specific cells within a template (not blank) spreadsheet. For example, I have a spreadsheet which I need clients to complete. They must fill the spreadsheet in beginning at line 15 without altering any other aspect of the existing spreadsheet. Can I upload a template spreadsheet which will be used for the form responses to populate and specify where each question response would populate in the sheet? Can I then have the option for the user to download the completed spreadsheet or have it emailed to them? Thanks.

     

    create a form excel create Excel spreadsheet
  • Profile Image
    JotForm Support

    Answered by Welvin on April 06, 2016 at 08:30 AM

    You can possibly do this through Zapier. With Zapier, you can select what spreadsheet to populate with a data from your Jotform form, assuming that you have it on your Google Drive folders.

    Here's an example of the integration through Zapier. Selecting spreadsheet and its sheet:

    Then mapping the fields:

     

    Here's the link to the specific Zap from Zapier: https://zapier.com/zapbook/google-sheets/jotform/

    Our built-in Google Spreadsheet integration won't allow you to do this. 

    Unfortunately, sending a download link to the user is not possible with Zapier. You mean to send users the spreadsheet of their submission, right? Individual file? If so, it's not possible. Once you select the spreadsheet, all submissions to your form will be passed to this spreadsheet. 

    Do let us know if you have any questions with this method.

  • Profile Image

    Answered by chris peabody  on April 06, 2016 at 10:45 AM
    Hi Welvin,
    Thanks this is really helpful. One thing I’m unclear of is the ability to customise precisely which cell from responses populate? For example I understand that column headers need to be on row 1 - if I need responses to begin to populate from row 15 is this possible?
    Thanks,
    Chris Peabody
    chris.peabody@state51.com
    The state51 Conspiracy
    Web Facebook Twitter
    17 Hereford Street, London, E2 6EX
    +44 (0)20 7729 4343
    ...
  • Profile Image

    Answered by Ben on April 06, 2016 at 11:49 AM

    The only way to do that is for you to manually add the first 13 rows (+ 1 row holding the headers), which would mean that there are 14 rows, and the next entry would be on row 15.