Convert Excel to ODS
ODS is the spreadsheet half of OpenDocument: an ISO-standardized, inspectable ZIP of XML, native to LibreOffice and readable by Excel. Converting into it is usually about a requirement rather than a preference, and the data and formulas make the trip intact. The place to look afterwards is functions, because the two formula libraries overlap without matching exactly.
Use this without the search next time. Prathom Workbench puts Prathom's tools in your toolbar.
Add to Chrome — freeDrop your XLSX file here, or click to browse
Up to 50 MB. Deleted automatically after 30 minutes.
What it does
- All sheets, formulas and cell formatting are carried across
- Output is OpenDocument, native to LibreOffice and readable by Excel
- Function names are translated where the two libraries differ
How to use Excel to ODS
- 1
Upload the .xlsx
A workbook from Excel, LibreOffice or Sheets. Multiple sheets are preserved, unlike a conversion to CSV.
- 2
The workbook is re-expressed
Cells, formulas, number formats and styles are written into the OpenDocument structure.
- 3
Recalculate and scan for errors
Open the result and look for error values. They are the fastest way to find a function that did not translate.
How it works
The workbook is read and written out as OpenDocument. An ODS file is a ZIP holding the content, the styles and the metadata as separate XML parts, so every sheet, cell and formula is expressed as markup rather than as a binary structure.
Formulas are translated rather than evaluated. Where the two suites name the same operation differently, the name is mapped; where one has a function the other does not define, the formula text is preserved and may not calculate.
What transfers without thought
Sheets and their order, cell values, number and date formats, cell and font styling, column widths, merged cells, and cross-sheet references. For an ordinary workbook this is everything that matters, and the converted file behaves like the original.
What is worth checking
Functions first. The overlap between the two libraries is large but not total, and the gaps are concentrated in whatever either suite added most recently. Opening the result and scanning for error values finds these in seconds.
Conditional formatting and pivot tables are the other two areas where fidelity varies. Data and formulas are reliable; presentation logic sometimes needs a second look.
The reason this format exists
An ODS is readable without the software that wrote it. That sounds academic until a regulator asks what was in a submitted file, or an archive needs to open something in twenty years. It is the same argument that makes ODT the preferred format for documents in the same institutions.
Two formats built on the same idea
XLSX and ODS are more alike than their origins suggest. Both are ZIP archives of XML, both are documented public standards, and both describe a spreadsheet in essentially the same terms — sheets, cells, types, formulas, styles.
That similarity is why this conversion is comfortable. Values, types, multiple sheets and ordinary formatting cross over intact, and formulas usually do too, because the two standards share most of their function names.
Where it thins out is at the edges: pivot tables, macros, conditional formatting rules and anything from a recent Excel-only feature. If a workbook leans on those, open the result and check them specifically rather than assuming a clean file means a complete one.
Examples
A model for an institution that mandates open formats
The cross-sheet references survive because both formats express them the same way. An archive or procurement process that requires OpenDocument will accept this where it would refuse the original.
A workbook using a recent Excel function
Excel has added functions that OpenDocument formula does not define. The cell keeps the formula text but may not evaluate. Rewrite it with an equivalent that both support.
Frequently asked questions
Can Excel open an ODS file?
Yes. Excel has read and written OpenDocument spreadsheets for many years, so a recipient using Excel can open the result without installing anything. Fidelity is good for ordinary workbooks. Where it drifts is in recent Excel-only functions and in some conditional formatting rules, which is worth a check if the workbook is complex.
Do formulas still calculate?
Yes, and they remain formulas rather than becoming values, which is the main difference between this conversion and exporting to CSV. Both formats define a formula language and the common functions map directly. The exceptions are functions one suite has and the other does not, which arrive as text or as an error and need rewriting by hand.
Why would I use ODS rather than XLSX?
Almost always because something requires it. OpenDocument is an ISO standard and a number of governments, universities and archives mandate it so that files remain readable without depending on one vendor's software. For everyday exchange XLSX is more widely expected, and either opens in both suites.