Skip to main content

​
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.
  • 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:
Starts with =. See Formulas below.
An array/dynamic-array formula result that fills adjacent cells.

​
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:
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 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 guide.

​
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 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

.xlsx, .xls (compatibility warning), .csv, .json, and Tablix’s own .sheet format.

​
External Data Sources

Tablix can connect to and pull tables from Neon (Postgres), Supabase, and Notion. See 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.
Want to work on a spreadsheet with someone else? See Sharing & Collaboration for shareable links, Viewer/Editor access, and real-time presence.