Search Shortcut cmd + k | ctrl + k
rusty_sheet

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