What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Get submissions automatically to excel

    Asked by guest_23044619460046 on October 31, 2012 at 12:59 PM

    Hi!

    Is it posssible to get the submissions automatically to MS excel?! Perhaps with a "import external data" tool in excel?!

     

    It would be nice, if you send me an answer!

     

    Thanks!

    Submissions excel thanks
  • Profile Image

    Answered by moonzkie on October 31, 2012 at 01:05 PM

    Hi,

    Unfortunately, such automatically importing data to excel is not available as of the moment What you can do is to simply create an Excel report and bookmark the URL provided on your browser. That link will always bring you the latest updates. So, all you need to do is to click on your bookmark and you will get all entries.

    Thank you for using Jotform. Let us know if there's anything else that you require assistance with.

  • Profile Image

    Answered by cripploh on November 05, 2012 at 02:55 PM

    Hi! I tried it, the way you described it. It works BUT the link will not bring me the latest updates - it will bring me all submissions.

    My Question: Is it possible to delete the submissions, when they are downloaded one time (1x)?! If that will be possible, I will get only the latest submissions (only unreaded).

     

    I hope of an answer! Thanks!

  • Profile Image

    Answered by jeanettebmz on November 05, 2012 at 04:10 PM

    You cannot delete the submissions unless you enter into your account and do it manually either one by one ,or selecting the button DELETE ALL. 

    However, if you want to show only the recent ones, I think an alternative could be to integrate Jotform with either Google Spreadsheets or Google Drive. 

    This way you can sort the submissions like in any spreadsheet, from newer to older

  • Profile Image

    Answered by cripploh on November 06, 2012 at 11:38 AM

    Hi Jeanette, I have already tried it with Google Spreadsheet. It works good! BUT I found no way to sync Google Spreadsheet with my (offline) Excel. Also the test via Google Drive (and Dropbox) didn´t led ultimatly to the wished result.

    My goal: I need the submission-data offline for further processings.

    I have found a way on the basis of the idea of moonzkie (see above) in combination with some macros. It works but is not very stable and complicated. It is also difficult to automatethis solution.

    ...perhaps you have another idea for me?!

     

    Thanks!

    Claus

  • Profile Image

    Answered by jeanettebmz on November 06, 2012 at 11:46 AM

    Hello Claus

    If what you want to do is to work offline using Excel, another simple way would be to download the Excel file either partial submission or all of them . Please check these two guides to see further details

    How to Export Form Data to Excel?

    Excel/CSV reports-partial download 

     

    Cheers!

  • Profile Image

    Answered by cripploh on November 06, 2012 at 12:05 PM

    My solution is based on an download (as an Excel sheet) via bookmarked link. My problem is, that it is always a new file. So I have to import the (downloaded) submissions of the excel sheet via macro to my application, on which I am working.

    Has jotform a wishlist ?!

  • Profile Image
    JotForm Support

    Answered by EduardoMendez on November 06, 2012 at 12:37 PM

    Hi there,

    Yes, you can make a request on this thread and I will submit the request to our dev team.

    May I ask about What happened with Google spreadsheets that stopped you from using such integration?

    Here is a link that may give you more information about using Google spreadsheets offline:

    http://support.google.com/drive/bin/answer.py?hl=en&answer=1628467

    Hope that helps!

  • Profile Image

    Answered by sstratt1 on December 04, 2013 at 10:54 AM

    Any updates on this project?

     

    Thanks,

    Cole

  • Profile Image

    Answered by pinoytech on December 04, 2013 at 12:16 PM

    Hi Cole,

    With regards on your query, request you to please open/create a separate thread for further assisance.

    Thanks,