ods
What is a .ods file?
application/vnd.oasis.opendocument.spreadsheet
ODS is the OpenDocument Spreadsheet format, an ISO-standardized spreadsheet stored as a ZIP archive of XML. It is the native spreadsheet format of LibreOffice and OpenOffice Calc, supporting multiple sheets, formulas, and formatting. It is the open-standard counterpart to XLSX.
How to use a .ods file
Use an example ODS to test OpenDocument spreadsheet parsing, formula and multi-sheet handling, and converters between ODS and XLSX or CSV.
Download example .ods files
- ODS: OpenDocument SpreadsheetAn OpenDocument Spreadsheet with the same tabular data as the plain XLSX and legacy XLS: a member of an XLSX↔ODS↔XLS conversion set for spreadsheet importers.
- Budget Template (ODS, with formulas)A budget template as OpenDocument Spreadsheet, budget-versus-actual rows with live SUM formulas for the totals. A usable planning template and a fixture for testing ODS formula parsing and recalculation.
- Alder Table Bistro: Recipe costing as an OpenDocument spreadsheetRecipe costing as an OpenDocument spreadsheet for Alder Table Bistro. Three tables. PlateCosts holds 12 recipe lines with the as-purchased quantity and line cost as live ODF formulas; Summary rolls each dish up with SUMIF and computes margin and food-cost percent. The same figures in value form are in plate-costs.csv.
- Ember Lane Pizza: Inventory variance as an OpenDocument spreadsheetInventory variance as an OpenDocument spreadsheet for Ember Lane Pizza. Two tables. Theoretical closing, the variance quantity, the variance at standard cost and the total are live ODF formulas over 6 ingredients. The same figures in value form are in inventory-count-sheet.csv.
- Harbour Kitchen Group: Tip pool as an OpenDocument spreadsheetTip pool as an OpenDocument spreadsheet for Harbour Kitchen Group. Two tables. Points and the allocation total are live ODF formulas; the allocated amounts are the whole-cent largest-remainder shares that sum to the declared pool of 218.61 CAD.