TableToJson Function

TABLETOJSON() Description

The TABLETOJSON() function converts a table with values into text in JSON format.

Main Characteristics of the TABLETOJSON Function

Syntax:

=TABLETOJSON(Range)

Parameters:

• Range: Range with values.

Example of Use

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

=TABLETOJSON(Range)

We will get the following result:

In this example, the following values are used:

• Range: A2:D16 - Range that contains a table with values.

Download extension

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

After that, this function will be available in all files opened in Excel (LibreOffice Calc).