---
warning: DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github.com/duckdb/community-extensions repository, check README there
title: rusty_sheet
excerpt: |
  DuckDB Community Extensions
  An Excel/WPS/OpenDocument Spreadsheets file reader for DuckDB

extension:
  name: rusty_sheet
  description: An Excel/WPS/OpenDocument Spreadsheets file reader for DuckDB
  version: 0.4.2
  language: Rust
  build: cargo
  license: MIT
  excluded_platforms: "wasm_mvp;wasm_eh;wasm_threads;windows_amd64_rtools;windows_amd64_mingw;linux_amd64_musl"
  requires_toolchains: "rust;python3"
  maintainers:
    - redraiment

repo:
  github: redraiment/rusty-sheet
  ref: v0.4.2

docs:
  hello_world: |
    -- Read first sheet of spreadsheet with headers
    FROM read_sheet('data.xlsx');
    
    -- Read without headers
    FROM read_sheet('data.xlsx', header=false);
    
    -- Read specific worksheet
    FROM read_sheet('workbook.xlsx', sheet='Sheet2');
    
    -- Analyze more rows (deafult 10) to detect column types
    FROM analyze_sheet('data.xlsx', analyze_rows=20);
    
    -- 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 all worksheets in multiple file types with different extensions
    FROM read_sheets(['*.xlsx', '*.ods', '*.et']);
    
    -- Analyze with wildcard pattern
    FROM analyze_sheets(['*.xlsx'], sheets=['Sheet*']);
    
    -- Match specific worksheets only in specific file types
    FROM read_sheets(['*.xlsx'], sheets=['*.xlsx=Sheet*']);
    
    -- Track data sources with custom column names
    FROM read_sheets(['*.xlsx'], file_name_column='file', sheet_name_column='sheet');
    
    -- Union data by column name instead of position
    FROM read_sheets(['*.xlsx'], union_by_name=true);

    -- With custom HTTP headers: must be a persistent SECRET
    CREATE PERSISTENT SECRET http_auth (TYPE HTTP, BEARER_TOKEN 'token');
    FROM read_sheet('https://example.com/data.xlsx');

  extended_description: |
    The DuckDB rusty-sheet extension that enables reading Excel, WPS 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](https://github.com/redraiment/rusty-sheet).

extension_star_count: 80
extension_star_count_pretty: 80
extension_download_count: 32076
extension_download_count_pretty: 32.1k
image: '/images/community_extensions/social_preview/preview_community_extension_rusty_sheet.png'
layout: community_extension_doc
---
### Compatibility Matrix

This table covers all DuckDB releases that have not reached [end-of-life](https://duckdb.org/release_calendar), including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.

<div class="extension_compatibility_table"></div>

| Platform | 1.4.4 | 1.4.5 | 1.5.5 | 1.5.6 | 2.0.0 |
| :--- | :---: | :---: | :---: | :---: | :---: |
| Linux AMD64 | ✅ | ✅ | ✅ | ✅ | ✅ |
| Linux ARM64 | ✅ | ✅ | ✅ | ✅ | ✅ |
| macOS AMD64 | ✅ | ✅ | ✅ | ✅ | ✅ |
| macOS ARM64 | ✅ | ✅ | ✅ | ✅ | ✅ |
| Windows AMD64 | ✅ | ✅ | ✅ | ✅ | ✅ |
| Windows ARM64 | ❌ | ❌ | ❌ | ❌ | ❌ |
| WebAssembly | ❌ | ❌ | ❌ | ❌ | ❌ |

### Installing and Loading
```sql
INSTALL {{ page.extension.name }} FROM community;
LOAD {{ page.extension.name }};
```

{% if page.docs.hello_world %}
### Example
```sql
{{ page.docs.hello_world }}```
{% endif %}

{% if page.docs.extended_description %}
### About {{ page.extension.name }}
{{ page.docs.extended_description }}
{% endif %}
### Added Functions

<div class="extension_functions_table"></div>

| function_name  | function_type | description | comment | examples |
|----------------|---------------|-------------|---------|----------|
| analyze_sheet  | table         | NULL        | NULL    |          |
| analyze_sheets | table         | NULL        | NULL    |          |
| read_sheet     | table         | NULL        | NULL    |          |
| read_sheets    | table         | NULL        | NULL    |          |

### Overloaded Functions

<div class="extension_functions_table"></div>

This extension does not add any function overloads.

### Added Types

<div class="extension_types_table"></div>

This extension does not add any types.

### Added Settings

<div class="extension_settings_table"></div>

|      name      |                       description                       | input_type | scope  | aliases | typed_value |
|----------------|---------------------------------------------------------|------------|--------|---------|-------------|
| temp_directory | Set the directory to which temporary files are written. | VARCHAR    | GLOBAL | []      | post.db.tmp |