TableToHtml Function

TABLETOHTML() Description

The TABLETOHTML() function is designed for quick conversion of Excel (LibreOffice Calc) tables into HTML format. It automatically generates ready-made code with appropriate tags, allowing you to instantly integrate tabular data onto a web page.

Thanks to this, users can easily publish structured information on the internet without manual layout.

Main Characteristics of the TABLETOHTML Function

Syntax:

=TABLETOHTML(Range; [Indent])

Parameters:

• Range: Range with values.
• [Indent]: Optional. Initial indent for each nesting level. By default, it is "4".

Usage Example

The TABLETOHTML() 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 "HTML" format:

=TABLETOHTML(Range)

We will have the following result:

The following values are used in this example:

• Range: A2:D6 - A range containing a table with values.

Download extension

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

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