This guide shows you how to export your form entries to an Excel file. For more options, see Downloading Form Submissions as Excel, CSV, or PDF.
To download your submission data as an Excel file
- Go to My Forms and choose your form.
- Select Submissions at the top.
- In Tables, select Download All in the upper-right corner, then Download as Excel from the menu.
You can also find these 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:
118 Comments:
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?
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?
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?
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
I am trying to download an excel . It keeps downloading but nothing happens
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
i need last 4months snap
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
Do we have the ability to export at time of submission to an attachment?
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!
Hi,
May I know if jotform allows to cross tabulate data from my survey? If yes, how?
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...
Can you tell me the name of the export directory?
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?
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.
Can I combine all submissions to a single excel file before download?
when downloading the submission as excel, the signature did not display only its link
please giving any suggestion to display the signature
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...
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
could the fields have names or 'alias' other than the full question on the form.?
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
why do i not see any data when i export to excel?
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
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?
I don't have a submissions tab or page. My Jotform does not look like this?
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.
Downloading submissions as Excel Document ist not possible. theres always an error.
thank you for youre help !
Manage my account
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.
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
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!
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
the download only shows the date column and all the other data is blank! Help!
Jotform exported all my data except the first and last name field
How to export ==Payment Info== into the excel? Thanks
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
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.
How do you have it export the excel to your google docs excel?
Is there a way I can create an excel form template with the column widths predetermined?
Hi there,
Is there a way to separate item ordered into different rows?
Thank you
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
I need to export a spreadsheet of all form submissions to Excel. How do I do multiple submissions?
l want them to transfer the information automatically to an Excel spreadsheet
how to export the form records back to 1 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.
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.
is free version able to excell ? pls advise
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
Hola:
De que forma puedo descargar todos los formularios al mismo tiempo?
y generar un respaldo.e
If the data is being downloaded encrypted ... how can I view the data
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.
how to send data from jotform to Google Spreadsheet
Can we, by typing in the form data, have our Excel sheet filled with information after it is downloaded in our computer?
How export results of a spreadsheet in form to google sheet?
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?
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
When I opened the excel document after download, it was blank, even though I have 13 submissions. Why is that?
i've pressed the excel download, and all i get is the coded version of the submitter's answers.
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?
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.
I downloaded the excel sheet but cant see the documents uploaded as attachments in excel
How do I do that?
Thanks
I will tray
Thank you, I will start doing it
then I let you know how is going
Thank again for the information
I completed all three steps and says download complete ... but where did it go & how do I access it??
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?
I don't see the export excel option. Is it still functioning?
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?
i have a lot of submissions but got a very small (50kb) xlsx file after pushing "export to excel"
why???
The data is being transferred to the Excel spreadsheet, but is encoded. Is there a way for me to export it without the encoding?
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?
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)
How can I export several forms in one excel?
sir, I am facing a problem when submit a form and not showing redirectly submission.
Hi can anyone show how will it look like?
Is it possible to generate multiple submissions onto a single excel spreadsheet?
Hey,
when I download the excel data, the sheet are empty...Please help! Thank you
Hi,
Data is not exported to Excel.
Please help.
Thanks!
how can i get the submission ID into my excel export?
i have a form with over 500 submissions and the Submissions will not pull up so i can export.... what do i do?
mi pregunta si puedo seleccionar todos los formularios que he creado y exportar los a un solo archivo de excel
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?
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?
it out of order at 29-30, please help to fix it, i have many data need to export from excel T-T
Hi ... my submissions are not showing up and I can not export to excel - is there something I am not doing quite right?
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.
not working!!!!
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?
Its not working, i can't get the excel file HELP!!!!!
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.
Hi. A blog that I read have simplified the process of exporting Form Data to Excel
pls give suggestion for the exported business
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
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.
The function of Export does not work now.
The situation has been lasting for half an hour.
My form will not download in Excel or CSV format. Cannot integrate with Google Docs. Too many submissions?Help!
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.
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.
The excel document will not automatically update with new form submissions...why?
Thank you for this very interesting reading. Have a nice day Aytekin. ;)
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?
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?
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.
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."
Is there a way to display the information submitted using the form on a webpage, right away after hitting the submit button?
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
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."
how can i get php code to upload this form to my database? someone help:(
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.
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.
CGA's question is a good one. Is there an answer?
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.
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.
Is there a way to create one report for multiple forms?
Since you have the Excel expport of your submissions you can delete your submissions.
Once I export the data from my jotform excel sheet, can I delete that information to keep it from going on and on?
Is this feature working now?
I need this for products or service ordering & booking.
This export is not working as of 12:11 PM EDT 9/14/2010 and I need it to be!