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

# Spreadsheet

> The grid, cell types, formatting, formulas, data validation, filters, drawing tools, and import/export.

## Sheets

* A workbook can contain multiple sheet tabs (rename, add, and switch between them from the tabs bar at the bottom).
* A sheet can be **protected** to prevent edits.
* A sheet can be **connected** to a source table — see [SQL → External Databases](/sql#external-databases).
* Each sheet independently tracks gridline visibility, row/column sizing, filters, charts, drawings, and images.

## Cells & Cell Types

Beyond plain text/number cells, a cell can be:

<AccordionGroup>
  <Accordion title="Formula" icon="function">
    Starts with `=`. See [Formulas](#formulas) below.
  </Accordion>

  <Accordion title="Checkbox" icon="square-check" />

  <Accordion title="Dropdown / data validation list" icon="list">
    Single or multi-select, with optional colored "chip" display, driven by a fixed list or a live source range (e.g. `A1:A10`).
  </Accordion>

  <Accordion title="Date or time picker" icon="calendar" />

  <Accordion title="Hyperlink" icon="link" />

  <Accordion title="Image" icon="image" />

  <Accordion title="Merged cell range" icon="table-cells-large" />

  <Accordion title="Spill range" icon="table">
    An array/dynamic-array formula result that fills adjacent cells.
  </Accordion>
</AccordionGroup>

## Formatting

Per-cell or per-selection formatting includes:

* Bold, italic, underline/strikethrough
* Font family, font size, text color, background color
* Horizontal align (left/center/right), vertical align (top/middle/bottom)
* Text wrap mode: overflow / wrap / clip, plus text rotation
* Borders (top/bottom/left/right, individually)
* Number formats — general, decimals, percentages, scientific, dates, times, and **currency** in 30+ currency codes
* Table styles (pre-built colored themes)
* **Format Painter** to copy formatting between ranges
* **Clear formatting** / **Clear content** as separate operations

## Formulas

Tablix supports a large function library, grouped into categories:

| Category           | Examples                                                                          |
| ------------------ | --------------------------------------------------------------------------------- |
| Math               | `SUM`, `PRODUCT`, `ROUND`, trig, logs                                             |
| Statistical        | `AVERAGE`, `MEDIAN`, `STDEV`, `CORREL`, `FORECAST.LINEAR`, `PERCENTILE`, `RANK`   |
| Logical            | `IF`, `IFS`, `AND`, `OR`, `SWITCH`, `IFERROR`, `IFNA`                             |
| Information        | `ISBLANK`, `ISNUMBER`, `ISERROR`, `TYPE`                                          |
| Text               | `LEFT`/`RIGHT`/`MID`, `CONCAT`, `TEXTJOIN`, `SPLIT`, `SUBSTITUTE`, `TEXT`, `TRIM` |
| Date & Time        | `DATE`, `TODAY`, `NOW`, `NETWORKDAYS`, `WORKDAY`, `DATEDIF`, `EDATE`, `EOMONTH`   |
| Financial          | `PMT`, `FV`, `PV`, `NPV`, `IRR`, `XIRR`, `SLN`/`DDB`/`VDB`                        |
| GST                | `GST`, `ADDGST`, `REMOVEGST`, `CGST`, `SGST`, `IGST`, `GSTBREAKUP`                |
| Engineering        | base conversions, bitwise ops, complex numbers, `CONVERT`                         |
| Lookup & Reference | `VLOOKUP`, `HLOOKUP`, `XLOOKUP`, `INDEX`, `MATCH`, `INDIRECT`, `OFFSET`           |
| Array              | `ARRAYFORMULA`, `FILTER`, `SORT`, `UNIQUE`, `SEQUENCE`, `MMULT`, `TOROW`/`TOCOL`  |
| Database           | `DSUM`, `DAVERAGE`, `DCOUNT`, `DGET`, `DMAX`/`DMIN`                               |
| Lambda             | `LAMBDA`, `MAP`, `REDUCE`, `BYROW`, `BYCOL`, `SCAN`, `MAKEARRAY`                  |

<Tip>
  Open the **Functions** sidebar to browse all functions with syntax and examples, or start typing `=` in a cell for live formula suggestions. You can also ask the [AI Assistant](/ai-assistant) to write a formula for you in plain English, or use **Magic Formula** to generate one right next to the cell. See the full [Formulas & Magic Formula](/formulas) guide.
</Tip>

## Data Validation

Turn a column or range into a controlled dropdown:

* Fixed list of options, or a **live source range**
* Single-select or multi-select
* Display as chip, plain text, or with a dropdown arrow
* Optional error message on invalid entry, optional "allow blank"

## Filters & Sorting

Apply filters per column by **values**, by a **condition** (equals, contains, greater/less than, empty, starts/ends with, etc.), or by **cell/text color**. Multiple filters can be combined across columns. Sort ascending/descending on any column.

## Find & Replace

Find and replace text across the current sheet or all sheets, with options for match case, match whole cell, and searching inside formulas.

## Duplicate Detection

Scan a range for duplicate values and see them grouped with their cell locations.

## Pivot Tables

Summarize a data range by grouping and aggregating it — no formulas needed. See the full [Pivot Tables](/pivot-tables) guide.

## Drawing, Shapes, Images & Text Boxes

* Freehand drawing tools: pen, marker, highlighter, eraser
* Shapes with custom styling
* Images (optionally linked to a URL or another sheet)
* Floating text boxes with their own font/color/alignment styling

All of these are positioned, resizable, rotatable objects that float above the grid — similar to charts.

## Rows & Columns

Insert/delete rows and columns, resize (manually or auto-fit), hide rows, and autofill (drag-fill) a selection.

## Import & Export

<Tabs>
  <Tab title="Import">
    `.xlsx`, `.xls` (compatibility warning), `.csv`, `.json`, and Tablix's own `.sheet` format.
  </Tab>

  <Tab title="Export">
    * **`.sheet`** — native format, preserves everything (formulas, formatting, charts, drawings, multiple sheets)
    * **CSV** — sanitized against formula-injection (`=`, `+`, `-`, `@`, `|` prefixes are safely escaped)
    * **XLSX** — full Excel export including styles, merged cells, images, drawings, and rendered chart images
    * **PDF** — pixel-accurate rendering including charts, images, text boxes, and drawings, auto-sized to content
    * **HTML** — self-contained, tabbed HTML file with all sheets, styling, and rendered content
  </Tab>
</Tabs>

## External Data Sources

Tablix can connect to and pull tables from **Neon** (Postgres), **Supabase**, and **Notion**. See [SQL → External Databases](/sql#external-databases).

## Google Drive Sync

When connected, spreadsheets are saved to and opened from your Google Drive automatically, and appear in your dashboard's Recent Spreadsheets list.

<Tip>
  Want to work on a spreadsheet with someone else? See [Sharing & Collaboration](/sharing) for shareable links, Viewer/Editor access, and real-time presence.
</Tip>