TAGS

Converts a table with headers and rows into a JSON object array. There should be a "label" column and each row is rendered as a hoverable tag with that label.

Syntax

TAGS(table, [spillover])

Arguments

Argument	Description	Required
table	The table array where the first row contains headers and subsequent rows contain data	Required
spillover	Optional. TRUE/FALSE, 1/0, or text starting with "spill". Default FALSE returns one JSON string; TRUE spills one tag per row.	Optional

Examples

Convert table to JSON objects

Product catalog to JSON

Employee data transformation

Spillover array output

Related Functions

Other Special Functions & Keywords functions:

• CELL - Current cell value in criteria formulas
• COL - Column value using COL[A] or COL[1] syntax
• CSV - Serializes a table to a high-precision CSV string (CRLF between rows). Trailing empty rows and columns are cropped; internal blanks are kept. Wrap the cell or increase row height to see every line.
• FROMCSV - Parses a high-precision CSV string into a spilled table. Inverse of CSV.
• FROMTAG - Extracts a field value from a single JSON tag object produced by TAG or TAGS spillover.
• ONCE - Returns the value of the inner formula and only executes once, turning the cell into a value
• ONCHANGE - Returns initial_value until the range changes, then returns value_after_change and converts the cell to a static value
• RECORDID - Salesforce record ID for this workbook
• TAG - Converts a 2-column key|value table (default) or 2-row key|value table into a single JSON tag object.
• USERID - Current logged-in user's ID

---

← Back to Formula Reference