JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
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?
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.
create a form excel create addition
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:
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.
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:
If you face any issue, or need further assistance, feel free to revert back.