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!


16 Comments...


   
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 http://form.jotform.com/form/20425050478 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)

Hi,

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

This would be seriously useful.

Cheers

Russel

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 http://www.excel-aid.com/excel-report-applying-report-layouts-and-styles.html


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

We are currently running a Homecoming event with many single events held within it. http://www.jotformpro.com/form/41793566198975. 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.

Thanks!

View Answer


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

Hi,

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

Thanks!

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


Send Comment