File Formats

Load data into MotherDuck using various file formats.

Apache Iceberg

MotherDuck supports the Apache Iceberg format through the DuckDB Iceberg extension. The extension is loaded automatically when Iceberg functions or catalogs are used in your current MotherDuck session.

CSV

CSV is a simple text format for tabular data. DuckDB can read CSV files from local paths, HTTPS URLs, and supported cloud storage locations, then load the results into MotherDuck tables.

Delta Lake

MotherDuck supports querying data in the Delta Lake format. The Delta DuckDB extension is loaded automatically when any of the supported Delta Lake functions are called.

DuckLake

DuckLake is an integrated data lake and catalog format for large scale data analytics.

Excel

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

Google Sheets

Query Google Sheets from MotherDuck with CSV export URLs or the DuckDB Google Sheets community extension.

JSON

JSON is a common format for semi-structured data. DuckDB can read JSON files and load the results into MotherDuck for SQL analytics.

Parquet

Parquet is a columnar file format designed for analytics. DuckDB can query Parquet files directly and persist the result as a MotherDuck table.