ODS
ODS spreadsheet files for import testing
Test ODS imports, spreadsheet parsing, formula handling, and MIME detection with signature checks and local data workflows.
Verified . The local inspector recognizes the ZIP signature; package entries and table structure are checked against real ODS inputs, while tabular baselines come from the CSV generator.
Identify ODS files
- Magic signature
50 4B 03 04 (ZIP container)- Registered MIME
application/vnd.oasis.opendocument.spreadsheet
ODS is a ZIP package holding content.xml with table data plus styles and metadata. Importers must handle repeated rows and columns and shared formulas, so a valid ZIP header does not prove the sheet data parses.
Choosing ODS
ODS is the OpenDocument spreadsheet format, a ZIP package readable by LibreOffice, Excel, and Google Sheets, with formula and formatting fidelity varying by importer. The local generator does not produce ODS files, so validate ODS uploads with the file inspector and use the CSV generator for deterministic tabular baselines.
Confirm the ZIP signature and mimetype entry before treating a file as ODS.
Test formulas and cell types separately from plain values.
Enforce entry-count and size limits on the ZIP container.
Common test cases
- Spreadsheet import validation
- Formula and type handling
- MIME and signature checks
Invalid and boundary cases
- Valid ZIP with corrupt content.xml
- Huge repeated-row counts expanding memory
- External links with no network access
ODS fixture matrix
This format is generated locally in the browser and does not receive a permanent SEO URL.
Open the local generator