How to Add and Set Up the Spreadsheet Widget on Your Form

Jotform’s Spreadsheet widget lets you add a clean, Excel-style table to your form so users can input data in rows and columns, just like a real spreadsheet. It’s perfect for capturing itemized details, multiple values, or grouped information all in one place. This will help you collect structured data like budgets, schedules, inventories, or multi-row entries.

Add and customize the Spreadsheet widget to your form to allow form users to input and submit data in a familiar table layout. It’s easy, here’s how:

1. In Form Builder, click on Add Element on the left side of the page.

2. Now, in the Form Elements menu, under the Widgets tab, search for Spreadsheet and then click on it. Or, just drag and drop it to where you want it to be on your form.

3. Next, in the Widget Settings window that opens on the right side of the page, under the General tab, set up the following options:
   • Number of Rows — Edit this to define how many rows appear in the spreadsheet
   • Number of Columns — Set this up to modify the total number of columns in the spreadsheet.
   • Column Labels — Enter here the names of each column for clarity, separating them by a comma or a newline.

4. Then, scroll down to the bottom and continue to set up these options:
   • Default Values — Set this up to pre-fill cells in the spreadsheet with values before the user interacts with it, adding each default value or formula in a separate line.
   • Read Only — If you add specific cell names here, those cells will be locked, users won’t be able to make any changes to them. Typing “All” will lock all cells.
5. Once you’re done, click on Update.

That’s it. You’ve successfully added and set up the Spreadsheet widget to your form. Now, you’ve added an Excel-style table to your form, allowing users to enter data across multiple rows and columns. A great way for collecting itemized lists, budgets, schedules, time logs, or grouped data in a single field. To see how it looks on a live form, check out this Demo Form.

To further customize your Spreadsheet field appearance, just click on the Gear icon to open its properties. For a full breakdown of how to do it, head over to our guide on [Ongoing Redirect Link].