How to pre-populate data to the form from an Excel file?

  • Profile Image
    Asked on August 30, 2017 at 11:12 PM

    Do this one still work -

    I tried it and it doesn't seem to work.


    I'm also looking at this option ( but pre-populating using the URL parameter seems too much work especially if you have hundreds of data.

    I'm talking about this form

    When user will click on the REGO, it will populate the rest of the fields. But in this example, I only have 3 options. I want to have let us say 50 options. How to make that easier?

  • Profile Image
    Answered on August 31, 2017 at 12:06 AM

    The Import Data app will import the data as submissions, but cannot be loaded when your users are loading your form.

    I would recommend you to instead use the Spreadsheet to Form widget which will allow you to achieve exactly what you're looking for. 

    Please find the widget here: 

    Here is also a guide that will help you to implement the widget on your form: 

    I hope this helps.