How to Set Up the Spreadsheet Widget?

December 7, 2023

When spreadsheet data needs to be collected, analyzed, and submitted in a simple spreadsheet format, the Spreadsheet widget is the ideal tool you can use. Your form users can now submit structured data sets that you can use in a spreadsheet – or for any purpose where cell-value data sets are critical.

This guide will show you how to set up the Spreadsheet widget. Please watch the following video or read below for the steps:

  1. In the Form Builder, click the Add Form Element button.
  2. Go to the Widgets tab.
  3. Search for Spreadsheet, and click it to add.
jotform-widgets-spreadsheet
  1. Set up the following options in the Widget Settings:
    • Number of Rows — To display how many rows you want to add.
    • Number of Columns — To display how many columns you want to add.
    • Column Labels — You can use this section to show a different label instead of the letters. Adding labels is optional.
    • Default Values — In this section, you can add a value for each cell in the Spreadsheet.
    • Read Only — This section is where you can set cells as read-only.
  1. Click the Update Widget button to save your settings.

Column Labels

The first two options are straightforward, so let’s start with the Column Labels. As explained above, this allows you to change the letters to custom cell labels. See the below image as an example of the labels:

jotform-widgets-spreadsheet-column-labels

Note:

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

Default Values

The first three options are straightforward, so let’s start with the Default Values box. For example, you want Column A, Row 1, with a value of 1500. You only need to enter A1 1500 at the Default Value box. See the below image:

jotform-widgets-spreadsheet-default-values

You can also assign a calculation value for a specific cell. The calculation formula will only need to start with the Column Letter and Row Number followed by a single space, an equal sign (=), and then the equation of cells. For example, if you want the sum of Row 1, Columns A, B, and C to Row 1, Column D, enter the following formula:

D1 = A1+B1+C1

jotform-widgets-spreadsheet-sum-cells

Note:

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

Read Only

This section allows you to set cells as non-editable. Useful for cells with the calculated value. For example, if you want to make all Five (5) rows of Column D non-editable, input D1, D2, D3, D4, D5 in the Read-only box.

jotform-widgets-spreadsheet-read-only

You can see the demo form here: https://www.jotform.com/222478575946068.

Academy Logo

Introduction to Form Building

Explore Widgets

Go to course :Explore Widgets
lesson-2 - image
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:

  • 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