What is MIME type "application/x-vnd.oasis.opendocument.spreadsheet-template"?

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

application/x-vnd.oasis.opendocument.spreadsheet-template describes a file format used as a template for creating spreadsheet documents. These files serve as blueprints that set up layouts, styles, and formulas before data is added.
They are built on the OpenDocument standard and use XML-based packaging. This ensures compatibility across different software, like LibreOffice Calc and Apache OpenOffice Calc. The file extension for these templates is OTS.

Main use case: Providing a ready-made design for new spreadsheet documents.
Other uses:
- Ensuring consistent formatting for recurring reports.
- Preloading formulas and cell styles for data analysis.
- Streamlining document creation in office applications.
Key facts:
- Based on an open standard supported by many applications.
- Uses XML for structure and formatting.
- Improves productivity by standardizing spreadsheet setups.

For more details on the OpenDocument standard, visit OASIS.

Associated file extensions

.ots

Usage Examples

HTTP Header

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


    Content-Type: application/x-vnd.oasis.opendocument.spreadsheet-template

HTML

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


    <a href="file.dat" type="application/x-vnd.oasis.opendocument.spreadsheet-template">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', 'application/x-vnd.oasis.opendocument.spreadsheet-template');    
      res.end('Content here');    
    }).listen(3000);

Associated file extensions

.ots

FAQs

What kind of file uses the MIME type application/x-vnd.oasis.opendocument.spreadsheet-template?

This MIME type is assigned to OpenDocument Spreadsheet Templates, which typically use the .ots file extension. These files act as blueprints containing layout, styles, and formulas for creating new spreadsheet documents in software like LibreOffice Calc.

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

You can ensure Apache serves the correct content type by adding the following directive to your .htaccess file or httpd.conf: AddType application/x-vnd.oasis.opendocument.spreadsheet-template .ots.

What is the Nginx configuration for this MIME type?

For Nginx, you should add the type mapping within the types block of your nginx.conf or mime.types file: application/x-vnd.oasis.opendocument.spreadsheet-template ots;.

Why does the browser download the file instead of displaying it?

Most web browsers (Chrome, Firefox, Edge) do not have built-in rendering engines for OpenDocument formats. Consequently, they default to downloading the file so it can be opened in a compatible desktop application like Apache OpenOffice or LibreOffice.

What is the difference between this MIME type and the standard ODS type?

This type represents a template (.ots), intended to spawn new, untitled documents with pre-defined settings. In contrast, standard spreadsheet files use the extension .ods and are typically associated with application/vnd.oasis.opendocument.spreadsheet.

Is application/x-vnd.oasis.opendocument.spreadsheet-template the official standard?

The x- prefix indicates a non-standard or experimental type often used before official registration. The current IANA-registered standard is application/vnd.oasis.opendocument.spreadsheet-template (without the x-), but the version with x- is still widely supported for backward compatibility.

Are there security risks associated with this file type?

Yes, like many office document formats, OpenDocument templates can contain macros or scripts. Users should only open .ots files from trusted sources to prevent the execution of malicious code within their spreadsheet software.

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.