How can I extract all 7042 submissions in a file without scrambled code?

  • Profile Image
    Asked on August 23, 2013 at 02:08 AM


    We have finished an online petition using the form with ID=32241936760858. Now that we've got totally 7042 submissions. Is there a way to retrieve all the data from the table for all the submissions at once without breaking into two steps or several steps? The original export to excel function we've tried did not succeed at the second step for those after 5000 submissions. It showed some errors while we tried to open it up adter downloaded the 2nd one. We've also tried the CSV format but only gives us 5091 entries with some scrambled characters (it could be in ASCII format and the original information is supposedly in traditional Chinese). Or if we can get to use some API for this (I've checked the API doc site but not too sure about which one to use), it will be fine too. Please do let us know. Appreciated.

    Fred Wu

    CTO / Abraham Technology, Inc.


  • Profile Image
    Answered on August 26, 2013 at 10:21 AM

    Hello Mr. Wu,

    I am now focused on this problem and hope to solve it pretty soon.

    One can, of course, use Jotform API to get all of the submissions, however, it will be low level and one will be required to write all into a file. Related API call is here:

    I will update you about the progress. If I can do anything else, please let me know.

    Thank you

  • Profile Image
    Answered on September 29, 2014 at 05:17 PM


    If you are still using, we are happy to announce that now supports Jotform. You can now embed forms to your hosted websites. 

    Thank you!!