How to Set Up the Spreadsheet Widget?

February 7, 2025

When you need to collect, analyze, and submit data in a structured spreadsheet format, the Spreadsheet widget is the perfect tool. It allows form users to input and submit data in a familiar table layout, making it easy to manage and use for various purposes, such as reporting or data analysis.

Youtube Embed Poster: xEi3G5LpADc

Setting Up the Spreadsheet Widget

To set up your Spreadsheet Widget, follow the steps below:

  1. In the Form Builder, click the Add Element button.
Add Element button in Form Builder Jotform
  1. Under the Widgets tab, search for Spreadsheet widget.
  2. Drag and drop or click it to add it to your form.
Spreadsheet widget in Widgets tab in Jotform
  • Click on the Wand icon to open the Widget Settings.
Wand icon of Spreadsheet widget in Jotform
  1. Under General tab, set up the following options:
    • Number of rows — Specify how many rows you want to display.
    • Number of columns — Choose how many columns you want to add.
    • Column labels — Optionally, add custom labels instead of default letters.
    • Default values — Set default values for each cell in the spreadsheet.
    • Read-only — Mark certain cells as read-only if needed.
General tab of Spreadsheet widget in Jotform
  1. Click the Update Widget button to save your settings.

If you want to customize the design of your widget, click on the Custom CSS Tab. See How to Inject CSS Codes to Widgets for more information.

Configuring General Tab

To customize the layout and functionality of your Spreadsheet widget, you can adjust various settings under the General tab. These options help you define the structure of your spreadsheet, pre-fill cells with values, and make specific cells read-only for a more tailored user experience.

Number of Rows

This option allows you to specify how many rows you want to display in the Spreadsheet widget. For example, if you’re collecting data for 5 entries, you would set the number of rows to 5. This controls the vertical layout of the data that users will be able to input.

Number of Rows in General tab of Jotform Widget Spreadsheet

Number of Columns

Here, you define how many columns you need in the spreadsheet. For instance, if you want to collect data like “Product Name,” “Quantity,” and “Price,” you would set the number of columns to 3. This ensures that the data is structured in a way that suits your needs.

Number of Columns in General tab of Jotform Widget Spreadsheet

Note

You can set the Number of Columns in your Spreadsheet widget up to a maximum of 52.

Column Labels

This option allows you to replace the default column letters (A, B, C, etc.) with custom labels. For example, instead of “A,” “B,” and “C,” you can label them as “Product Name,” “Quantity,” and “Price.” To do this, just input the labels, separated by commas or new lines.

Column Labels in General tab of Jotform Widget Spreadsheet

Note:

The widget will require you to input labels for all columns, each separated by a comma or a new line.

Default Values

The “Default Values” box allows you to pre-fill cells with values, which helps speed up the data entry process for users. For example, if you want Column A, Row 1, to have a value of “1500,” you simply enter “A1 1500” in the Default Values box. Here’s an example:

Default Values in General tab of Jotform Widget Spreadsheet

You can also assign calculation formulas to specific cells. For instance, if you want the sum of Row 1, Columns A, B, and C to be displayed in Row 1, Column D, enter the following formula:

  • D1 = A1 + B1 + C1
Default Values in General tab of Jotform Widget Spreadsheet

Note:

The Spreadsheet widget supports Match Functions as referenced from this page: Mozilla – Math JavaScript Functions.

Read Only

The Read-Only section allows you to lock specific cells so users can view them but cannot make any changes. This is especially useful for cells containing calculated results. For example, if you want to make Column D, Rows 1 to 5, non-editable, you would input “D1, D2, D3, D4, D5” in the Read-Only box. This ensures that users can only view the calculated results without modifying them.

  • D1, D2, D3, D4, D5
Read-only in General tab of Jotform Widget Spreadsheet

You can see the demo form here.

Join the Live Launch Event
Contact Support:

Our customer support team is available 24/7 and our average response time is between one to two hours.
Our team can be contacted via:

Support Forum: https://www.jotform.com/answers/

Contact Jotform Support: https://www.jotform.com/contact/

Send Comment:

Jotform Avatar
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Comments:

  • David Chionsini - Profile picture
  • billflinn - Profile picture
  • Fisioterapia da CTI_HGF - Profile picture
  • Emmanuel Navarro Domínguez - Profile picture
  • text%253Dgescom - Profile picture
  • thastings - Profile picture
  • Office - Profile picture
  • Bo Bergstrom | OGx - Profile picture
  • Ulva Zell - Profile picture
  • Office - Profile picture
  • Kim - Profile picture
  • Procurement SCME - Profile picture
  • Kristin Garvey - Profile picture
  • tecknow - Profile picture
  • Pe. Davi - Profile picture