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 use the Spreadsheet to form widget?

    Asked by garry on July 12, 2017 at 07:00 PM

    Thank you for the immediate reply.

    However, the Spreadsheet-to-Form widget doesn't seem to be user friendly. I have uploaded a spreadsheet but then there is no instruction how to insert text fields that will be auto completed. How do we complete this widget?

  • Profile Image
    JotForm Support

    Answered by Mike on July 12, 2017 at 07:21 PM

    I would like to suggest checking the Spreadsheet to form widget description to get an idea on this.

    By using a unique code that is present on every row of your spreadsheet, you can access that specific row that matches the unique code.

    The values are automatically populated on your form fields, as long as the spreadsheet column headings match your form field labels.

    The widget supports short text entry, phonenumber, scale, single choice, multiple choice, drop down, rating, full name, time, email and long text entry.

    Let's say you have a form with the following labels.

    To configure widget yo need to upload the spreadsheet file, specify the 'Access Code Column' and 'Labels Row' values.

    According to the Access Code Column (A) and Labels Row (1), the spreadsheet file should have the following format. Notice that the column headings are matching with the form field labels.

    If you need any further assistance, please let us know.