TableToJson function

TABLETOJSON() Description

The TABLETOJSON() function converts a table of values into 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 LibreOffice Calc will automatically return the text in "JSON" format:

=TABLETOJSON(Range)

We will have the following result:

This example uses the following values:

• Range: A2:D16 - A range containing a table of values.

Download the extension

You can use the TABLETOJSON() function by installing the extension "YLC_Utilities.oxt" .

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