Lido Data as Source

You can turn any existing data range in your spreadsheet into a named Lido table. This lets you use data you've already entered — or that other formulas have produced — as a structured table that other formulas can reference by name.

Creating a Table from Existing Data

1. Select the cell range containing your data (the first row should be column headers)
2. Right-click → "Create Table"
3. Give the table a name

Lido will wrap your range in a RANGETABLE formula and register it as a named table. Once created, you can:

• Reference it in formulas using TableName[@ColumnName] syntax
• Add computed, linked, or plain columns to extend it (see Column Types)

How It Works Under the Hood

The right-click action generates a formula like:

=RANGETABLE(A1:C10, "Clients")

• The first row of the range is treated as column headers
• Subsequent rows are the table data
• When any cell in the range changes, the table updates automatically

When to Use RANGETABLE vs. External Data Sources

	External Data Source	RANGETABLE
Data lives in	An external API, database, or service	Your spreadsheet cells
Created via	File → "Connect real-time data"	Right-click → "Create Table"
Live refresh	Yes (from external source)	Reflects cell changes automatically
Typical use	CRM data, database records, API results	Manually entered or formula-produced data

Tips

• The range must include a header row — the first row defines column names
• Empty rows within the range are skipped
• Changing the range (e.g., adding rows) requires updating the formula — consider using a dynamic range like A:C to capture new rows automatically