Import data from excel to a form

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

    Hello, 


    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
    roneet
    Answered on August 29, 2019 at 05:19 AM

    You may consider using the Spreadsheet to Form widget:

    https://widgets.jotform.com/widget/spreadsheet_to_form

    Guide: https://www.jotform.com/help/442-How-to-Use-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.

    Thanks.