The TABLETOJSON() function is designed for quick conversion of tabular values into JSON text format. It automatically structures data in the form of convenient "key-value" pairs that are easily read by both humans and computers.
The obtained result is ideal for transferring information in web applications and interacting with various APIs.
=TABLETOJSON(Range)
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 have the following result:
In this example, the following values are used:
You can use the function TABLETOJSON() by installing the extension YLC Utilities.
After that, this function will be available in all files that will be opened in Excel (LibreOffice Calc).
