file in abyss
Back to formats

Data

TSV Tab-Separated Values

Tab-Separated Values is a data format commonly identified by .tsv, .tab. Use the listed signatures, MIME types, and structure notes to validate files beyond the extension.

Extensions .tsv, .tab
MIME text/tab-separated-values

Magic numbers

Analyze your file
offset 0 Tab-Separated Values leading signature
69 6E 64 65 78 09
index.

Structure

  1. Header row
  2. Tab-separated records
  3. Line endings

Caveats

  • Do not trust the extension alone. Check the MIME type, the first bytes such as 69 6E 64 65 78 09, and format-specific structure when possible.
  • Container formats and damaged files can share the same opening bytes, so deeper validation may be required for production upload, preview, or conversion flows.

Detection example

SIGNATURE = bytes.fromhex("696e64657809")
OFFSET = 0

def is_tsv(path: str) -> bool:
    with open(path, "rb") as f:
        f.seek(OFFSET)
        head = f.read(len(SIGNATURE))
    return head == SIGNATURE

Practical usage

Use cases

Tab-Separated Values is used for data exchange, imports, exports, parser testing, and validation workflows. Encoding, delimiters, versions, and container structure often change implementation behavior.

Common detection mistakes

  • The .tsv / .tab extension alone does not prove the file contents. Upload and conversion flows should combine extension, MIME type, leading bytes, and format-specific structure checks.
  • Tab-Separated Values can start with signatures such as 69 6E 64 65 78 09, but related containers and damaged files may require additional validation.

Security notes

Untrusted input is not safe just because the format was detected. Account for parser exceptions, large files, unexpected encodings, and external references.

Using samples

11 samples help test leading-byte detection, parser errors, upload limits, and download behavior.

Sample files

11 / 11 files
Sample Traits Size Source / license / SHA-256
Data

Blue Sky TSV

Blue Sky TSV is a Tab-Separated Values sample based on Wikimedia Commons. It can be used to test downloads, parsers, previews, and file type detection.

01-blue-sky.tsv
Type Sample
Small file
133 B
SHA-256 7cc4332dafc0b5b4c4195f617a859b053ad974c5fb6e11c51ca907d469cfd79f
Download
Data

Flower Garden TSV

Flower Garden TSV is a Tab-Separated Values sample based on Wikimedia Commons. It can be used to test downloads, parsers, previews, and file type detection.

02-flower-garden.tsv
Type Sample
Small file
277 B
SHA-256 0735f1405d078609c577301426738e9910f9a722a87df1d2caad414ec9425f73
Download
Data

Navy Blue Sky TSV

Navy Blue Sky TSV is a Tab-Separated Values sample based on Wikimedia Commons. It can be used to test downloads, parsers, previews, and file type detection.

03-navy-blue-sky.tsv
Type Sample
Small file
372 B
SHA-256 3ef298ff2d0763a28872e550a787cd802969f80490489252e1060716b60c0ac2
Download
Data

Nature of the Sky TSV

Nature of the Sky TSV is a Tab-Separated Values sample based on Wikimedia Commons. It can be used to test downloads, parsers, previews, and file type detection.

04-nature-sky.tsv
Type Sample
Small file
451 B
SHA-256 6b632fa9c3048f3ecaebeebd903466fc08c6258907f8ccb925fceff47edad489
Download
Data

Sky Landscape TSV

Sky Landscape TSV is a Tab-Separated Values sample based on Wikimedia Commons. It can be used to test downloads, parsers, previews, and file type detection.

05-sky-landscape.tsv
Type Sample
Small file
639 B
SHA-256 2bf7cd4e735c8856998b0676885278ecde0b314739fd4ac48cb6612d885154b5
Download
Data

Starry Sky TSV

Starry Sky TSV is a Tab-Separated Values sample based on Wikimedia Commons. It can be used to test downloads, parsers, previews, and file type detection.

06-starry-sky.tsv
Type Sample
Small file
657 B
SHA-256 3d4a3cfa3c78c4d7e6b533b9f104f32ff99abb28347cabe524b1f363c7438132
Download
Data

Blue Night Sky TSV

Blue Night Sky TSV is a Tab-Separated Values sample based on Wikimedia Commons. It can be used to test downloads, parsers, previews, and file type detection.

07-blue-night-sky.tsv
Type Sample
Small file
718 B
SHA-256 b9093471f57aff1e15183fd8ae1263fe29dc9525c4f2c1e3ee5205278d25db66
Download
Data

Hibiscus Flower TSV

Hibiscus Flower TSV is a Tab-Separated Values sample based on Wikimedia Commons. It can be used to test downloads, parsers, previews, and file type detection.

08-hibiscus-flower.tsv
Type Sample
1.0 KB
SHA-256 ed4ae8b7f1364176e4e4f00844ccecfffb4d70036b885b8ecb918ababf876c24
Download
Data

Arctic Sky TSV

Arctic Sky TSV is a Tab-Separated Values sample based on Wikimedia Commons. It can be used to test downloads, parsers, previews, and file type detection.

09-arctic-sky.tsv
Type Sample
Small file
984 B
SHA-256 03fd96063f64b6e2cb93d0097061f53315facc0d42ba2369e08220e88d4d5d9e
Download
Data

Sunset Rays TSV

Sunset Rays TSV is a Tab-Separated Values sample based on Wikimedia Commons. It can be used to test downloads, parsers, previews, and file type detection.

10-sunset-rays.tsv
Type Sample
1.1 KB
SHA-256 8e269dc9224d702ca825587b5458e59f48ce95bf2228b66e1aaba2faf7a3affa
Download
Data

NASA Blue Marble TSV

NASA Blue Marble TSV is a Tab-Separated Values sample based on NASA Image and Video Library. It can be used to test downloads, parsers, previews, and file type detection.

nasa-blue-marble-2012-east.tsv
Type Sample
1.7 KB
SHA-256 4cfbcc778162f9ff078783ff8c5cbf6cbdf2dff658e3af5e3e525c20eea44605
Download

Frequently asked questions

What is the magic number (file signature) of Tab-Separated Values?

Tab-Separated Values files begin with the byte signature 69 6E 64 65 78 09 ("index."). Detect the format by reading these leading bytes rather than trusting the file extension alone.

What is the MIME type of Tab-Separated Values?

The MIME type for Tab-Separated Values is text/tab-separated-values.

What file extension does Tab-Separated Values use?

Tab-Separated Values files use the .tsv, .tab extension. The extension is a convention only and does not guarantee the file contents, so combine it with signature and structure checks.

Related formats