How to Set Up the Spreadsheet Widget?

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.

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.

2. Under the Widgets tab, search for Spreadsheet widget.
3. Drag and drop or click it to add it to your form.

• Click on the Wand icon to open the Widget Settings.

4. 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.

5. 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 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.

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.

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:

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

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

You can see the demo form here.