TableToSql Function

TABLETOSQL() Description

The TABLETOSQL() function converts values from a table into an SQL INSERT INTO command.

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

Key Characteristics of TABLETOSQL Function

Syntax:

=TABLETOSQL(Range)

Parameters:

• Range: Range with values in a table format with headers.

Usage Example

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

=TABLETOSQL(Range)

We will get the following result:

The following values are used in this example:

• Range: A2:D16 - Range containing a table with headers and values.

Download Extension

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

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