---
title: "Configuring Spreadsheet Widget"
slug: "configuring-spreadsheet-widget"
updated: 2025-06-11T20:44:30Z
published: 2025-06-11T20:44:30Z
canonical: "documentation.encodify.com/configuring-spreadsheet-widget"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.encodify.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Configuring Spreadsheet Widget

## How to create a Spreadsheet Widget

---

Follow these steps to configure a Spreadsheet Widget:

1. Navigate to the **Widget Library**(see [Manage Widgets](/v1/docs/manage-widgets) for more details)
2. Locate the **Spreadsheet** widget and click on its card.
3. Choose one of the following configuration options:
  - **Custom Widget Settings** (default): Apply bespoke settings to the widget.
  - **Embedded Module View**: Use a pre-configured [Module View](/v1/docs/module-views) with settings inherited from that view.
4. Select a **Module** from the dropdown list.
5. Enable or disable the **Widget Refresh Rate** (in seconds). If enabled, set a time interval at which the widget will automatically refresh.

If you selected **Custom Widget Settings,** then it’s possible to copy settings from a selected spreadsheet view using the **Copy Settings From a View** button. This allows you to quickly replicate the settings from a view that suits your needs. Lets explore the additional configuration options when this is done manually.

1. Select the **Fields to Show** within the widget. You can reorder them using the drag handles in the dropdown.
2. Choose a **Group By** field to apply default grouping to the search results.
3. Enable or disable the **Show Empty Groups** option.
4. Under **Fields for Totals**, select any fields you wish to display as summed values. These fields must also be included in **Fields to Show**.
5. Set a value for **Max Items for Totals**. The default is **10,000**; the value must be between **1** and **10,000**. If the item count exceeds this limit, the sum row will not be shown in the widget.

![](https://cdn.document360.io/3a63e0a8-1221-4570-aaa1-d43f9b95a612/Images/Documentation/workspace-spreadsheet-widget-custom-settings(1).png)

An image highlighting Custom Widget Settings within Spreadsheet Widget

If you selected **Embedded Module View**:

1. Select a **View** from the dropdown list.
2. Review the automatically populated settings—**Fields to Show**, **Group By**, and **Show Empty Groups**—which are inherited from the selected module view and cannot be changed.
3. Note that **Fields for Totals** and **Max Items for Totals** are **not supported** when using this option.

![](https://cdn.document360.io/3a63e0a8-1221-4570-aaa1-d43f9b95a612/Images/Documentation/workspace-spreadsheet-widget-embedded-settings.png)

An image highlighting Embedded Module View within the Spreadsheet Widget

Now let’s understand the remaining settings to complete the configuration of the Spreadsheet Widget.

1. Specify a **Filter** to limit the data returned and define which records should appear in the search results. To use an existing filter from the module, select **Saved Filters**. To create a new filter, choose **Custom Filter**.
2. Within Widget Actions, specify the behaviour of Add Item from the options: Inline, Form or Disabled
3. From the list of other **Widget Actions**, decide if there are specific operations you wish to restrict for the associated widget. You can search for widget actions and modify only the filtered actions using the **Select/Unselect All** option.

![](https://cdn.document360.io/3a63e0a8-1221-4570-aaa1-d43f9b95a612/Images/Documentation/workspace-spreadsheet-widget-actions.png)

An image highlighting Widget Actions within the Spreadsheet Widget

1. Navigate to the **Appearance** tab or click **Create**.
2. Click **Add Conditional Formatting** to apply dynamic formatting based on the item’s state. By default, automation rules are applied as standard, but any custom formatting added at the widget level is isolated to that specific widget and does not affect others.
3. Add the desired **Sort Order** by specifying up to five fields along with their corresponding sort direction (**ASC**/**DESC**).
4. Specify the **Row Height**. Options include short, medium and tall.
5. Choose whether to **enable or disable Preview Media Files**.
6. Click **Create** to confirm your settings and add the widget.

![](https://cdn.document360.io/3a63e0a8-1221-4570-aaa1-d43f9b95a612/Images/Documentation/workspace-spreadsheet-widget-appearance.png)