Import an Excel Spreadsheet into a Jotform?

The reason I require this instead of starting from scratch is because I have created a sheet that has dynamic data validation to ensure customers order parts that are compatible. This can't be done in jotform, or can it?

Hi InfoSA12,

Thanks for reaching out to Jotform Support. Are you trying to import an Excel Spreadsheet to your form and use the data to populate form fields? If yes, we have a Spreadsheet to form widget that you can use to import your data, but it won't populate the Product List field. Let me show you how to use it:

• Create a spreadsheet that includes your data in the structure you see below. It's important that the column names in the spreadsheet and field names on the form are the same.

• In Form Builder, click on the Add Form Element menu on the left side of the page.
• Under the Widgets tab, search for the Spreadsheet to Form widget and add it to your form.

• In the Widget Settings window that opens up, upload your data file and customize the other options. 
• Then, click on Update Widget.

• In the final stage, add the fields to view values and name them the same as on the spreadsheet.

Let us know if this works for you.