How to Export Form Data to Excel

Last Update: May 29, 2016

You can now export your form submissions into an excel format. Please follow steps below:


1. Login to Jotform and go to My Forms page



2. Click on the Form name you want to export submissions to Excel from and click on "Submissions" button



3. Scroll down the page, On the Grid Table-Right above the Submission Date title you will see "Download as Excel" button.



If you have any questions, comments, suggestions or issues with this guide, please let us know by writing it below!


50 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?

View Answer


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

View Answer


   
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.

View Answer


   
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?

View Answer


   
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?

View Answer


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

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

View Answer


   
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.

View Answer


   
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!

View Answer


   
formmm (July 28, 2012 at 11:45 PM)

The function of Export does not work now.
The situation has been lasting for half an hour.

View Answer


   
TUUCAuction (September 29, 2012 at 01:14 PM)

OK, I Clicked on My Forms, went to the page, but I don't see anything that says "Download as Excel" or really anything else.

Just my form selected at top and list on left.

View Answer


   
guest_22791436252050 (October 09, 2012 at 07:03 PM)

Hi, I already have a form that exports the data into a PDF format.

What I would like to do is to export the main Excel spreadshit with all informations in Dropbox.

How can I do that??
Cheers,
TLS


View Answer


   
sanjeeb kr paral (July 07, 2013 at 12:37 PM)

pls give suggestion for the exported business

View Answer


   
Scott Carter (August 02, 2013 at 12:24 PM)

Hi. A blog that I read have simplified the process of exporting Form Data to Excel http://blog.caspio.com/tech_tips/form-to-excel-three-ways-to-get-web-form-data-into-excel/

View Answer


   
noli414 (December 06, 2013 at 03:35 PM)

I understand how to export and when I do, the data is formatted in headers and not at all like the grid I see. Is there a way to see the grid instead of it converting the store locations into headers? The form is in grid view, the pdf is in grid view, even the submissions are in grid view, but then I export and it doesn't keep the same format. Please tell me I can keep the same format. http://form.jotform.us/form/33391889469171

View Answer


   
atomiko1 (December 11, 2013 at 01:20 AM)

Its not working, i can't get the excel file HELP!!!!!

View Answer


   
hepvd_insertion (January 08, 2014 at 05:15 AM)

I have managed to export my data in xls but I don't have all the information because my matrix is larger than what is supported by the xls format.

Is there a way to export in "xlsx" format?

View Answer


   
sastclub (February 22, 2014 at 04:11 AM)

not working!!!!

View Answer


   
gymvic (April 25, 2014 at 04:22 AM)

Hi ... my submissions are not showing up and I can not export to excel - is there something I am not doing quite right?

View Answer


   
2maxgroup (April 29, 2014 at 10:36 PM)

it out of order at 29-30, please help to fix it, i have many data need to export from excel T-T

View Answer


   
uofsc_cmcis (September 30, 2014 at 03:50 PM)

One of my forms exports as a corrupt file that crashes Excel. I've downloaded it multiple times, on multiple computers, on multiple browsers, but each file that is exported crashes Excel. I've never had this issue with any other form before. I tested this across similar forms with no issue. Could you please advise?

View Answer


   
jpyles (October 10, 2014 at 03:31 AM)

Is there a way to have the exported file name NOT include the current date/time stamp? I would like to have it replace the file to the same name.

Or is there a way to truncate the new information into an existing file?

View Answer


   
kewian (January 08, 2015 at 01:36 PM)

Once new submissions are received, is there a way to update the info on an existing excel sheet? do I need to create new spreadsheets each time new submissions are received?

View Answer


   
osardeleon (February 07, 2015 at 08:03 PM)

mi pregunta si puedo seleccionar todos los formularios que he creado y exportar los a un solo archivo de excel

View Answer


   
white_cap (February 11, 2015 at 11:27 AM)

i have a form with over 500 submissions and the Submissions will not pull up so i can export.... what do i do?

View Answer


   
aymi (February 26, 2015 at 02:16 PM)

how can i get the submission ID into my excel export?

View Answer


   
RuudvdO (March 06, 2015 at 07:20 AM)

Hi,
Data is not exported to Excel.
Please help.
Thanks!

View Answer


   
JuzSchieder (March 09, 2015 at 11:38 AM)

Hey,

when I download the excel data, the sheet are empty...Please help! Thank you

View Answer


   
Nikita Varman (July 01, 2015 at 05:55 AM)

Is it possible to generate multiple submissions onto a single excel spreadsheet?

View Answer


   
success200 (July 19, 2015 at 06:57 AM)

Hi can anyone show how will it look like?

View Answer


   
pardeep (March 12, 2016 at 02:41 AM)

sir, I am facing a problem when submit a form and not showing redirectly submission.

View Answer


   
rpautassi (March 23, 2016 at 04:11 PM)

How can I export several forms in one excel?

View Answer


   
cris74 (May 29, 2016 at 04:52 PM)

Je connais cette procédure, mais ce n'est pas ce que je souhaite.
A chaque nouvelle soumission je souhaite récupérer la totalité des soumissions par l'intermédiaire d'un flux de données (data flow) automatique sans intervention manuelle. je veux accéder à un fichier actualisé "up to date" à partir d'un Excel en VBA (par langage de programmation)

View Answer


   
aritsm (June 09, 2016 at 10:39 AM)

my form has the Encrypt Form Data on, how can I export the form submissions so I can see the submissions and not jumbled letters?

View Answer


   
chsmc (June 20, 2016 at 11:20 AM)

The data is being transferred to the Excel spreadsheet, but is encoded. Is there a way for me to export it without the encoding?

View Answer


   
thestudyplace (August 26, 2016 at 11:05 PM)

i have a lot of submissions but got a very small (50kb) xlsx file after pushing "export to excel"

why???

View Answer


   
ToriChavez (October 20, 2016 at 09:09 PM)

I made my own form. Is it possible to export directly into excel and use one of the workbooks we have as a default to grab the information?

View Answer


Send Comment