> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://katalyz.crisp.help/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Table widget

The **Table** widget is a mini-spreadsheet inside your room. Excel-style cells, GSheets-style formulas. Use it for pricing tables, ROI breakdowns, scoring grids, configurator output — anything where buyers want numbers in rows and columns.

> **Behaves like Google Sheets** — formulas, cell references, autocomplete, error messages all follow GSheets conventions. If you know GSheets, you know Table.

![](https://storage.crisp.chat/users/helpdesk/website/-/5/5/4/8/554891f22af0b400/screenshot-2026-06-17-at-21184_1x3e2am.png =639xauto)

## How to add

1. On the **floating build bar** at the bottom of the editor, open the **⌄ All widgets** popover and locate **Table**.
2. Drag it onto the target section.
3. The widget drops in with a default grid (**A–G columns × 10 rows**). Click any cell to start typing.

![](https://storage.crisp.chat/users/helpdesk/website/-/5/5/4/8/554891f22af0b400/screenshot-2026-06-17-at-21190_twkhyz.png =926xauto)

## The selection pill — Table controls

Click the table to select it. Left to right:

1. **Edit resource** (sliders icon) — opens the **Table settings** popover (title row, summary row, border — see below).
2. **Design** (paintbrush icon) — opens the contextual Design panel (Layout & corners / Spacing / Background / Border / Effects on the widget container itself).
3. **⋮ More** — Edit resource (same as the sliders icon) · **Duplicate** · **Delete**.

(No Size / Dark mode / Replace / Expand — none apply.)

## Editing cells

Click any cell and type. Behaviour mirrors a standard spreadsheet:

- **Plain text or numbers** — type and press **Enter** (moves down) or **Tab** (moves right).
- **Formulas** — start with `=` to enter formula mode. An autocomplete dropdown lists available functions with usage examples and short descriptions. Pick one to insert it.
- **Cell references** — use `A1`, `B2`, etc. Ranges use the colon notation: `A1:B5`.
- **Errors** — a cell whose formula can't be resolved shows the standard error code (e.g. `#VALUE!`, `#REF!`).

### Supported formulas

The full list of built-in formulas — type `=` in any cell to see them in the autocomplete:

| Function | What it does | Example |
|---|---|---|
| `SUM` | Sum of values | `=SUM(A1:B5)` |
| `AVERAGE` | Average of values | `=AVERAGE(A1:B5)` |
| `COUNT` | Count of numeric values | `=COUNT(A1:B5)` |
| `COUNTA` | Count of non-empty cells | `=COUNTA(A1:B5)` |
| `MIN` | Minimum value | `=MIN(A1:B5)` |
| `MAX` | Maximum value | `=MAX(A1:B5)` |
| `MEDIAN` | Median value | `=MEDIAN(A1:B5)` |
| `STDEV` | Standard deviation | `=STDEV(A1:B5)` |

| Fonction | Ce qu'elle fait | Exemple |
| ---- |
| `SUM` | Somme des valeurs | `=SUM(A1:B5)` |
| `AVERAGE` | Moyenne des valeurs | `=AVERAGE(A1:B5)` |
| `COUNT` | Nombre de valeurs numériques | `=COUNT(A1:B5)` |
| `COUNTA` | Nombre de cellules non vides | `=COUNTA(A1:B5)` |
| `MIN` | Valeur minimale | `=MIN(A1:B5)` |
| `MAX` | Valeur maximale | `=MAX(A1:B5)` |
| `MEDIAN` | Valeur médiane | `=MEDIAN(A1:B5)` |
| `STDEV` | Écart-type | `=STDEV(A1:B5)` |
![](https://storage.crisp.chat/users/helpdesk/website/-/5/5/4/8/554891f22af0b400/screenshot-2026-06-17-at-21192_10hak5s.png =990xauto)

## Adding & managing rows and columns

- **Add a row at the bottom** — the **+** button under row 10.
- **Add a column to the right** — the **+** at the far right of the column header.
- **Insert / duplicate / delete a row** — **right-click the row number** to open the row context menu:
  - Insert row above
  - Insert row below
  - Duplicate row
  - Delete row
- **Insert / duplicate / delete a column** — **right-click the column letter** for the same operations on columns.

![](https://storage.crisp.chat/users/helpdesk/website/-/5/5/4/8/554891f22af0b400/screenshot-2026-06-17-at-21194_1fze371.png =803xauto)
![](https://storage.crisp.chat/users/helpdesk/website/-/5/5/4/8/554891f22af0b400/screenshot-2026-06-17-at-21195_1u9zl9j.png =801xauto)

## Table settings — Edit resource popover

Open via the sliders icon on the pill. Three groups of settings shape the whole table:

- **Title row** — toggle (**on by default**). When on, the first row is treated as a header row with its own background color.
- **Summary row** — toggle (**off by default**). When on, an extra summary row is appended at the bottom, with its own background color. Useful for totals, averages, or any roll-up of the cells above.
- **Border** — color (hex picker) and width (px). Applied to every cell boundary.

* **Ligne de titre** — interrupteur (**activé par défaut**). Lorsqu'il est activé, la première ligne est traitée comme une ligne d'en-tête avec sa propre couleur de fond.
* **Ligne de synthèse** — interrupteur (**désactivé par défaut**). Lorsqu'elle est activée, une ligne de synthèse supplémentaire est ajoutée en bas, avec sa propre couleur de fond. Utile pour les totaux, les moyennes ou tout récapitulatif des cellules au-dessus.
* **Bordure** — couleur (sélecteur hex) et épaisseur (px). Appliquée à chaque bordure de cellule.
![](https://storage.crisp.chat/users/helpdesk/website/-/5/5/4/8/554891f22af0b400/screenshot-2026-06-17-at-21191_wxbh6g.png =861xauto)

## Best practices

- **Bold your header row** — turn on Title row so buyers know at a glance where the labels are.
- **Roll-up in the summary row** — `=SUM(B2:B10)`, `=AVERAGE(C2:C10)`. Keeps your totals dynamic.
- **Keep tables compact** — Tables are for *quick scan + a few numbers*. If you need 200 rows, attach an XLSX in a Document widget instead.

## Related articles
- [Introduction to widgets](https://katalyz.crisp.help/en/article/introduction-to-widgets-skwh2f/)
- [Field widget](https://katalyz.crisp.help/en/article/field-widget-10qhhvv/)
- [Document widget](https://katalyz.crisp.help/en/article/document-widget-1kzu54t/)