Sample ODS file
An OpenDocument spreadsheet, the native format of LibreOffice Calc, with one sheet of 100 fictional sales orders. Free, no sign-up. Updated 19 November 2026.
What these files are
An OpenDocument spreadsheet, the native format of LibreOffice Calc, with one sheet of 100 fictional sales orders. Quantities, prices and sales are stored as numbers and order dates as dates, so formulas work on them straight away.
Every file was generated by our own code, so nothing in them is copied from anyone, and we release them under CC0: use them for anything. The facts in the table were read back from each file after it was written, not typed in by hand.
About the format
An .ods spreadsheet uses the same OpenDocument ZIP layout as .odt, with the mimetype application/vnd.oasis.opendocument.spreadsheet. Each cell records its value type (float, date, string and others) separately from the text it displays, which is how the numbers and dates in this file keep their types when another program opens it.
These files open in LibreOffice Calc, Microsoft Excel and Google Sheets. A web server should send them with the header Content-Type: application/vnd.oasis.opendocument.spreadsheet.
1 file to download
| File | Size | What it is |
|---|---|---|
| sample-sales-orders.ods | 5 KB | one sheet, header row plus 100 fictional sales orders, typed numbers and dates rows: 100; columns: 6 |
MIME type: application/vnd.oasis.opendocument.spreadsheet. Total 5 KB.
Good for testing
- Spreadsheet import code that should accept more than .xlsx
- Converting ODS to CSV or XLSX
- Checking that typed numbers and dates survive an import
Check a file
unzip -p sample-sales-orders.ods mimetype
libreoffice --headless --convert-to csv sample-sales-orders.odsCompare the SHA-256 checksum to make sure the download is complete and unchanged (sha256sum file on Linux, shasum -a 256 file on macOS, certutil -hashfile file SHA256 on Windows):
| File | SHA-256 |
|---|---|
| sample-sales-orders.ods | 3ae10ca69559e4c615eb980197af17f44402f24634de2f735577c570c5e341e2 |