TableToJson Function

TABLETOJSON() Description

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

Key Features of the TABLETOJSON Function

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 cell range 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 the table with values.

Download extension

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

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