Cookies for analytics and advertising
We use cookies for analytics and advertising, both sent to Google. Refusing changes nothing you can see.Read the privacy page
ODS
What is an ODS file?
The open spreadsheet standard. Formulas, several sheets, no vendor lock-in.
What ODS is
ODS is a container: a wrapper that holds streams encoded by something else. It is used for editing.
The extension is .ods, and the full name is OpenDocument Spreadsheet. Both matter less than what the file can hold, which is what the rest of this page is about.
Where ODS came from
OASIS published it in 2005. The specification is ISO/IEC 26300.
Age is worth knowing here for one practical reason: the older a format is, the more programs have had time to learn it.
The specification is public
Anyone can implement it without asking permission or paying a licence, which is why it turns up in so many programs and why files written twenty years ago still open.
It can hold several pages in one file
A ODS file is not limited to one page, which matters when converting to something that is: a target that holds one image produces one file per page, and the numbering it chooses is worth checking before you send it on.
What kind of document it is
ODS holds a spreadsheet: cells, formulas and the sheets around them.
That is what decides how it converts: a spreadsheet becomes a print area, and a print area is a decision somebody has to make about where the columns break.
What it does to protect itself
ODS carries optional encryption.
An encrypted file has to be unlocked before anything can convert it, here or anywhere else — a password is not something a converter can work around, and one that claimed to could not be trusted with the file either.
What opens ODS
LibreOffice Calc, Microsoft Excel and Google Sheets read it, and so do most programs of the same kind.
If a file will not open, the format is rarely the problem — it is more often that the program predates it. Converting to something older is the reliable way past that, and it is what the rest of this site is for.
Opening it in a browser
No browser reads it.
That is the single most common reason to convert it: not that the format is bad, but that the place you want to show the file cannot read it.
It is a working format
ODS is meant to be opened and changed. Keep the file in this format for as long as the work is going on, and export from it whenever a finished copy is needed.
The facts, in one place
| Extension | .ods |
|---|---|
| Media type | application/vnd.oasis.opendocument.spreadsheet |
| Published by | OASIS |
| First published | 2005 |
| Specification | ISO/IEC 26300 |