Back to source

Extraction query

The DuckDB SQL that reads Extreme Music's XLSX files into the standard schema. {{file}} is replaced with the statement file's path at import time.

Must emit line_number, amount_raw and source_row; every other column matching a statement_lines column maps automatically, anything else is ignored.

Optional — needed only when the generic reader can't count the file's data rows (spreadsheets with preamble above the header, like Sony CS04). Must use the extraction query's exact reader clause and alias the count AS raw_count. Blank uses the built-in reader.

Last updated 10/12/2026

Cancel