Jotform’s data export tool allows you to export and download your form submissions as an Excel file. You can manage your data efficiently in an Excel spreadsheet which is particularly useful for large records.
This guide shows how to export your form entries to an Excel file. For more options, see How to Download Form Submissions as Excel, CSV, or PDF.
To download your submission data as an Excel file
- In Jotform Tables, select Download All in the upper-right corner
- Select Download as Excel from the menu.
You can also find the download options from the tab menu.
The download should start automatically once your file is ready which could take some time depending on the size of your records.
Send Comment:
119 Comments:
70 days ago
my company is using Jotform as a way to submit work requests for maintenance and I was curious if thereis there a way to auto populate a permanent excel sheet with Jotform entries? as new ones come in, it will create a new row and populate the proper fields or columns.
is this something that can be done with Jotform or does it require a third party app
215 days ago
I don't seem to have the option to download my table to Excel or any other download option. Does this require certain level access?
230 days ago
when I tried to download my file in excel format I get an error message that says 'could not open in protected view'; That's never happened before. How do I change that?
261 days ago
I would like to change the layout of how the data exports into excel so I don't have to manually change it every time (eg: titles of questions running down the page), is this possible?
More than a year ago
how do i edit the info in the excel file before it is exported?? all my cells are not showing in the excel file when it is downloaded
More than a year ago
I am trying to download an excel . It keeps downloading but nothing happens
More than a year ago
I am trying to create an excel spreadsheet for data from a survey form that has been shared with me. Can you tell me how to do that? Thanks
More than a year ago
i need last 4months snap
More than a year ago
Do we have a tutorial about how to import Data from an Excel File to the Submission data? For example we started using Jotform in January 2022 but I need the data from last year as well. TIA
More than a year ago
Do we have the ability to export at time of submission to an attachment?
More than a year ago
I am having the same problem as xaviercharter in the questions below: Jotform exported all my data except the first and last name field on multiple forms I'm currently working with. Please help!
More than a year ago
Hi,
May I know if jotform allows to cross tabulate data from my survey? If yes, how?
More than a year ago
I have forms made and I need to know how to get the totals from each item.
It breaks each field apart.... name , Order, phone, email ect.....
I need the information in the ORDER part to be totaled by each size and product?
Can you please help me...
More than a year ago
Can you tell me the name of the export directory?
More than a year ago
When using Jotform Tables, I would like to be able to copy and past only one of the columns or download it to excel. I don't want all of the data, just one column. Is that possible?
More than a year ago
I want to know sumation of each product by total submission as I got in chart . I want that xls format instead of chart that I sent you earlier.
More than a year ago
Can I combine all submissions to a single excel file before download?
More than a year ago
when downloading the submission as excel, the signature did not display only its link
please giving any suggestion to display the signature
More than a year ago
Your excel format is set to 255 column width in some columns, and messes up other columns when edited.
Not sure how to make your excel work like usual...
More than a year ago
Why are the columns on my submission results in XLS in random order? I need to match up stores with quantity ordered, but the columns don't match up
More than a year ago
could the fields have names or 'alias' other than the full question on the form.?
More than a year ago
Hi there, whem I am downloading data to the excel spreadsheet, the only information that is being downloaded is the date of submission. What's the reason? I would like to see all the details introduced to the form embodied into the excel format. Could you please help with that?
Kind regards, Aggie
More than a year ago
why do i not see any data when i export to excel?
More than a year ago
The cells in the jot form are exported to a single cell in the excel spreadsheet i.e.
a1,25, b1,52,b2,27 instead of having each cell as separate column in the exported sheet
Thus you can't use the data in the exported sheet for further analysis
More than a year ago
When I download the excel worksheet, I can't get the pictures that go with the submission to load. I always get an error. What am I doing wrong?
More than a year ago
I don't have a submissions tab or page. My Jotform does not look like this?
More than a year ago
When I download my Excel file with the data, the columns are not labeled. They are labeled as
No Label, No Label One, No Label Two, etc.
More than a year ago
Downloading submissions as Excel Document ist not possible. theres always an error.
thank you for youre help !
More than a year ago
Manage my account
More than a year ago
I have done this several times, each time it tells me that the file is corrupt. Please advise. I've tried both excel and PDF and the same thing keeps happening. I can see the preview, but when I actually try to open it I get the error message.
More than a year ago
Hi
I tried to download all submissions in xls form, for some reasons I always get the empty file.
I checked the steps cannot see anything I did wrong. Can u help me pls
Thanks
More than a year ago
We will need to track payments for each campaign in reporting. The examples here do not have payment amounts. Do all fields on the Jotform get their own field in an excel sheet when you run a report?
Thanks!
More than a year ago
I'm new to this and have been trying to export data to excel, but it only gives me the headings on the excel sheet, plus the submission date. None of the information on the form(s) comes through.
What am I doing wrong?
Thankyou. Lyn
More than a year ago
the download only shows the date column and all the other data is blank! Help!
More than a year ago
Jotform exported all my data except the first and last name field
More than a year ago
How to export ==Payment Info== into the excel? Thanks
More than a year ago
When i download the submissions the columns are not in the same order as the questions - why?
It used to download in the same order before
More than a year ago
Love the app. I have multiple products in my form. They all get smushed into one field. Is there any way to have them appear in separate cells so that I can easily count the # of each item ordered? Could not figure this out using Excel reports. Example - one person may order 4 t-shirts and 2 camping nights. Since all of this is one cell in Excel, I can't easily break it out.
More than a year ago
How do you have it export the excel to your google docs excel?
More than a year ago
Is there a way I can create an excel form template with the column widths predetermined?
More than a year ago
Hi there,
Is there a way to separate item ordered into different rows?
Thank you
More than a year ago
Hello I'm using an encrypted form and I have uploaded by key. It did in fact decrypt for me to view within jotform.com submission interface but as soon as I download to Excel or CSV, the downloaded file is showing the encrypted values again. How can I download the file with the values decrypted?
Thanks,
Ryan
More than a year ago
I need to export a spreadsheet of all form submissions to Excel. How do I do multiple submissions?
More than a year ago
l want them to transfer the information automatically to an Excel spreadsheet
More than a year ago
how to export the form records back to 1 year ago?
More than a year ago
Is there anyway to have the information that is entered on forms automatically downloaded into a spreadsheet? With Google forms, that process happens automatically so I know that the information on the spreadsheet is up to date. The form and the spreadsheet are linked in Google forms and that ensure that I'm looking at the most current information.
More than a year ago
Is there anyway to have the information that is entered on forms automatically downloaded into a spreadsheet? With Google forms, that process happens automatically so I know that the information on the spreadsheet is up to date. The form and the spreadsheet are linked in Google forms and that ensure that I'm looking at the most current information.
More than a year ago
is free version able to excell ? pls advise
More than a year ago
It would be great to have a schedule option to allow this to run automatically and something like the last 50 or 25 or 100 etc.
Robert
More than a year ago
Hola:
De que forma puedo descargar todos los formularios al mismo tiempo?
y generar un respaldo.e
More than a year ago
If the data is being downloaded encrypted ... how can I view the data
More than a year ago
I have added the E-signature widget to a form, but when I download into Excel it on shows a url for the signature. Is there any way to download it as a picture. I will be exporting the excel information into a customised PDF form we use and want the signature to show in the correct place.
More than a year ago
how to send data from jotform to Google Spreadsheet
More than a year ago
Can we, by typing in the form data, have our Excel sheet filled with information after it is downloaded in our computer?
More than a year ago
How export results of a spreadsheet in form to google sheet?
More than a year ago
We have booking coming for several tours, so will there be only one excel sheet right through. How can be manage into different excel file or sheets?
More than a year ago
I want help when I export my submission in to excel sheet the excel sheet appear all the information even information that I delete it when I build my form so how can I export it only with the information I want it
Thank you
More than a year ago
When I opened the excel document after download, it was blank, even though I have 13 submissions. Why is that?
More than a year ago
i've pressed the excel download, and all i get is the coded version of the submitter's answers.
More than a year ago
I was searching a lot to ascertain if a Form on click submit button saves it,but did not get result. you only confirmed it.Thanks,but where all saved Form are stored? can I have access to it? your tips are helpful. Is there any other method necessary to add to save the Form separately?
More than a year ago
Just received a form from a person to fill out. So stupid! NO idea how to save so half way through filling it out I hit some random key and LOST all of my entered responses. You should have a better way to save or something that is more user friendly. I will use this form for her because I HAVE to but I will not use these myself. Not user friendly.
More than a year ago
I downloaded the excel sheet but cant see the documents uploaded as attachments in excel
How do I do that?
More than a year ago
Thanks
I will tray
More than a year ago
Thank you, I will start doing it
then I let you know how is going
Thank again for the information
More than a year ago
I completed all three steps and says download complete ... but where did it go & how do I access it??
More than a year ago
My form has multiple products and multiple sub options. All product details came over to Excel in one column, I need a way to parse them out into its own column. What's the best way to do that?
More than a year ago
I don't see the export excel option. Is it still functioning?
More than a year ago
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?
More than a year ago
i have a lot of submissions but got a very small (50kb) xlsx file after pushing "export to excel"
why???
More than a year ago
The data is being transferred to the Excel spreadsheet, but is encoded. Is there a way for me to export it without the encoding?
More than a year ago
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?
More than a year ago
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)
More than a year ago
How can I export several forms in one excel?
More than a year ago
sir, I am facing a problem when submit a form and not showing redirectly submission.
More than a year ago
Hi can anyone show how will it look like?
More than a year ago
Is it possible to generate multiple submissions onto a single excel spreadsheet?
More than a year ago
Hey,
when I download the excel data, the sheet are empty...Please help! Thank you
More than a year ago
Hi,
Data is not exported to Excel.
Please help.
Thanks!
More than a year ago
how can i get the submission ID into my excel export?
More than a year ago
i have a form with over 500 submissions and the Submissions will not pull up so i can export.... what do i do?
More than a year ago
mi pregunta si puedo seleccionar todos los formularios que he creado y exportar los a un solo archivo de excel
More than a year ago
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?
More than a year ago
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?
More than a year ago
it out of order at 29-30, please help to fix it, i have many data need to export from excel T-T
More than a year ago
Hi ... my submissions are not showing up and I can not export to excel - is there something I am not doing quite right?
More than a year ago
Having managed IT teams for 10+ years, I wish I had thought this deeply about how to build our processes. Rather, I allowed myself to get caught up in doing 'stuff'. Will be passing this onto my old colleagues.
More than a year ago
not working!!!!
More than a year ago
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?
More than a year ago
Its not working, i can't get the excel file HELP!!!!!
More than a year ago
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.
More than a year ago
Hi. A blog that I read have simplified the process of exporting Form Data to Excel
More than a year ago
pls give suggestion for the exported business
More than a year ago
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
More than a year ago
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.
More than a year ago
The function of Export does not work now.
The situation has been lasting for half an hour.
More than a year ago
My form will not download in Excel or CSV format. Cannot integrate with Google Docs. Too many submissions?Help!
More than a year ago
Don’t Avoid Hard Tasks. So true. When you tackle the hard stuff first, the stuff that churns your stomach, the stuff that gives you the 'fear', everything else is so much easier.
More than a year ago
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.
More than a year ago
The excel document will not automatically update with new form submissions...why?
More than a year ago
Thank you for this very interesting reading. Have a nice day Aytekin. ;)
More than a year ago
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?
More than a year ago
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.
This is the form and i want to edit this form. Can you help?
More than a year ago
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.
More than a year ago
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."
More than a year ago
Is there a way to display the information submitted using the form on a webpage, right away after hitting the submit button?
More than a year ago
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
More than a year ago
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."
More than a year ago
how can i get php code to upload this form to my database? someone help:(
More than a year ago
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.
More than a year ago
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.
More than a year ago
CGA's question is a good one. Is there an answer?
More than a year ago
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.
More than a year ago
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.
More than a year ago
Is there a way to create one report for multiple forms?
More than a year ago
Since you have the Excel expport of your submissions you can delete your submissions.
More than a year ago
Once I export the data from my jotform excel sheet, can I delete that information to keep it from going on and on?
More than a year ago
Is this feature working now?
More than a year ago
I need this for products or service ordering & booking.
More than a year ago
This export is not working as of 12:11 PM EDT 9/14/2010 and I need it to be!