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:

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.

Options¶

Options can be defined by using reader hints. The loader is using polars.read_excel, please consult its documentation about all available parameters and their descriptions.

Please note due to introspection and automatic type casting capabilities, the full set of parameters is only available with Python 3.14 and higher.

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'