TableToSql function

TABLETOSQL() Description

The TABLETOSQL() function converts values from a table to SQL team INSERT INTO .

This function also takes the sheet name as the name of the SQL table.

Main Features of TABLETOSQL Function

Syntax:

=TABLETOSQL(Range)

Parameters:

• Range: A range of values in the form of a table with headings.

Example Usage

The TABLETOSQL() function is easy to use. You just need to select a table with headers and Excel (Calc) will automatically return text in the SQL format of the "INSERT INTO" command:

=TABLETOSQL(Range)

We will have the following result:

This example uses the following values:

• Range: A2:D16 - The range that contains the table with headers and values.

Download extension

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

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