TOP

TableToXml Function

TABLETOXML() Description

Function TABLETOXML() converts a table with values into text in XML format.


Key Characteristics of TABLETOXML Function

Syntax:

=TABLETOXML(Range; [RootElement]; [RowElement])

Parameters:

Usage Example

The Function TABLETOXML() is simple to use. You just need to select a table or specify any range of cells with values and Excel (Calc) will automatically return the text in "XML" format:

=TABLETOXML(Range; "Countries")

We will get the following result:

TABLETOXML formula usage

In this example, the following values are used:

Download extension

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

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