Skip to main content
Service phase: Beta

This service is still in development. Give us your feedback.

Format

OpenDocument Spreadsheet

Download XML Download JSON

Summary

Name
OpenDocument Spreadsheet
Version
1.1
Identifiers
  • MIME: application/vnd.oasis.opendocument.spreadsheet
  • PUID: fmt/294
Format type
Spreadsheet
Disclosure
Full
Description
OpenDocument (ODF) format is a generic format for office documents, such as text, spreadsheets, presentations, drawings, and databases. It was developed by OASIS, based on the original OpenOffice document format. The format is an open standard, and is supported by a variety of office software packages. ODF is an XML format, which may comprise a single XML document, or a collection of subdocuments within a package. The package format is the commonly used form, and comprises a standard ZIP package containing the XML content and any associated binary data, together with a manifest which lists the package content. An ODF spreadsheet document contains spreadsheet data. The content is contained in a 'content' xml subdocument. Additional subdocuments contain style information, document metadata, and application-specific settings.
Format encoding
Binary
File extensions
ods, ots
Submitted by
Digital Preservation Department / The National Archives
Developed by
OASIS

Relationships

Has lower priority than
Has priority over

Internal signatures

ODF 1.1 spreadsheet (with version number)

Description
ZIP header + MIME-type declaration + version number. ODF versions without version number detail are assumed to be version 1.1
Provenance
Ongoing Digital Preservation research.

Byte sequences

Min Frag Length
Absolute from BOF
Offset
0
Max offset
None
Byte Sequence
504B0304{26}6D696D65747970656170706C69636174696F6E2F766E642E6F617369732E6F70656E646F63756D656E742E7370726561647368656574504B030414*6F66666963653A76657273696F6E3D22312E3122
Endianness
None

ODF 1.1 spreadsheet (without version number)

Description
ZIP header + MIME-type declaration. ODF versions without version number detail are assumed to be version 1.1
Provenance
Ongoing Digital Preservation research.

Byte sequences

Min Frag Length
Absolute from BOF
Offset
0
Max offset
None
Byte Sequence
504B0304{26}6D696D65747970656170706C69636174696F6E2F766E642E6F617369732E6F70656E646F63756D656E742E7370726561647368656574504B030414
Endianness
None

Container signatures

Type: ZIP

7010 - Open Document Spreadsheet 1.1

File path
META-INF/manifest.xml

Byte sequence reference

BOFoffset

Sub sequences
Min Frag Length
Position
1
Sub sequence min offset
0
Sub sequence max offset
1024
Sequence
'manifest:media-type="application/vnd.oasis.opendocument.spreadsheet'
File path
content.xml

Byte sequence reference

BOFoffset

Sub sequences
Min Frag Length
Position
1
Sub sequence min offset
0
Sub sequence max offset
128
Sequence
'office:document-content'

Changelog

  • V66

    Release date
    18 December 2012

    • Updated

      OpenDocument Spreadsheet 1.1: MIME-Type information added.

  • V60

    Release date
    11 June 2012

    • Updated

      OpenDocument Spreadsheet 1.1: Container signature statement added to record notes.

  • V42

    Release date
    5 November 2010

    • Added format

      OpenDocument Spreadsheet 1.1: Full entry added.

    • Added signature

      OpenDocument Spreadsheet 1.1: Signature developed through PRONOM Research