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 can I capture my submissions in an Excel template?

    Asked by wendyw on March 09, 2015 at 10:40 AM

    I'd like to format each form submission into an Excel template that I already have. Is this possible? 

    excel template format each form
  • Profile Image

    Answered by raul on March 09, 2015 at 11:47 AM

    If I understand correctly you want to capture the submitted data in your form in an Excel file, is that correct? If so, you can integrate your form with Google Spreadsheet.

    I see that you mention a template, so I'm not sure if what you want to do is to populate the template with the data in your form. If so, you can use the integration mentioned above and then use that sheet as the data source for your excel file so you can adapt the data to your template.

    Let us know if this is what you're looking for.
    Thanks.

  • Profile Image

    Answered by wendyw on March 09, 2015 at 12:00 PM

    this is what i'm looking to do, but it looks like you have to run it through the klipfolio dashboard. is it possible to do as a separate sheet in excel, or somehow generically so i can run it through my asana dashboard?

  • Profile Image
    JotForm Support

    Answered by david on March 09, 2015 at 12:57 PM

    Hi,

    It is possible to download your submission data as an excel report:

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

    However, this report would come in the same format each time, you would then need to import your data to the spreadsheet that has your template.

  • Profile Image
    JotForm Support

    Answered by david on March 09, 2015 at 02:23 PM

    Unfortunately it is not possible to send your submission data to your spreadsheet pre-formatted.  We do not currently have the ability to format the way your data is pushed to the sheet. 

  • Profile Image

    Answered by wendyw on March 09, 2015 at 08:27 PM

    I believe Raul was on the right track, but we kind of veered off topic a bit...

     

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on March 09, 2015 at 11:02 PM

    Like David said, there is no way to pre-format the spreadsheet. But you can format it afterwards, by either downloading the Excel or integrating with Google Spreadsheet.

    If you want to make more questions, please open a new thread.

    Cheers!