Skip to content


The CRANGETOJSON formula is used to transform a range of data into a JSON string.


CRANGETOJSON (AsObjects, HeaderOrDataRange, DataRangeChunk)


AsObjects : boolean (required)

Specify whether to return the selected range as an array of objects (true) rather than an array of arrays (false) in the JSON.

HeaderOrDataRange : string (required)

Specify the range containing the data to be converted including headers, or if DataRange is specified, the range containing just the headers.

DataRange : string

Specify the data range if HeaderOrDataRange only contains headers.

Chunk : number

Specify which chunk to output for cases where the total size of the JSON is larger than a cell’s maximum size (32,000 characters).

Default value: 1

Back to top