How can users copy / paste data into a form table?

I need to create a form that allows users to copy data from an Excel spreadsheet and paste it into a table in the form. This data would only have 2 columns but could have variable rows (10 or 100, don't know ahead of time).

Hi Michael,

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.

You can create a form that allows users to copy and paste data from an Excel spreadsheet into a table with variable rows and two columns. Let me show you how to do it:

1. Open your Jotform Tables page and click on Create Table on the left side of the screen.
2. Select Blank, enter a name for your table, and click on Create Table.
3. Click on the Add button on the top of the page to add columns matching your data (e.g., two columns).
4. Follow the instructions to create the columns.
5. To see your form, click on the Three Dots icon on the tab, select Form, and click on View Form.

This setup will allow users to paste data into the table with the specified columns and variable rows.

Let us know if you have any other questions.

Hi Michael,

I understand you’d like your users to be able to copy and paste data from Excel into a form table with two columns and a variable number of rows. At the moment, the Input Table field or the Spreadsheet widget doesn’t support bulk pasting from Excel directly. Users would still need to type or copy/paste data into the table row by row. Here’s a quick screencast sample:

As an alternative, you can try the Spreadsheet to Form widget. This lets you upload an Excel file and automatically populate fields in your form using a unique code. You can check out this guide for details. 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:

Give it a try and let us know if you need any help.

Thanks for the reply. It doesn't look like you have anything that will allow users to copy / paste multiple rows and columns into a table. The Spreadsheet to Form widgets will not work either, as we need to be able to create multiple rows of data, not just fill out form fields.

Hi Michael,

As mentioned earlier, Jotform currently does not offer a feature that allows users to copy and paste multiple rows and columns directly into a form table to create multiple rows of data within the form itself.

The Spreadsheet to Form widget is designed to autopopulate form fields based on a unique code but does not support creating multiple rows dynamically in a table format.

For now, a possible workaround is to use Jotform Tables separately, where users can paste bulk data into a table with multiple columns and rows, but this is outside the form submission process. Check out our guide on How to Share Your Submission Tables with Jotform Tables and Collaborate to learn more.

Let us know if you have any other questions.