Download a sample ODS spreadsheet of any size

Get an OpenDocument Spreadsheet with a small numeric table, at the exact size you choose.

10,485,760 bytes
10 MiB · JSON · 60 B
Exact size

1 MB = 1,000,000 B · 1 MiB = 1,048,576 B

Advanced: test an upload limit

Enter the byte limit above, then choose one byte below, the exact limit or one byte above. Each choice uses the same base: 10,485,760 B. Generate and download each file to test your endpoint.

How is the sample ODS file built?

Each file is an ODF package with the mimetype entry first, a manifest and content.xml holding one sheet named Sample. The sheet has a header row (id, name, score) and five data rows with real numeric cells. A binary part listed in the manifest supplies the remaining bytes, and every entry is stored uncompressed.

The smallest valid ODS file is 3,279 bytes; any byte count from there up to 2 GiB can be selected. MIME type: application/vnd.oasis.opendocument.spreadsheet.

Which ODS size do you need?

What is inside a 1 MiB ODS file?

The 1 MiB sample has mimetype (46 bytes), META-INF/manifest.xml (499 bytes), content.xml (2,296 bytes) and Pictures/pad.bin (1,045,297 bytes). The score column holds the values 17, 34, 51, 68 and 85, so you can check that an import reads numbers as numbers.

When is a sample ODS file useful?

  • Testing spreadsheet imports that accept .ods next to .xlsx and .csv.
  • Checking that numeric cells arrive as numbers after an import.
  • Testing size limits on spreadsheet attachments with a package that opens cleanly.

Questions about ODS test files

Will Excel open it?

Yes. Excel opens OpenDocument spreadsheets, as do LibreOffice Calc and Google Sheets.

Does it contain many rows?

No, six rows. Use the CSV or TSV generator when you need millions of rows.

Format reference and related tools

Format reference: OASIS OpenDocument 1.3.

Other formats in this family (Data): CSV · JSON · XLSX · XML · SQL · YAML · TSV · JSONL · LOG.

Related: CSV to JSON · JSON to YAML · Bytes to MB converter

Noticed an issue with this test file? Report an issue →