How can I auto populate form fields from an Excel sheet?

When I select "form", I would like have a list of names for the respective items along with email addresses.  I also would only like the item that I select have those names visible. I have an excel sheet with these items but can't find where to do this.  Thank you

From my understanding, what you're trying to achieve is to pull data from an external source such as an Excel file to populate your form fields. Am I correct?

I believe that a Spreadsheet to Form widget could come in handy for this requirement. By using a unique code that is present in 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.

However, it can only pull one row of data (from Excel) at a time by utilizing a Unique Code or a Primary Key (as we call it in a database). Here's a guide on How-to-Use-the-Spreadsheet-to-Form-Widget.

You can go check this demo form and see if it satisfies the requirement:

https://www.jotform.com/71642066575965

But in case you're referring to something else, let us know in detail so we could check for possible workarounds.