Import data to spreadsheet widget

Hello,

is it possible to import data from a csv/excel spreadsheet into the jotforms spreadsheet widget which we are using for a parts order/authorisation form. This would save us having to type everything in twice.

I would be happy with being able to copy and paste but that only works one cell at a time.

Is there a better way to have a spreadsheet type format for parts order. or am using the wrong thing?

New to jotforms so still finding my way around this.

The attached pic shows an example - what we need is;

Line 1 Description, Part No, Unit Cost, Qty (calculated subtotal)

x 70 lines

Grand Total last line (calculated total of lines 1-70 subtotals )

hoping for some clever solutions!

Thank you

Greetings.

Unfortunately, it is not possible to import data to the Spreadsheet widget, however, you can upload it to Google Sheets, and then display it in your form using the iFrame widget.

Let us know if this solution works for you.