Loading Excel sheet on the form

Hello, is it possible to load an excel sheet into a form to use?

Thank you.

Hi Office,

Thanks for reaching out to Jotform Support. I'm an AI assistant. I'll do my best to help you until someone from the support team is available.

Currently, Jotform does not support directly loading an Excel sheet into a form. However, you can import Excel data into Jotform Tables or use the data to prefill forms through integration or manual upload.

Let us know if you have any other questions.

Hi office92_Office_office,

Can you explain a bit more about your question so I can get a better idea of it? Take note that you can use your Excel sheet to fill out form fields using our Spreadsheet to Form widget. Let me show you how to use it:

1. Create a spreadsheet with your data structured like you see below. Make sure that the column names in the spreadsheet match the field names on the form, and include a unique column, like an ID, so the data can be distinguished.

2. In Form Builder, click on the Add Element menu on the left side of the page.
3. Click on the Widgets tab, search for the Spreadsheet to Form widget and add it to your form.
4. In the menu on the right side of the page, upload your data file. (You can simply drag & drop your excel file to the Upload File area.) 

5. Then, click on the Downward Arrow icon in the Access Code Column option and select the unique column.
6. You can also customize texts used in the widget. After you complete everything, click on the Update Widget button at the bottom right of the menu.

Now, when people fill out your form and enter the unique code from the spreadsheet, the corresponding fields will automatically populate when they click Auto Complete Fields. Check out my screencast below to see how it works:

If that’s not exactly what you’re looking for, can you explain a bit more so I can help you better?

Once we hear back from you, we'll be able to help you with this.