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

    Populate form field with data from a spreadsheet?

    Asked by eaguiar on June 13, 2017 at 05:17 AM

    I am looking for this. I would like to fill some data of the form that will be picked from a spreadsheet. 

    For example: user enters his user number,  with that user number jotform will enter other fields of the form with data from the spreadsheet (name of the user, favorite templates, paying method, discounts etc.. 


    Is this possible? 

  • Profile Image
    JotForm Support

    Answered by Charlie on June 13, 2017 at 05:22 AM


    If you want to populate some form fields based on a unique code or key from the spreadsheet, then you can try using the Spreadsheet to Form widget. You can add widget to the form by following this guide: https://www.jotform.com/help/252-How-to-Add-a-Widget-to-your-Form.

    I hope that helps.