Jotform lets you create an Excel report from your form submissions, making it easier to organize and work with your collected data in a spreadsheet. You can generate a report based on your submissions and use the resulting Excel file for further review or analysis.
Whether you need to organize submission data, review responses, or share your collected information with others, an Excel report gives you a convenient way to work with your form data outside of Jotform.
Creating an Excel Report is easy. Here’s how to do it:
- On the top-left side of your Workspace page, click on Create.
- Then, in the menu that opens up, select Report.
- Now, in the Choose your Report Type page, click on Excel Report.
- Next, in the Select a form page, search for the form you want to use in the Search bar at the top. Or select it directly from the list of forms. For example, Agreement Form.
- Then, click on Next.
- Now, set up these things:
- Report Name — Enter a name for your report to help you identify it.
- Fields — Select the fields you want to include in your report.
- Select All — Select all available fields for your report.
- Report Configurations — Customize the access and submission links included in your report.
- Password Protection — Require a password to access the report.
- Show Edit URLs — Include links that allow you to edit the corresponding submissions.
- Show View URLs — Include links that allow you to view the corresponding submissions.
- Then, click on Create at the bottom of the page, and you’re done.
You’ll then be prompted that the Excel Report is ready, and now you can do the following things:
- Copy Link Button — Copy the Excel Report link to your clipboard.
- Download Report Button — Download the Excel Report to your device.
- X Button — Close the Excel Report window.
That’s it. With Jotform’s Excel Reports, you can efficiently organize, analyze, and share your form submission data. Whether you need to track responses, generate insights, or collaborate with your team, this feature streamlines the process.
Send Comment:
45 Comments:
January 15, 2026
Can I break out data within a field, or do I need to break out additional fields?
May 23, 2025
good solution
December 12, 2024
Is it possible to share an excel report link? Also, is it possible to include workflow information (ie. current person a form is pending approval from) on the excel report?
August 13, 2023
When I download an excel report the first fields on the form are last, and the last fields are first. Does Jotform not have a way to report on the order of the fields as they are presented on the form?
February 28, 2022
I tried to copy the link and share the report with a co-worker, but it did not work when they tried to open it. Is said "not authorized"? Do they need a Jotform account in order to view a report?
December 14, 2021
Hi once excel report is created, is there anyway I can set up the excel report to be emailed on to people in jotform. Can this be automated daily ?
September 16, 2021
I would need to approval status to be included as a field in the excel report file
February 28, 2021
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!
December 11, 2020
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?
October 21, 2020
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.
Thanks!
Heidi
June 22, 2020
Saludos... Consulta. En el gratuito , no se puede revisar reportes excel o de ningún tipo o si ? Gracias por ayudar con esta duda
May 24, 2020
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?
April 18, 2020
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.
November 26, 2019
Hi!
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.
Thanks!
November 2, 2019
What is the URL where the submission file is located?
August 31, 2019
Thank You , wonderful solution
April 1, 2019
Will the excel spreadsheet update automatically as new submissions come in?
March 17, 2019
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 jotform.com NOT to google drive
Thank you
qfa
January 11, 2019
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?
December 20, 2018
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.
December 19, 2018
Report creating in exel is very nice feature.
February 10, 2018
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.
October 20, 2017
Is it possible to change the name of the excel sheet ('Submissions') into another one?
October 19, 2017
Can we edit or delete a report ? ie realise we would like to modify the details exported or start all over again
February 24, 2017
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
Thanks!