---
warning: DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github.com/duckdb/community-extensions repository, check README there
title: nsv
excerpt: |
  DuckDB Community Extensions
  Read and write NSV (Newline-Separated Values) files

extension:
  name: nsv
  description: Read and write NSV (Newline-Separated Values) files
  version: 0.1.0
  language: Rust & C++
  build: cmake
  license: MIT
  requires_toolchains: rust
  maintainers:
    - namingbe

repo:
  github: nsv-format/nsv-duckdb
  ref: 52da7b3a2248a4c11dbd51251c89555e9587c282

docs:
  hello_world: |
    -- Read an NSV file (type narrowing mimics CSV behaviour)
    SELECT * FROM read_nsv('data.nsv');

    -- Write query results as an NSV
    COPY my_table TO 'output.nsv' (FORMAT nsv);

    -- Read without type narrowing, i.e. everything is a string
    SELECT * FROM read_nsv('data.nsv', all_varchar=true);

    -- Read a headerless file
    SELECT * FROM read_nsv('data.nsv', header=false);

    -- Write without a header row
    COPY my_table TO 'output.nsv' (FORMAT nsv, HEADER false);

  extended_description: |
    [NSV](https://nsv-format.org) is a plain text data format for sequences of sequences.
    A subset of these where the nested sequences all have the same length is of interest, for that is effectively a table.

    The NSV format itself is type-agnostic. This extension attempts to closely follow what the CSV extension does for the type narrowing logic, the column name convention, and the interface surface. A subset of that, of course.

    In terms of expressive power, NSV can be used for anything CSV is used for, but being a format much more amenable to parsing, the performance of that is far higher than for CSV, and so is its readability.
    This extension is intended to enable performant queries against the files using the format.

extension_star_count: 1
extension_star_count_pretty: 1
extension_download_count: 938
extension_download_count_pretty: 938
image: '/images/community_extensions/social_preview/preview_community_extension_nsv.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 |
|---------------|---------------|-------------|---------|----------|
| read_nsv      | 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>

This extension does not add any settings.