An Excel/OpenDocument Spreadsheets file reader for DuckDB
Maintainer(s):
redraiment
Installing and Loading
INSTALL rusty_sheet FROM community;
LOAD rusty_sheet;
Example
-- Read entire spreadsheet with headers
FROM read_sheet('data.xlsx');
-- Read specific worksheet
FROM read_sheet('workbook.xlsx', sheet_name='Sheet2');
-- Override specific column types (others auto-detected)
FROM read_sheet('data.xlsx',
columns={'id': 'bigint'}
);
-- Read specific data range (Excel-style notation)
FROM read_sheet('data.xlsx', range='A2:E100');
-- Read without headers
FROM read_sheet('data.xlsx',
header=false,
columns={'column1': 'varchar', 'column2': 'bigint'}
);
-- Analyze column types
FROM analyze_sheet('data.xlsx', analyze_rows=20);
About rusty_sheet
The DuckDB rusty-sheet extension that enables reading Excel and OpenDocument spreadsheet files directly within SQL queries. This extension provides seamless integration for analyzing spreadsheet data using DuckDB's powerful SQL engine. For detailed setup and usage instructions, visit the docs at rusty-sheet.
Added Functions
function_name | function_type | description | comment | examples |
---|---|---|---|---|
analyze_sheet | table | NULL | NULL | |
read_sheet | table | NULL | NULL |