Import data from excel to a form

  • Profile Image
    Asked on August 29, 2019 at 05:09 AM


    I was wondering is it possible to get data from excel to a form. 

    For example we want to sent a survey to a part of our customers, every customer has is own customer number. I want to see which customer has filled in the survey based on the customer numer or transaction number. 

    Is this possible?

    Kind regards, 

    Marc Giesen 

  • Profile Image
    Answered on August 29, 2019 at 05:19 AM

    You may consider using the Spreadsheet to Form widget:


    The Spreadsheet to Form Widget allows you to upload a spreadsheet to your form and use the values you have on the spreadsheet to pre-populate the form. By using a unique code present on each row of your spreadsheet, you can access that specific row when it matches the unique code entered on the form. Think of it as querying a database using the Unique Code as the key index.

    Let us know if you have further questions.