Skip to main content

Excel

Excel workbooks can be loaded through DuckDB's Excel extension and stored in MotherDuck for repeatable SQL analysis.

How it works with MotherDuck​

  1. Connect to MotherDuck from a DuckDB client.
  2. Install and load the DuckDB Excel extension in the client session.
  3. Use read_xlsx to read a workbook and create a MotherDuck table from the result.

Example​

INSTALL excel;
LOAD excel;

CREATE TABLE my_table AS
SELECT *
FROM read_xlsx('workbook.xlsx');

To read a specific worksheet, pass the sheet parameter:

CREATE OR REPLACE TABLE my_database.main.excel_data AS
SELECT *
FROM read_xlsx('workbook.xlsx', sheet = 'Sheet1');

Related content​