How to Create an Excel Report?

Last Update: June 3, 2016

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

1. Login to JotForm and click "My Forms" at the top website menu

2. Select the Form from the list and click on 'Reports'

4. Click on 'Add New Report'.

5. Choose 'Excel Report' from the options click on 'Next'

6. You can choose what fields are to be included in the report. To restrict access to the report you can enable Password Protection

7. Copy the generated report URL and click "Close" button

If you have questions or suggestions or comments about this guide, please let us know in the box below!


hayflick (January 29, 2012 at 12:17 PM)

How do I set up regular emailing of my reports?

View Answer

Dew (February 07, 2012 at 12:24 PM)

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

Thank you.

View Answer

Dew (February 07, 2012 at 02:19 PM)

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

purplegroup (February 21, 2012 at 12:32 PM)

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?

View Answer

DEYC (April 05, 2012 at 01:25 PM)

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!

View Answer

russ1111 (December 16, 2013 at 07:55 AM)


Can I get an excel or CSV file to automatically get updated into my dropbox folder??

This would be seriously useful.



View Answer

Ben (March 25, 2014 at 09:44 AM)

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

Steve Breeden (September 22, 2014 at 12:56 PM)

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?

View Answer

mrotjan (January 20, 2015 at 12:19 PM)

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


View Answer

katherinekay (January 22, 2015 at 08:32 AM)


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


View Answer

bthompson7474 (August 11, 2015 at 11:22 AM)

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

View Answer

LFDjotforms (August 20, 2015 at 08:47 AM)

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?

View Answer

wengriffinapt (April 27, 2016 at 05:57 PM)

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

View Answer

QCGU (June 12, 2016 at 07:44 PM)

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

View Answer

drwilburne (September 26, 2016 at 08:59 AM)

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...

View Answer

dreamforge (September 26, 2016 at 03:11 PM)

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?

View Answer

prossmann (October 11, 2016 at 11:18 AM)

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

View Answer

promisedlands (October 27, 2016 at 05:44 AM)

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).

View Answer

cris74 (November 03, 2016 at 08:30 AM)

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

View Answer

NCUCapex (February 24, 2017 at 02:36 PM)

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

View Answer

Send Comment