JotForm User Guide / Manage Forms /

How to Export Form Data to Excel

How to Export Form Data to Excel

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

1. Login to JotForm and go to the MY FORMS page.

2. Click the form name you want to export submissions to Excel from then click the SUBMISSIONS button.

3. On the Submissions Page, scroll down the page until you see the grid table. Right above the Submission Date title you will see the Download as: EXCEL button.

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

Send Comment

89 Comments...

See all comments
  • Tristan72

    Manage my account

  • shaareyzedek

    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

    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

  • Cecilia Staunton

    https://www.jotform.com/build/92655090103148?iak=76a08773f5697e74c6d9acb4292a83bf-91c7529883946de3
    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

    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

  • britishsuzuki

    the download only shows the date column and all the other data is blank! Help!

  • Xaviercharter

    Jotform exported all my data except the first and last name field

  • greencouncil

    How to export ==Payment Info== into the excel? Thanks

  • rcostaOOB

    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

  • Mina

    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.

  • EHSDogs

    How do you have it export the excel to your google docs excel?

  • Climate_Change

    Is there a way I can create an excel form template with the column widths predetermined?

  • Hewtee

    Hi there,
    Is there a way to separate item ordered into different rows?
    Thank you

  • Ryan Shreve

    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

  • B12willinkle

    I need to export a spreadsheet of all form submissions to Excel. How do I do multiple submissions?

  • rotaryallstar

    l want them to transfer the information automatically to an Excel spreadsheet

  • formpinky

    how to export the form records back to 1 year ago?

  • AU_KW

    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.

  • AU_KW

    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.

  • ankasetiawan

    is free version able to excell ? pls advise

  • AgilityAssoc.Canada

    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

  • RocioCorrea

    Hola:
    De que forma puedo descargar todos los formularios al mismo tiempo?
    y generar un respaldo.e

  • rubenh

    If the data is being downloaded encrypted ... how can I view the data

  • mhowe479

    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.

  • ritesh91

    how to send data from jotform to Google Spreadsheet

  • QWERTYSPEAK

    Can we, by typing in the form data, have our Excel sheet filled with information after it is downloaded in our computer?

  • Martin Atamian

    How export results of a spreadsheet in form to google sheet?

  • Faithholidays

    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?

  • Nourhan Ashraf

    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

  • Shawtair

    When I opened the excel document after download, it was blank, even though I have 13 submissions. Why is that?

  • krystianakm

    i've pressed the excel download, and all i get is the coded version of the submitter's answers.

  • Aryan K Sarma

    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?

  • tdubbeld

    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.

  • creaturedd

    I downloaded the excel sheet but cant see the documents uploaded as attachments in excel
    How do I do that?

  • Lucy

    Thanks
    I will tray

  • luce31911472

    Thank you, I will start doing it
    then I let you know how is going
    Thank again for the information

  • memphisjrtennis

    I completed all three steps and says download complete ... but where did it go & how do I access it??

  • susantjipto

    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

    I don't see the export excel option. Is it still functioning?

  • ToriChavez

    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?

  • thestudyplace

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

    why???

  • chsmc

    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

    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

    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

    How can I export several forms in one excel?

  • pardeep

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

  • success200

    Hi can anyone show how will it look like?

  • Nikita Varman

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

  • JuzSchieder

    Hey,

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

  • RuudvdO

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