JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Is it possible to merge/insert a very large excel spreadsheet into Jotform without recreating the sheet in a widget?Asked by MarisaRowe on August 03, 2016 at 11:37 AM
My organization put together an Excel Spreadsheet cataloging several hundred art pieces for our subsidiary programs to order. We've created a simple JotForm ordering form, but it would be helpful if I could insert the Excel spreadsheet (268 rows x 6 columns) into the JotForm without having to recreate it using the Spreadsheet widget. Any information would be greatly appreciated.
Unfortunately, it's not possible. It's the formatting that makes it impossible to just copy/paste data. You have to define the values in each row/column, like the one in the instruction such as a1 XXXX where XXXX is the value of Column A, Row 1.
The spreadsheet widget is a read-only field in general, the calculation in the widget is useful if you're going to let people enter values in every row but I think your spreadsheet is static. Why not upload the file online and embed it? For example, import the file to Google Spreadsheet. You can then use the iframe embedder widget to display the spreadsheet in the form: http://widgets.jotform.com/widget/iframe_embed.