What is MIME type "text/tab-separated-values"?

A MIME type is a string that tells browsers and other tools how to handle a particular kind of file.

text/tab-separated-values is a MIME type for plain text files that hold tabular data. It separates each data field with a tab character. This layout makes it easy to view and edit data using simple text editors.

It is mainly used for organizing spreadsheet-like data. Programs use it to import and export table data. Its structure supports straightforward data exchange and analysis across various applications.

Main use case: Storing and exchanging organized data in a plain text format.
Key facts:
- The tab character defines separate data fields.
- It is human-readable and widely supported by data analysis tools.

Files using this MIME type often use extensions such as TSV or TAB. In some cases, specialized implementations use the format with a CED extension, typically for EEGLAB channel data.

For official details, visit the IANA MIME Type Registry.

Associated file extensions

.tsv, .tab, .ced

Usage Examples

HTTP Header

When serving content with this MIME type, set the Content-Type header:


    Content-Type: text/tab-separated-values

HTML

In HTML, you can specify the MIME type in various elements:


    <a href="file.dat" type="text/tab-separated-values">Download file</a>

Server-side (Node.js)

Setting the Content-Type header in Node.js:


    const http = require('http');    
    
    http.createServer((req, res) => {    
      res.setHeader('Content-Type', 'text/tab-separated-values');    
      res.end('Content here');    
    }).listen(3000);

Associated file extensions

.tsv, .tab, .ced

FAQs

How does text/tab-separated-values differ from text/csv?

The primary difference is the delimiter: TSV files use a tab character (\t) to separate fields, while CSV files use commas. TSV is often preferred when the data contains text with commas, as it avoids the complex quoting and escaping rules required by text/csv.

Which file extensions are associated with this MIME type?

The standard extension is .tsv. However, it is also used for .tab files and specialized formats like .ced (often used for EEGLAB channel data). While these files are plain text, using the specific extension helps applications identify the structure immediately.

How do I configure Apache to serve .tsv files correctly?

To ensure Apache serves these files with the correct MIME type, add the following line to your .htaccess file or main configuration: AddType text/tab-separated-values .tsv. This prevents browsers from misinterpreting the data as generic text.

Why does my browser download TSV files instead of displaying them?

Browsers often treat data files as downloadable content to facilitate opening them in external spreadsheet software like Excel. To force the browser to render the text inline, the server must send the header Content-Disposition: inline.

Can I use text/plain instead of text/tab-separated-values?

Technically, yes, browsers will display the content since it is plain text. However, using the specific text/tab-separated-values MIME type is better practice because it explicitly tells the client software that the content is structured tabular data, allowing for smarter handling during imports.

How do I set this MIME type in Nginx?

You can add the type definition to your mime.types file or inside a server block. Add the line text/tab-separated-values tsv; to map the extension. Reload Nginx to apply the changes.

Are there security risks with TSV files?

While TSV files are plain text and cannot contain macros, they are susceptible to Formula Injection (CSV Injection). If a cell starts with symbols like =, +, -, or @, spreadsheet software might execute it as a formula when the user opens the file. Always validate data before export.

Does text/tab-separated-values support character encoding?

Yes, like other text types, it should specify a charset, usually UTF-8. The Content-Type header should ideally look like Content-Type: text/tab-separated-values; charset=utf-8 to ensure special characters render correctly across different operating systems.

General FAQ

What is a MIME type?

A MIME (Multipurpose Internet Mail Extensions) type is a standard that indicates the nature and format of a document, file, or assortment of bytes. MIME types are defined and standardized in IETF's RFC 6838.

MIME types are important because they help browsers and servers understand how to process a file. When a browser receives a file from a server, it uses the MIME type to determine how to display or handle the content, whether it's an image to display, a PDF to open in a viewer, or a video to play.

MIME types consist of a type and a subtype, separated by a slash (e.g., text/html, image/jpeg, application/pdf). Some MIME types also include optional parameters.

How do I find the MIME type for a file?

You can check the file extension or use a file identification tool such as file --mime-type on the command line. Many programming languages also provide libraries to detect MIME types.

Why are multiple MIME types listed for one extension?

Different applications and historical conventions may use alternative MIME identifiers for the same kind of file. Showing them all helps ensure compatibility across systems.