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 create a form which will be printable in addition to online for data entry and export to Excel?

    Asked by Melinda   on August 13, 2016 at 11:16 PM

    I have built an Excel workbook that generates many financial reports.  Currently, we input data in one of the worksheets.  There are a LOT of entries and calculations.  I'm looking for a solution which will enable us to print the data entry form for use in a meeting with a prospect, enable us to enter the data into the form online, then have the data exported to the Excel workbook to replace the data entry worksheet.

    Can I do that with your product?

    Thank you!

    Melinda

    P.S. I've included a screen print of the first page of the input worksheet.  This data entry worksheet has 200 rows and 19 columns.  There are 50 worksheets in the workbook.

    Screenshot
    create a form excel create addition
  • Profile Image

    Answered by Irshad on August 14, 2016 at 05:08 AM

    Yes, it is possible. 

    You can use Form Calculation Widget  for applying the calculation in your Form fields. Please check the below guide for more detail:

    https://www.jotform.com/help/259-How-to-Perform-Calculation-in-the-Form

    You can also use Jotform conditional logic, for calculation and logic according to the Form field conditions. Below is the guide for more details about Jotform conditions.

    https://www.jotform.com/help/57-Smart-Forms-Using-Conditional-Logic

    After the completion of Form, you can export the form submissions or data in to excel. Please check the below guide for exporting form data to excel:

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

    If you face any issue, or need further assistance, feel free to revert back.