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

    How to import data into a form and prepopulate the fields automatically

    Asked by dorsetholidaylets on October 26, 2014 at 05:28 AM

    I organise a charity bike ride each year and many of the entrants enter the following year so I already have the name, address, telephone, age, next of kin details. In future I would like to setup our entry form so if they type in their email address and we already have their details, the form is populated with the data we already have, which they can then amend if required.

    Is there an easy way of doing this? 

    The entry form will change slightly each year.

    I have the data on a spreadsheet.



  • Profile Image
    JotForm Support

    Answered by Jan on October 26, 2014 at 08:26 AM

    Hi dorsetholidaylets,

    We currently don't have a way to import data from database and pre-populate the form fields. However, we have 2 apps that might help you.

    Import Data (http://import.jotform.io/)

    You can import submissions from CSV or Excel and combine them with your Jotform submission data.

    Field Prepopulator (http://prepopulate.jotform.io/)

    Pre-populate the fields before sending it to user that will fill up the form


    Hope this helps. Thanks!