XLSX

omniload reads Excel Workbook XLSX spreadsheet files.

Where it works

Excel XLSX files can be accessed on every source that goes through the shared file readers:

• Local files: file://

• s3://, gs://, Azure blob storage

• sftp://

A file is read as XLSX when its extension is .xlsx (optionally .xlsx.gz), or when an explicit #xlsx format hint is appended. Gzipped files are decompressed automatically.

How it works

The whole file is read into memory and decoded at once (XLSX is not a streaming format); a corrupt or truncated file raises rather than loading partial data. Map keys are expected to be strings. The loader is using polars.read_excel, please consult its documentation about all available parameters and their meaning.

Example: Load XLSX file into DuckDB

omniload ingest \
    --source-uri 'file://path/to/workbook.xlsx#sheet_name=events' \
    --dest-uri   'duckdb:///local.duckdb' \
    --dest-table 'public.events'