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 I export submission data into an existing Excel Workbook

    Asked by ToriChavez on October 21, 2016 at 12:46 AM

    I made my own form. Is it possible to export directly into excel and use one of the workbooks we have as a default to grab the information?



    This is a re-post of a comment on How to Export Form Data to Excel

    export submissions excel
  • Profile Image
    JotForm Support

    Answered by seth on October 21, 2016 at 03:53 AM

    Hello,

    Unfortunately you can't export your form data into an existing excel sheet. However, you can create excel reports or download all submission data as excel.

    Creating excel report is suitable for your inquiry since you can select which field to export with arranging your data accordingly. Keep in mind to design your form to match your existing excel file. Here is a guide on how to create excel reports. After creating this excel report you can copy and paste the data or use macros to insert the report data into your existing excel sheet.

    Also have a look at this guide:

    https://www.jotform.com/help/73-How-to-Download-Form-Submissions-as-Excel-CSV-PDF

    I hope this answer helps. If you have further questions please feel free to ask.

    Regards.

  • Profile Image

    Answered by ToriChavez on October 21, 2016 at 01:44 PM
    Hi, Thank you. I'm creating a sheet with macros then. I'm creating the macros but, how do I get the macros to stay in the report? I'm trying to make sure the excel report from jot form will stay the same. Is this possible? Also, do all entries forward into one spreadsheet? Any advice if I need to pull these one by one? Thanks,Tori ChavezSerraLux, IncRohnert Park, CA USAcell 707-953-2434vchavez@serralux.uswww.SerraLuxInc.com  Harnessing the Power of Daylight  SerraGlaze & SerraView bring the power of daylight into yourbuilding so you can work, learn, heal, relax & perform better. 
    ...
  • Profile Image
    JotForm Support

    Answered by Mike on October 21, 2016 at 03:58 PM

    I'm creating the macros but, how do I get the macros to stay in the report?

    If you have any macros you will need to use it on your end, since you cannot add it to the JotForm.

    I'm trying to make sure the excel report from jot form will stay the same. Is this possible?

    Yes, once you create an Excel report, it will keep the format. The excel file is downloaded when you access the report link.

    Also, do all entries forward into one spreadsheet? Any advice if I need to pull these one by one?

    There are two options, download all entries, or download the entries based on a time frame. The time frame option is available on Submissions page.

    The form entries can also be sent to integrated Google Spreadsheet.

    How to Integrate Form with Google Spreadsheet

    Thank you.