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

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

    Asked by Lucas Fraser 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
    JotForm Support

    Answered by Mike_T 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

    Answered by Lucas Fraser 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 lucas.fraser@myaccess.coop
    Fax 306-565-5395
    2250 Park St . Regina . Saskatchewan . S4N 7K7
  • Profile Image
    JotForm Support

    Answered by jonathan 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 by lalgeorgek 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 by Sean 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: http://apps.jotform.com/app/import_data 

    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.