DataBrighten

    Sample ODS file

    1file · 5 KB in all · CC0

    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.

    textnumberdateyes/no
    Files1to download
    Total size5 KBall files
    Format.odsapplication/vnd.oasis.opendo
    LicenceCC0use for anything

    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

    FileSizeWhat it is
    sample-sales-orders.ods5 KBone 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.ods

    Compare 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):

    FileSHA-256
    sample-sales-orders.ods3ae10ca69559e4c615eb980197af17f44402f24634de2f735577c570c5e341e2