Create a form to populate a downloadable Excel spreadsheet

  • Profile Image
    chris peabody 
    Asked on April 06, 2016 at 07:44 AM


    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.


  • Profile Image
    Answered 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:

    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
    chris peabody 
    Answered 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?
    Chris Peabody
    The state51 Conspiracy
    Web Facebook Twitter
    17 Hereford Street, London, E2 6EX
    +44 (0)20 7729 4343
  • Profile Image
    Answered 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.