How to convert ODS to XLSX
- Choose your .ods files from LibreOffice Calc, OpenOffice or any other program that saves OpenDocument. You can add many at once.
- Pick the output. One .xlsx per file in a ZIP, or all the sheets together in a single Excel workbook.
- Click Convert to XLSX. Values, dates, merged cells and number formats are copied, and OpenDocument formulas are rewritten in Excel syntax.
- Download the result and send it to whoever needs “an Excel file”.
Private by design: nothing is uploaded
The file is read and converted inside your browser, on your own device. No server receives it: the page only downloads its own code and the open-source SheetJS library from this site. You can verify it in the Network tab of the developer tools, or disconnect from the internet once the page has loaded.
Many people choose LibreOffice precisely to keep their documents under their own control. A converter that uploads them would defeat the point.
What is an .ods file?
ODS is the OpenDocument Spreadsheet format, an OASIS standard also published as ISO/IEC 26300. It is the native format of LibreOffice Calc and Apache OpenOffice Calc, and Google Sheets can download any sheet as .ods. Inside, an .ods is a ZIP file with XML parts, much like .xlsx, but the two formats describe cells, styles and formulas differently.
One visible difference is the formula language. In an .ods, a formula like =B2*C2 is stored in OpenFormula syntax as of:=[.B2]*[.C2]. The converter translates those references back to the form Excel uses.
Why convert ODS to XLSX
- Send files to Excel usersExcel 2010 and later (and Excel 2007 with Service Pack 2) can open .ods, but often with warnings, layout changes or features they do not support. An .xlsx opens as a normal workbook.
- Forms and systems that want .xlsxBanks, public administrations, ERPs and online services often accept only .xlsx or .xls uploads.
- Mixed teamsWork in LibreOffice and hand over Excel files without changing your own setup.
- Batch conversionTurn a folder of .ods reports into .xlsx in one step, or merge them into a single workbook.
What is kept and what is not
We tested the converter with .ods files written by Microsoft Excel and by the Python odfpy library, then opened the results in Excel.
Kept
- All sheets, with their names and order
- Values, dates and text with accents or other alphabets
- Formulas, translated to Excel syntax (
SUM, DATE, arithmetic and references)
- Number formats such as currency or
yyyy-mm-dd dates
- Merged cells
Not kept
- Column widths and row heights: the .xlsx uses Excel’s default sizes
- Fonts, colours, borders, cell styles and conditional formatting
- Charts, images and drawings
- Macros (LibreOffice Basic), data validation and anything not listed as kept
Functions that exist only in LibreOffice have no Excel equivalent, so a cell using one will show an error in Excel even though its last value is stored in the file.
How to do it with LibreOffice
If you have LibreOffice installed and need the formatting too, open the file and use File › Save As, then choose “Excel 2007-365 (.xlsx)”. For a whole folder, LibreOffice has a command line mode: soffice --headless --convert-to xlsx *.ods. Use this page when you are on a computer without LibreOffice, on a phone or tablet, or when you only care about the data.
Known limitations
- .ods files saved with a password are encrypted and cannot be opened here. In LibreOffice, use File › Save As and untick “Save with password”, then convert the new file.
- Flat OpenDocument files (.fods) are read too, but most testing was done with .ods.
- There is no file size limit or quota; very large files are limited by your device’s memory. On phones, keep files under about 20 MB.