JotForm User Guide / Reports /

How to Create an Excel Report

How to Create an Excel Report

The Reports feature lets you generate an Excel Report of the submissions and share it with others.

  1. Go to the My Forms page.
  2. Select the form you want to generate a report from.
  3. Click the Reports menu.
  4. Then click Add New Report.
    My Forms Reports Menu
    My Forms Reports Menu
  5. Select Excel Report on the Create a new report modal pop-up.
    Create New Excel Report
    Create New Excel Report
  6. Next will be the Excel Report setup page, which is divided into 3 sections.
    Create Excel Report Select Fields
    Create Excel Report Select Fields
    1. Report Name - type the name of the report that will be shown under the Reports menu on the My Forms page.
    2. Fields - include or exclude fields and other information such as Submission ID, Submission Date, or IP address.
    3. Report Configurations - enable or disable additional report settings to your preference.
      Password Protection - an optional but added layer of security.

    Click the Create button at the bottom to finish the setup.

  7. After clicking the Create button, you will be prompted that the Excel Report is ready. On the same pop-up, you will see the link to the Excel Report that you created. There is a button to copy that link, (a)  and also a button to download the report. (b)
    Create Excel Report Ready
    Create Excel Report Ready

    Click the close (X) icon at the top-right corner to close the pop-up.

You may share the generated link to your report with others.

Create New Excel Report Sample

Create New Excel Report Sample

Comments and suggestions are welcome below. If you have a question, post it in our Support Forum so we can assist you.

Contact Support:
Our customer support team is available 24/7 and our average response time is between one to two hours.
Our team can be contacted via:
Contact JotForm Support:

Send Comment


  • kofrockets

    Please help!

    I am creating a simple inventory form which asks how many of each item they have.

    But how can I get the totals (sum) from each column under all the responses for each question? For example, if I ask all the responders "how many of item A do you have?", I would like the Excel sheet to tally everyone's responses to that question at the bottom of the column. Same with all the columns.

    It is great to see all the answers to the questions. But I need to see the responses aggregated and the totals reported. Also, is there a way to turn that summed up data into graphs and charts?

    Thank you!

  • jasoncripps

    I just found out about this feature and I'm thrilled it's available. If I share the report link with others, can they pull the most recent data as of the time they download it, meaning anytime they need an updated report in real-time they can download it with that link, or is does the link only provide data for the moment in time that it was generated? I'm trying to provide real-time reporting to a colleague that he can access whenever he needs it. Alternatively, is there an option to schedule an updated report to be sent weekly for example?

  • heidi.e.marion

    I am trying to uderstand how best to collate my data. It is ideas not numbers that will be reported in the jotform I am sending around. About 20 people will input answers to about 10 questions on their experience.
    What should I use to collate this info? It is not for public consumption nor will it be on a website... Just for internal use.

  • multishow11

    Saludos... Consulta. En el gratuito , no se puede revisar reportes excel o de ningún tipo o si ? Gracias por ayudar con esta duda

  • batyalevy

    When I go to the "support" page, it opens it up in the same browser as my jotform builder. Is it possible to set it up so that the support stuff pops up in a new browser?

  • Galemas

    I'd like a way to switch rows and columns quickly...trying to generate sales in this COVID world and have uploaded hundreds of products, but when I download, they're going across rows instead of down a column.

  • mthibout


    Into a form with questions that required to be qualified i.e. from 1 to 5, is it possible to get the average calculation of the answers of each one of them?

    I mean, in each question (column) something at the bottom like "AVERAGE: #1: 5; #2: 7; #3:1; or maybe in percents values (#1: 20%; #2: 10%; #3: 40%; #4: 15%; #5: 15%) or simply the most selected value.


  • cris74

    What is the URL where the submission file is located?

  • sooraj10295

    Thank You , wonderful solution

  • Destination Planning

    Will the excel spreadsheet update automatically as new submissions come in?

  • QFAinc

    my first jotform send reports as a spreadsheet to Google drive.
    My second form Jotform is sending the reports as pdf docs to google drive.
    Can't find where to correct my error.
    I did use the create xl report but that goes to NOT to google drive
    Thank you

  • My_Charity

    A couple of people have submitted their forms but the forms have not appeard on the XL report. As the system will only allow one go at registering is there any way of adding them manually to the report. Also I have deleted one submission in error, can it be re-established?


    Bueno dias. Desde mi cuenta no puedo realizar un Informe con excel. queda leyendo como colgado. Si puedo hacer informe en PDF. pero necesito en Excel. Por favor necesito con urgencia tener el archivo .xls con todos los datos y también los gráficos correspondientes.

  • rahul

    Report creating in exel is very nice feature.

  • andres00515

    How i can filter the dates for a excel report or a specific criteria before generated, for example i want to give the url a some customer but he only must see your own information.

  • DavideCorda

    Is it possible to change the name of the excel sheet ('Submissions') into another one?

  • RobynDouglass

    Can we edit or delete a report ? ie realise we would like to modify the details exported or start all over again

  • NCUCapex

    When exporting my data into Excel, it presents the fields horizontally. Is there a way to present the information in Excel so that it presents the fields vertically? Example:
    Field 1 Field 2 Field 3
    Want it like this:
    Field 1
    Field 2
    Field 3

  • cris74

    When will you replace the manual process by an automatic data flow, as already exists for Google sheets?

  • promisedlands

    I have multiple forms. Part of the filled in items are everytime the same (name, email, stuff like that).

    Can I change the order in the Excel reporting? For instance: I have 8 forms with different questions on each, but all have somewhere in the form a question about name and email. I want to generate excel reports for all 8 forms that I start everytime with the recurring data (name, email etc).

  • prossmann

    Is there a way to format the Excel report so that columns are either left justified, or some are centered?

  • dreamforge

    Can I link this excel report to update automatically to my excel online account / MS sharepoint account - so that it shows latest data of all in one place so that I can share it?

  • drwilburne

    Is it possible for the excel spreadsheet to separate selections with a comma when a user submits an answer with more than on answer? Example: Please select all counties that you serve. Mifflin, Juniata, Dauphin, Philadelphia, etc...

  • QCGU

    If my form is encrypted how do I un-encrypt the report. I keep getting code in my excel report.

  • wengriffinapt

    Is there a way to create an Excel report that is a consolidation of submissions from multiple forms?

  • LFDjotforms

    I am trying to download and excel report; however it limits me to 10,000 occurrences. How do I expand it so that I can get all of the data on one report?

  • bthompson7474

    I'm looking at running a report that is a summary of all the data for each questionnaire. How do I do that?

  • katherinekay


    Is there a way to create a report of only new submissions, i.e. those that were not pulled out in previous versions?


  • mrotjan

    It would be great if we could add a deliminiator for multiple select items to the excel report.


  • Steve Breeden

    We are currently running a Homecoming event with many single events held within it. Currently, it is dumping all the individual event information under one column of cells called "Events: Products. This means we have to look by hand to see which events the customer is signed up for and how many are attending each event. I need this information to be listed separately by each event and number attanding each event. Can this be done?

  • Ben

    cool something I was looking for. This page I use definitely in my top 10 for theme excel. The following is also very helpful. Look at

  • DEYC

    In my form in the last item: the report includes payee info and payee address all in the last DInner Cost column. How do I get it to separate payee info and payee address into their own columns in xl sheet? Having it all in one column adds many keystrokes to get it to a workable size. Do like your app!

  • purplegroup

    Is this link that is being generated constantly updated with new submissions? Or is it only capturing current submissions before the final step of the wizard report?

  • Dew

    I mean the field names that can be inserted when generating email.

  • Dew

    How can I get the short column names (fieldname) in the Excel Report?

    Thank you.

  • hayflick

    How do I set up regular emailing of my reports?