OpenDocumentSpreadsheet magic bytes (.ods)
.ods file signature: 50 4B | application/vnd.oasis.opendocument.spreadsheet
Category: Office
OpenDocument Spreadsheet (ODS) is an open spreadsheet file format defined by OASIS and standardized by ISO/IEC. It is used for worksheets, charts, formulas, and data analysis in office suites such as LibreOffice, Apache OpenOffice, and related applications. As a ZIP-based document container, it is generally safe, though spreadsheet files may contain macros or embedded content; older implementations may handle such features inconsistently.
Magic Bytes
Offset 0
50 4B
Sources: Apache Tika
All Known Signatures
5 signature variants are documented for .ods files across multiple sources.
| Hex Signature | Offset | Sources |
|---|---|---|
| 50 4B | 0 | Apache Tika |
| 50 4B 03 04 | 0 | Wikipedia |
| 50 4B 05 06 | 0 | Wikipedia |
| 50 4B 07 08 | 0 | Wikipedia |
| 6D 69 6D 65 74 79 70 65 61 70 70 6C 69 63 61 74 69 6F 6E 2F 76 6E 64 2E 6F 61 73 69 73 2E 6F 70 65 6E 64 6F 63 75 6D 65 6E 74 2E 73 70 72 65 61 64 73 68 65 65 74 | 0 | Neil Harvey FileSignatures |
Validation Code
How to validate .ods files in Python
def is_ods(file_path: str) -> bool:
"""Check if file is a valid ODS by magic bytes."""
signature = bytes([0x50, 0x4B])
with open(file_path, "rb") as f:
return f.read(2) == signature
How to validate .ods files in Node.js
function isODS(buffer: Buffer): boolean {
const signature = Buffer.from([0x50, 0x4B]);
return buffer.subarray(0, 2).equals(signature);
}
How to validate .ods files in Go
func IsODS(data []byte) bool {
signature := []byte{0x50, 0x4B}
if len(data) < 2 {
return false
}
return bytes.Equal(data[:2], signature)
}
API Endpoint
/api/v1/ods
curl https://filesignature.org/api/v1/ods
See the full API documentation for all endpoints and parameters.
Related Formats
Frequently Asked Questions
What is a .ods file?
A .ods file is an OpenDocumentSpreadsheet file. OpenDocument Spreadsheet (ODS) is an open spreadsheet file format defined by OASIS and standardized by ISO/IEC. It is used for worksheets, charts, formulas, and data analysis in office suites such as LibreOffice, Apache OpenOffice, and related applications. As a ZIP-based document container, it is generally safe, though spreadsheet files may contain macros or embedded content; older implementations may handle such features inconsistently.
What are the magic bytes for .ods files?
The magic bytes for OpenDocumentSpreadsheet (.ods) 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 .ods file?
To validate a .ods 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 .ods files?
The primary MIME type for .ods files is application/vnd.oasis.opendocument.spreadsheet.
Is it safe to open .ods files?
OpenDocumentSpreadsheet (.ods) 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.