ODS file format
ODS is the spreadsheet format of LibreOffice Calc and the OpenDocument standard — an open, vendor-neutral alternative to XLSX with the same million-row capacity.
or drag & drop them here · images, video, audio and documents · up to 2 GB
What is ODS?
ODS is the spreadsheet member of the OpenDocument family standardised by OASIS in 2005. Like its siblings it is a ZIP archive of XML: `content.xml` holds the cells and formulas, `styles.xml` the formatting, and metadata sits in its own file. LibreOffice Calc uses it as its native format, as does Apache OpenOffice.
Capacity matches modern expectations. LibreOffice Calc handles 1,048,576 rows and 16,384 columns per sheet — the same as XLSX — so the format is not the constraint on real datasets. Formulas, charts, pivot tables (called DataPilot in older versions) and conditional formatting all live inside the file.
The friction is formula compatibility with Excel. The two suites implement some functions differently, name a few things differently, and diverge on newer array and lookup behaviour. Simple sheets round-trip perfectly; a workbook full of advanced functions deserves a check on its calculated values after conversion.
| Extension | .ods |
|---|---|
| Category | Document |
| MIME type | application/vnd.oasis.opendocument.spreadsheet |
| Released | 2005 |
| Developed by | OASIS |
| Compression | Lossless |
ODS: frequently asked questions
- What opens an ODS file?
- LibreOffice Calc and Apache OpenOffice open it natively. Google Sheets, Microsoft Excel and most mobile spreadsheet apps import it as well, so receiving an ODS rarely means having to install anything new.
- Does Excel open ODS files?
- Yes, Excel has read and written OpenDocument spreadsheets since 2007. Values, formatting and standard formulas come through fine; some advanced functions, macros and pivot configurations are where the two implementations start to disagree.
- ODS or XLSX — which should I use?
- XLSX if your files mainly go to Excel users, ODS if you work in LibreOffice or need an open standard for archiving. Capacity and everyday features are equivalent, so the decision is about which software will actually open the file.
- Do formulas survive an ODS to XLSX conversion?
- Standard ones do. SUM, IF, VLOOKUP and the rest of the common library map directly. Divergence shows up in newer array functions, some statistical functions and anything relying on suite-specific behaviour, so spot-check calculated totals afterwards.
- How many rows can ODS hold?
- LibreOffice Calc supports 1,048,576 rows and 16,384 columns per sheet, matching XLSX. As with any spreadsheet, performance degrades long before that limit — datasets in the hundreds of thousands of rows belong in a database rather than a sheet.
- Why use ODS at all?
- Because it is a genuine open standard that no single vendor controls, which matters for public-sector compliance, long-term archiving and any organisation that does not want its data tied to one company's product roadmap. It is also LibreOffice's native format, so nothing is lost on save.