TableToJson function

TABLETOJSON() Description

The TABLETOJSON() function converts a table of values to text in "JSON" format.

Main Features Functions TABLETOJSON

Syntax:

=TABLETOJSON(Range)

Parameters:

• Range: Range with values.

Example Usage

The TABLETOJSON() function is easy to use. You just need to select a table or specify any range of cells with values and Excel will automatically return text in "JSON" format:

=TABLETOJSON(Range)

We will have the following result:

This example uses the following values:

• Range: A2:D16 - The range from which the table with values is contained.

Download extension

You can use the function TABLETOJSON() by installing the extension YLC Utilities .

After that, this function will be available in all files that are opened in Excel .