Pre-filling form from external source (ex. excel file)

  • Profile Image
    Lucas Fraser
    Asked on July 29, 2013 at 03:59 PM


    I need to know if your product can pre-fill a form from an external source like an excel file. 



  • Profile Image
    Answered on July 29, 2013 at 05:41 PM

    Thank you for your interest in our service.

    Forms can be pre-populated via URLs and submitted via API. If you have some specific requirements, please let us know. We will see if we have any solution available.

  • Profile Image
    Lucas Fraser
    Answered on July 29, 2013 at 05:58 PM
    Hey Mike,
    I’m looking to export some data from our DB into a file. From that file I would like to be able to draw info from that file when our guy selects a date. It would then fill in fields like name, address,etc.
    [Access Communications]
    Lucas Fraser
    IS Network Manager . Access Communications Co-operative Limited
    Phone 306-565-5369 . Email
    Fax 306-565-5395
    2250 Park St . Regina . Saskatchewan . S4N 7K7
  • Profile Image
    Answered on July 29, 2013 at 07:44 PM

    Hi Lucas,

    From my assessment so far, since the JotForm form is web based, it would be more simple if you can first post the info into the web so that you can then push the info via URL method to the JotForm form's field.

    Please review this guide also How-to-Enable-Prepopulating-Fields to give you idea how to do it also using the form's source code

    Hope this help. Please inform us if you have further inquiry.


  • Profile Image
    Answered on March 12, 2015 at 07:26 AM

    Dear Jonathan, 


    I would like to know if we have any option where we can upload an excel file to jotform with the fields available in the form. 

    Same fields should reflect in the form with a submit option. 


    Lal K George

  • Profile Image
    Answered on March 12, 2015 at 10:43 AM

    We have an app that can be used to import data (previous submissions) from excel files to add to existing form submissions . You can view it here: 

    This app will simply amend the submissions listing for your form and it will not add the Excel file to your uploaded files for access. Can this work for you? Please advise.