Excel Tools

Convert ODS to XLSX: LibreOffice to Excel

Turn OpenDocument spreadsheets from LibreOffice Calc or OpenOffice into Excel workbooks. Formulas are translated to Excel syntax, and dates, number formats and merged cells are kept.

No file at hand?

How to convert ODS to XLSX

  1. Choose your .ods files from LibreOffice Calc, OpenOffice or any other program that saves OpenDocument. You can add many at once.
  2. Pick the output. One .xlsx per file in a ZIP, or all the sheets together in a single Excel workbook.
  3. Click Convert to XLSX. Values, dates, merged cells and number formats are copied, and OpenDocument formulas are rewritten in Excel syntax.
  4. 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

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

Frequently asked questions

Is the ODS to XLSX converter really free?

Yes. It is 100% free, with no usage limits, no account and no sign-up. There is no paid plan and no feature is locked.

Are my files uploaded to a server?

No. Your files are read and converted inside your browser, on your own device. The page only downloads its own code and the open-source SheetJS library from this site; the contents and names of your files are never sent anywhere. If you accept analytics cookies, Google Analytics receives anonymous usage data such as page views, never the contents or names of your files.

What is an ODS file?

ODS is the OpenDocument Spreadsheet format (ISO/IEC 26300), the native format of LibreOffice Calc and Apache OpenOffice Calc. Google Sheets can also download sheets as .ods.

Are formulas kept when converting ODS to XLSX?

Yes. ODS stores formulas in OpenFormula syntax, such as of:=[.B2]*[.C2]; the converter rewrites them as Excel formulas (=B2*C2) and keeps their last result. Functions that only exist in LibreOffice have no Excel equivalent.

Is the formatting kept?

Number formats, dates and merged cells are kept. Column widths, fonts, colours, borders, cell styles, charts and images are not. For a copy with formatting, use File › Save As › Excel 2007-365 in LibreOffice.

Can Excel open ODS files directly?

Excel 2010 and later can open .ods, but often with warnings or layout changes, and many upload forms only accept .xlsx. Converting gives you a standard Excel workbook.

Is there a file size limit?

There is no fixed limit and no usage quota. Each workbook is converted in your device’s memory, so the practical limit is your RAM: a recent computer handles files of tens of megabytes; on phones, keep files under about 20 MB.

Analytics: only if you accept cookies, the page loads Google Analytics (through Google Tag Manager) to count visits and see which tools are used. It never receives the contents or names of your files. You can change your choice at any time with “Cookie settings” at the bottom of the page.