Skip to content

OTS magic bytes (.ots)

.ots file signature: 50 4B | application/vnd.oasis.opendocument.spreadsheet-template

Category: Office

OpenDocument Spreadsheet Template (OTS) is an open file format defined and maintained by the Organization for the Advancement of Structured Information Standards (OASIS). It is used to store spreadsheet templates for applications such as LibreOffice Calc, Apache OpenOffice Calc, and other compatible office suites. The format is not considered legacy, and security risks are generally low, though template files from untrusted sources should still be opened with standard caution.

Safe

Magic Bytes

Offset 0
50 4B

Sources: Apache Tika

Validation Code

How to validate .ots files in Python

Python
def is_ots(file_path: str) -> bool:
    """Check if file is a valid OTS by magic bytes."""
    signature = bytes([0x50, 0x4B])
    with open(file_path, "rb") as f:
        return f.read(2) == signature

How to validate .ots files in Node.js

Node.js
function isOTS(buffer: Buffer): boolean {
  const signature = Buffer.from([0x50, 0x4B]);
  return buffer.subarray(0, 2).equals(signature);
}

How to validate .ots files in Go

Go
func IsOTS(data []byte) bool {
    signature := []byte{0x50, 0x4B}
    if len(data) < 2 {
        return false
    }
    return bytes.Equal(data[:2], signature)
}

API Endpoint

GET /api/v1/ots
curl https://filesignature.org/api/v1/ots

See the full API documentation for all endpoints and parameters.

Related Formats

Frequently Asked Questions

What is a .ots file?

A .ots file is identified by the magic bytes 50 4B at byte offset 0. OpenDocument Spreadsheet Template (OTS) is an open file format defined and maintained by the Organization for the Advancement of Structured Information Standards (OASIS). It is used to store spreadsheet templates for applications such as LibreOffice Calc, Apache OpenOffice Calc, and other compatible office suites. The format is not considered legacy, and security risks are generally low, though template files from untrusted sources should still be opened with standard caution.

What are the magic bytes for .ots files?

The magic bytes for OTS (.ots) files are 50 4B at byte offset 0. These bytes identify the file format more reliably than the extension alone.

How do I validate a .ots file?

To validate a .ots file, read the first bytes of the file and compare them against the known magic bytes (50 4B) at offset 0. This is more reliable than checking the file extension alone, as extensions can be renamed.

What is the MIME type for .ots files?

The primary MIME type for .ots files is application/vnd.oasis.opendocument.spreadsheet-template.

Is it safe to open .ots files?

OTS (.ots) files are generally safe to open. They are classified as low risk because they primarily contain data rather than executable code. However, always ensure files come from a trusted source.