TableToDict Function

TABLETODICT() Description

The TABLETODICT() function is designed for quick conversion of tabular data from Excel (LibreOffice Calc) programs. It automatically converts selected values into a structured "dictionary" data type.

The result obtained is fully compatible with the formats used in the Python and PHP programming languages.

Key Features of the TABLETODICT Function

Syntax:

=TABLETODICT(Range; [Format])

Parameters:

• Range: Table with headers and data.
• [Format]: Optional. Dictionary format (0-Python or 1-PHP). By default, the value 0 is used.

Usage Example

The TABLETODICT() function is simple to use. You just need to select a table and specify the desired dictionary format (0-Python or 1-PHP) and Excel (Calc) will automatically return an array of values:

=TABLETODICT(Range; Format)

Example 1

In this example, the following values are used:

• Range: A2:D6 - The range that contains the table with values.
• Format: E1 - Python dictionary format (0).

Example 2

In this example, the following values are used:

• Range: A2:D6 - The range that contains the table with values.
• Format: E1 - PHP dictionary format (1).

Download Extension

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

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