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:

• Range: Range with values.
• [RootElement]: Optional. The name of the general tag for the selected data set (table). By default, the value "table" is used.
• [RowElement]: Optional. The name of the tag for each data record (row). By default, the value "row" is used.

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 will automatically return the text in "XML" format:

=TABLETOXML(Range; "Countries")

We will get the following result:

In this example, the following values are used:

• Range: A2:D6 - The range that contains the table with values.
• RootElement: - The name of the general tag for the data set. ("Countries")

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.