Guides
Importing Excel Sheets
Use the `st_read` function in the `FROM` clause of a query:  
```sql
SELECT * FROM st_read('test_excel.xlsx');
```  
The `layer` parameter allows specifying the name of the Excel worksheet:  
```sql
SELECT * FROM st_read('test_excel.xlsx', layer = 'Sheet1');
```  
#### Creating a New Table {#docs:guides:file_formats:excel_import::creating-a-new-table}  
To create a new table using the result from a query, use `CREATE TABLE ... AS` from a `SELECT` statement:  
```sql
CREATE TABLE new_tbl AS
SELECT * FROM st_read('test_excel.xlsx', layer = 'Sheet1');
```  
#### Loading to an Existing Table {#docs:guides:file_formats:excel_import::loading-to-an-existing-table}  
To load data into an existing table from a query, use `INSERT INTO` from a `SELECT` statement:  
```sql
INSERT INTO tbl
SELECT * FROM st_read('test_excel.xlsx', layer = 'Sheet1');
```  
#### Options {#docs:guides:file_formats:excel_import::options}  
Several configuration options are also available for the underlying GDAL library that is doing the XLSX parsing.
You can pass them via the `open_options` parameter of the `st_read` function as a list of `'KEY=VALUE'` strings.