Sign up for free
Functions

RANGE2JSON

Create a JSON array of objects from a range.

Parameter List

Syntax
RANGE2JSON(header, data)
header

The header range of the data. These will be the keys in the JSON array. For example: A1:D1.

data

The range of data to be added to the JSON. These will be values of the JSON array. For example: A2:D6.

Examples

RANGE2JSON(A1:B1, A2:B3) returns [{"name": "clark kent", "hero": "superman"},{"name": "peter parker", "hero": "spiderman"}]