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 to create an Excel Report

    Asked by djpto on July 22, 2015 at 03:11 PM

    That looks great, can I export it to Excel and run reports by the date/Vendor/item/quantity for ordering.

    Seperate report for distribution by class/name/item.

  • Profile Image
    JotForm Support

    Answered by Mike_G on July 22, 2015 at 03:19 PM

    I'm not sure how would you like for your report to show in an Excel file. But you can create Excel Reports here in JotForm. 

    If you want to include those fields in your report. You need to include it in your form first as a field and not just a Text. 

    Say, for example: 

    You don't have a Date and Vendor fields on your form as what I have checked. You can add them and just set those fields to "Read-only" under their Properties so they cannot be changed.

    Items are shown in your Matrix, however, for Quantity, I believe that needs to be computed. Can you explain how you would like for this to show?

    Separate report for distribution by class/name/item. I am not sure I understand this clearly, can you further explain this part in details so we can better assist you?

    You can generate Excel reports base on submissions under MyForms page. 

    Then, on Submissions page

    You can also create one from the Reports tool

    You will then be given a link that when you visit, your excel report will be downloaded.

    I hope this helps. Let us know if you need any further assistance. Thank you.