How to Export Form Data to Excel?

Last Update: November 4, 2011

1. Login to Jotform


2. Click "My Forms" on the top

My Forms

3. Click on the Form name you want to export submissions of it to Excel

4. Click on "Submission"

form submission

5. Scroll down the page, On the Grid Table-Right Above the Submission Date title- you
    will see "Download as Excel" Button  (You can export the submissions to CSV file also,
    right near the Excel Label)

download excel

You have already voted for this item. Your vote was: 1

22 Comments...


   
facesbydesign (September 14, 2010 at 11:11 AM)

This export is not working as of 12:11 PM EDT 9/14/2010 and I need it to be!


   
allyally (September 16, 2010 at 09:17 AM)

I need this for products or service ordering & booking.


   
undone (November 03, 2010 at 10:56 AM)

Is this feature working now?


   
BayshoreTP (February 10, 2011 at 02:48 PM)

Once I export the data from my jotform excel sheet, can I delete that information to keep it from going on and on?


   
JotFormSupport (February 11, 2011 at 08:10 AM)

Since you have the Excel expport of your submissions you can delete your submissions.


   
mmatthews (March 01, 2011 at 08:21 AM)

Is there a way to create one report for multiple forms?


   
JotFormSupport (March 01, 2011 at 09:34 AM)

No you can't. Different forms are thought to have different fields which means it is not possible to create one report for multiple forms. If you have clones of the form, then you are advised to use only one form and create report from that.


   
Cga (March 02, 2011 at 10:26 AM)

There used to be a way to access the spreadsheet directly from an external link with automatically updated information (so other people could access the spreadsheet whenever they needed to without accessing the account). Is this still available? I can't find that option and want to delegate access to the information without providing access to the underlying forms.


   
ASRA (March 12, 2011 at 10:58 PM)

CGA's question is a good one. Is there an answer?


   
JotFormSupport (March 14, 2011 at 06:36 AM)

Create an excel report.

Open my forms,
Click on the form
Click on reports on the top toolbar
Create an excel report


IMPORTANT: Please ask your questions to the forum.


   
GetPreparedStuff (March 29, 2011 at 02:14 PM)

Can we get Jotform to break out the components of the payment widget into multiple columns in the Excel export option? All information from the payment widget is lumped into one column. It is hard to manage in this format. It would be so much easier to have it broken out into columns for the description, quantity and price/total. Having the quantity and totals in their own columns is essential to even use those numbers in a spreadsheet. As it currently stands those values are useless until they are manually added to their own columns.


   
austin (March 31, 2011 at 09:39 AM)

how can i get php code to upload this form to my database? someone help:(


   
Linda Anderson (April 01, 2011 at 04:44 PM)

REALLY IMPORTANT: Has this problem been fixed yet? Thanks!

"Can we get Jotform to break out the components of the payment widget into multiple columns in the Excel export option? All information from the payment widget is lumped into one column."


   
show (April 03, 2011 at 10:34 AM)

I have a only dispalying today in my submission forms. I cant find a way to change that so that I can see all submissions


   
spoonfulofdelight (May 05, 2011 at 10:12 AM)

Is there a way to display the information submitted using the form on a webpage, right away after hitting the submit button?

See Answer for This Question...


   
altpress (July 25, 2011 at 07:49 PM)

REALLY, REALLY IMPORTANT: Any updates on this?

"Can we get Jotform to break out the components of the payment widget into multiple columns in the Excel export option? All information from the payment widget is lumped into one column."

See Answer for This Question...


   
julio_auscube (August 18, 2011 at 11:27 AM)

Is there a way i can display the completed form on my website. so people can see what the other person has answered? like a review on something for example.

See Answer for This Question...


   
achint (November 10, 2011 at 11:13 AM)

Hi i have created a form and linked it to my facebook account but now i am not able to edit the form. My forms account does not show any entry of the account.

http://form.jotform.com/form/12794038943?

This is the form and i want to edit this form. Can you help?

See Answer for This Question...


   
lgoldish (February 17, 2012 at 01:51 AM)

I have 48 submissions of which 29 are new. Before the new ones I changed a radio button to a check box. I would like to download all. I can do that. All the rows download, but only about 4 of the download rows show the data. The rest are blank in the data columns, although in the submissions view I can see the data. How do I get the data to download?

See Answer for This Question...


   
celebratelife (April 07, 2012 at 01:15 PM)

The excel document will not automatically update with new form submissions...why?

See Answer for This Question...


   
celebratelife (April 07, 2012 at 01:15 PM)

this does not work@
There used to be a way to access the spreadsheet directly from an external link with automatically updated information (so other people could access the spreadsheet whenever they needed to without accessing the account). Is this still available? I can't find that option and want to delegate access to the information without providing access to the underlying forms.

See Answer for This Question...


   
DailyMirror (May 10, 2012 at 02:34 PM)

My form will not download in Excel or CSV format. Cannot integrate with Google Docs. Too many submissions?Help!

See Answer for This Question...


Send Comment