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.

Here are a few ways to use it:

• Collect structured data in rows and columns — Perfect for things like budgets, inventories, schedules, or item lists where information needs to be organized neatly.
• Let users input multiple entries in one place — Instead of filling out separate fields, users can add several rows of related data in a single spreadsheet-style view.
• Track or manage detailed records — Great for logs like attendance, work hours, project tracking, or expense records.
• Simplify data collection for complex forms — Helps reduce clutter by grouping related information together in a clean, familiar spreadsheet layout.

Adding and Setting Up the Spreadsheet Widget

Add and customize the Spreadsheet widget to your form to allow form users to input and submit data in a familiar table layout. Setting it up takes no time at all—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 How to Access and Configure the Question Properties of a Widget.