- Jotform User Guide
- Jotform Tables
- How to Export Your Form Data to Excel
May 16, 2024
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.
Contact Support:
Our customer support team is available 24/7 and our average response time is between one to two hours.
Our team can be contacted via:
Support Forum: https://www.jotform.com/answers/
Contact Jotform Support: https://www.jotform.com/contact/
Send Comment:
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
119Comments:
David Dowell
118 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
View Answer
BBates
263 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?
View Answer
Jodi co*ckerham
278 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?
View Answer
Eloise
309 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?
View Answer
Andy Rodriguez
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
View Answer
Norene Marinelli
More than a year ago
I am trying to download an excel . It keeps downloading but nothing happens
View Answer
Summer
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
View Answer
Mir Bilal
More than a year ago
i need last 4months snap
View Answer
Colbrow Medics
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
View Answer
Michael Brown
More than a year ago
Do we have the ability to export at time of submission to an attachment?
View Answer
Celina Pinedo
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!
fatin97umairah
More than a year ago
Hi,
May I know if jotform allows to cross tabulate data from my survey? If yes, how?
View Answer
directeffect1211
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...Seniorscholarsnc
More than a year ago
Can you tell me the name of the export directory?
View Answer
Siffrin3688
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?
View Answer
Ash*t Patel
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.
View Answer
papgpk
More than a year ago
Can I combine all submissions to a single excel file before download?
punjultyoso
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 signatureView Answer
lauriewhite10
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...
View Answer
JohnstoneSupply
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
View Answer
liannevoelm
More than a year ago
could the fields have names or 'alias' other than the full question on the form.?
View Answer
AsthmaNEAT
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, Aggiescotborders
More than a year ago
why do i not see any data when i export to excel?
View Answer
Ronpalmgren
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 sheetThus you can't use the data in the exported sheet for further analysis
pdulle
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?
View Answer
LHHSDRAMA
More than a year ago
I don't have a submissions tab or page. My Jotform does not look like this?
View Answer
myspringcreek
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.View Answer
Matthias Meier
More than a year ago
Downloading submissions as Excel Document ist not possible. theres always an error.
thank you for youre help !
Tristan72
More than a year ago
Manage my account
View Answer
shaareyzedek
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.
iveta.orbanova
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
ThanksView Answer
Cecilia Staunton
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!
LynWalker
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. LynView Answer
britishsuzuki
More than a year ago
the download only shows the date column and all the other data is blank! Help!
View Answer
Xaviercharter
More than a year ago
Jotform exported all my data except the first and last name field
View Answer
greencouncil
More than a year ago
How to export ==Payment Info== into the excel? Thanks
rcostaOOB
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 beforeView Answer
Mina
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.
View Answer
EHSDogs
More than a year ago
How do you have it export the excel to your google docs excel?
View Answer
Climate_Change
More than a year ago
Is there a way I can create an excel form template with the column widths predetermined?
View Answer
Hewtee
More than a year ago
Hi there,
Is there a way to separate item ordered into different rows?
Thank youView Answer
Ryan Shreve
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,
RyanView Answer
B12willinkle
More than a year ago
I need to export a spreadsheet of all form submissions to Excel. How do I do multiple submissions?
View Answer
rotaryallstar
More than a year ago
l want them to transfer the information automatically to an Excel spreadsheet
formpinky
More than a year ago
how to export the form records back to 1 year ago?
View Answer
AU_KW
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.
View Answer
AU_KW
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.
View Answer
ankasetiawan
More than a year ago
is free version able to excell ? pls advise
View Answer
AgilityAssoc.Canada
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.
RobertView Answer
RocioCorrea
More than a year ago
Hola:
De que forma puedo descargar todos los formularios al mismo tiempo?
y generar un respaldo.eView Answer
rubenh
More than a year ago
If the data is being downloaded encrypted ... how can I view the data
mhowe479
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.
View Answer
ritesh91
More than a year ago
how to send data from jotform to Google Spreadsheet
View Answer
QWERTYSPEAK
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?
View Answer
Martin Atamian
More than a year ago
How export results of a spreadsheet in form to google sheet?
View Answer
Faithholidays
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?
View Answer
Nourhan Ashraf
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 youView Answer
Shawtair
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?
View Answer
krystianakm
More than a year ago
i've pressed the excel download, and all i get is the coded version of the submitter's answers.
View Answer
Aryan K Sarma
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?
View Answer
tdubbeld
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.
View Answer
creaturedd
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?View Answer
Lucy
More than a year ago
Thanks
I will trayluce31911472
More than a year ago
Thank you, I will start doing it
then I let you know how is going
Thank again for the informationView Answer
memphisjrtennis
More than a year ago
I completed all three steps and says download complete ... but where did it go & how do I access it??
View Answer
susantjipto
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?
zuvaa
More than a year ago
I don't see the export excel option. Is it still functioning?
View Answer
ToriChavez
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?
View Answer
thestudyplace
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???
View Answer
chsmc
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?
aritsm
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?
cris74
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)rpautassi
More than a year ago
How can I export several forms in one excel?
pardeep
More than a year ago
sir, I am facing a problem when submit a form and not showing redirectly submission.
success200
More than a year ago
Hi can anyone show how will it look like?
Nikita Varman
More than a year ago
Is it possible to generate multiple submissions onto a single excel spreadsheet?
JuzSchieder
More than a year ago
Hey,
when I download the excel data, the sheet are empty...Please help! Thank you
RuudvdO
More than a year ago
Hi,
Data is not exported to Excel.
Please help.
Thanks!aymi
More than a year ago
how can i get the submission ID into my excel export?
white_cap
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?
osardeleon
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
jpyles
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?
uofsc_cmcis
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?
2maxgroup
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
gymvic
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?
blakefam
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.
sastclub
More than a year ago
not working!!!!
hepvd_insertion
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?
atomiko1
More than a year ago
Its not working, i can't get the excel file HELP!!!!!
noli414
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.
Scott Carter
More than a year ago
Hi. A blog that I read have simplified the process of exporting Form Data to Excel
guest_22791436252050
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 spreadsh*t with all informations in Dropbox.
How can I do that??
Cheers,
TLSTUUCAuction
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.
formmm
More than a year ago
The function of Export does not work now.
The situation has been lasting for half an hour.DailyMirror
More than a year ago
My form will not download in Excel or CSV format. Cannot integrate with Google Docs. Too many submissions?Help!
Michael
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.
celebratelife
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.celebratelife
More than a year ago
The excel document will not automatically update with new form submissions...why?
Aiven
More than a year ago
Thank you for this very interesting reading. Have a nice day Aytekin. ;)
lgoldish
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?
achint
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?
View Answer
julio_auscube
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.
altpress
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."
spoonfulofdelight
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?
show
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
Linda Anderson
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."
austin
More than a year ago
how can i get php code to upload this form to my database? someone help:(
GetPreparedStuff
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.
JotFormSupport
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 reportIMPORTANT: Please ask your questions to the forum.
ASRA
More than a year ago
CGA's question is a good one. Is there an answer?
Cga
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.
JotFormSupport
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.
mmatthews
More than a year ago
Is there a way to create one report for multiple forms?
JotFormSupport
More than a year ago
Since you have the Excel expport of your submissions you can delete your submissions.
BayshoreTP
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?
undone
More than a year ago
Is this feature working now?
allyally
More than a year ago
I need this for products or service ordering & booking.
facesbydesign
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!
