ODS
OpenDocument spreadsheet
ODS is the open-standard spreadsheet format used by LibreOffice Calc and OpenOffice.
Opens in LibreOffice Calc, OpenOffice, Google Sheets, recent Excel
ODS converterODS to YAML converter, without the upload.
Turn ODS spreadsheets into YAML. It is converted in your browser, so the file never leaves your device.
Drop ODS files here
or choose from your computer paste with Ctrl V
from Photos or Files
Ready · other file types work too0 bytes uploaded, ever
Convert to
- On your device · nothing is uploaded
- No account, no email
- Batch and ZIP download
- Free
- YAML: one item per row
How to convert ODS to YAML
Add your ODS spreadsheets
Drop ODS files onto the box above, or click it to choose them. ToAny reads the file's contents to detect the type, so a wrong extension does not matter.
YAML is already chosen
Press Convert. There is nothing else to set. The work happens in this tab.
Download
Save the YAML, or download everything as one ZIP if you converted several files.
Why ToAny
Private by construction
The ODS to YAML converter is part of this page and runs inside your browser. Your spreadsheets are never sent to ToAny or to anyone else.
No upload, no queue
Nothing has to travel to a server and back, so the conversion starts the moment you press Convert, even on a slow connection.
Free, without an account
No sign-up, no email address and no watermark. Add several files and download them together as a ZIP.
ODS to YAML: what to expect
ODS is not what most colleagues or import tools expect. YAML is easier for people to read and edit than JSON and allows comments. ODS is at home in spreadsheets in open-source office suites; YAML is the usual choice for configuration files written by people.
The first row is read as column names, and every row after it becomes one list item, keyed by those names. A header such as address.city is turned back into a nested address with a city. A workbook with a single sheet becomes a plain list; one with several sheets becomes an object keyed by sheet name. Formulas come across as the values they last calculated, and formatting such as colours and column widths is not carried over.
ODS vs YAML
YAML
YAML data
YAML expresses the same structures as JSON using indentation instead of brackets, and allows comments. It is the usual choice for configuration in tools like Docker Compose, Kubernetes and GitHub Actions.
Opens in Any text editor
YAML converter| ODSOpenDocument spreadsheet | YAMLYAML data | |
|---|---|---|
| Stands for | OpenDocument Spreadsheet | YAML Ain't Markup Language |
| Type | Spreadsheet workbook | Structured data (text) |
| Compression | ZIP container of XML | None |
| Introduced | 2005, by OASIS | 2001, by Clark Evans, Ingy döt Net and Oren Ben-Kiki |
| Opens in | LibreOffice Calc, OpenOffice, Google Sheets, recent Excel | Any text editor |
| Best for | Spreadsheets in open-source office suites | Configuration files written by people |
| File extension | .ods | .yaml, .yml |
Questions
Are my spreadsheets uploaded anywhere?
No. The ODS to YAML conversion runs inside your browser, on your own phone or computer. The file is not sent to ToAny or to anyone else.
Is anything lost when converting ODS to YAML?
The values are kept. Anything YAML has no way to express, such as formatting, formulas or nesting, is simplified or left out.
Can I convert several ODS files at once?
Yes. Add as many as you like, convert them together and download each result or all of them as one ZIP.
How do I convert ODS to YAML on Windows, Mac, iPhone or Android?
The steps are the same everywhere because ToAny runs in the web browser: open this page in a current version of Chrome, Edge, Safari or Firefox, add the ODS file, press Convert and save the YAML. There is nothing to install.
Is there a file size limit?
Yes. Spreadsheet files up to 150 MB are accepted; a larger file is refused with a message. Beyond that the limit is your device's memory, since nothing is uploaded; a computer copes with large files better than a phone.