What happens when you convert XLSX to ODS
- Every sheet is carried over with its cell values and formulas. The converter rebuilds the workbook from its cells, so charts, images, pivot tables and cell styling such as colours and fonts are not kept.
- The file is read by SheetJS running in your browser; nothing is uploaded.
How to convert XLSX to ODS online
- Press "Choose XLSX files" and select one or more files, or drag them onto the box. You can add files of any size your device can hold in memory.
- There are no settings to choose: the converter keeps everything the target format can hold.
- Press "Convert to ODS". The spreadsheet library, about 900 KB, loads the first time and then workbooks convert in a moment.
- Save each ODS with its download button. Close the tab and every trace of the files is gone from memory.
Why convert XLSX to ODS?
XLSX files usually come from business spreadsheets, reports and anything shared with Excel users. People convert them to ODS because ODS is the native format of LibreOffice and the open standard many public bodies require.
In short, XLSX is good at what it was made for, and ODS is the more practical choice when the file has to open, upload or print somewhere else. XLSX opens in Excel, Google Sheets, Numbers and LibreOffice Calc, while ODS opens in LibreOffice Calc, Google Sheets and Excel.
How to convert XLSX to ODS on Windows, Mac, iPhone and Android
On Windows
Open this page in Chrome, Edge or Firefox, drag your XLSX files in from File Explorer, and press Convert. Each ODS is saved to your Downloads folder.
On a Mac
Safari, Chrome and Firefox all work. Drag the XLSX files from Finder onto the drop zone and the ODS files land in Downloads.
On iPhone and iPad
Open the page in Safari and tap Choose XLSX files. You can pick from Photos or from the Files app. The converted ODS appears in Files, in the Downloads folder.
On Android
Open the page in Chrome, tap Choose XLSX files and pick them from Files or your gallery. The ODS is saved to the Download folder, where any file manager can find it.
Best settings for XLSX to ODS
There are no settings to choose: the XLSX is read cell by cell and written as an OpenDocument spreadsheet.
Check the result in your spreadsheet program before deleting the original: formulas are carried over, but charts, images and styling are not, so a heavily formatted report will look plainer.
XLSX vs ODS: the differences
| XLSX | ODS | |
|---|---|---|
| Full name | Excel workbook | OpenDocument spreadsheet |
| Type | spreadsheet | spreadsheet |
| Created by | Microsoft | OASIS |
| First released | 2007 | 2005 |
| Compression | Lossless | Lossless |
| What it holds | several sheets with values, formulas, formatting and charts | several sheets with values, formulas and formatting |
| In a browser | opens in Excel, Google Sheets, Numbers and LibreOffice Calc | opens in LibreOffice Calc, Google Sheets and Excel |
| Common uses | business spreadsheets, reports and anything shared with Excel users | LibreOffice and OpenOffice users and public-sector documents |
| MIME type | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet | application/vnd.oasis.opendocument.spreadsheet |
About XLSX and ODS files
What is an XLSX file?
XLSX has been the default Excel format since Office 2007. Inside it is a ZIP archive of XML files, one per sheet, plus styles and shared text.
What is an ODS file?
ODS is the open standard spreadsheet format and the default in LibreOffice Calc. Several governments require it for published documents.
XLSX to ODS not working? Common problems
- The file will not open. Password-protected workbooks are encrypted, so they cannot be read without the password; remove the password in Excel first.
- Dates look like numbers. Spreadsheets store dates as numbers underneath; apply a date format to the column in your spreadsheet program.
- Special characters look wrong in Excel. The CSV is UTF-8; in older Excel, use Data, From Text/CSV and choose UTF-8 instead of double-clicking the file.
Convert XLSX to ODS from the command line
LibreOffice converts spreadsheets from the command line without opening a window:
soffice --headless --convert-to ods input.xlsxThe converter on this page does the same job in your browser, without installing anything.
XLSX to ODS converter FAQ
Will I lose quality converting XLSX to ODS?
Cell values and formulas are kept exactly. Charts, images and cell styling are not.
Why is the ODS a different size from the XLSX?
Workbook formats differ in how they compress, so the ODS may be a little larger or smaller than the XLSX.
Are my XLSX files uploaded anywhere?
No. The conversion runs inside this browser tab using the open-source SheetJS library, so your files stay on your device. You can disconnect from the internet after the page and converter engine have loaded and it still works.
Can I convert several XLSX files to ODS at once?
Yes. Select or drop as many files as you like; they are converted one after another and each gets its own download button.
How do I open an ODS file?
ODS opens in LibreOffice Calc, Google Sheets and Excel. ODS is common for LibreOffice and OpenOffice users and public-sector documents.
Is this XLSX to ODS converter free?
Yes. There is no sign-up, no watermark and no limit on how many files you convert. The site is paid for by advertising, and because conversions run on your device there is no server cost per file.
Can I convert XLSX to ODS on my phone?
Yes. The converter works in Safari on iPhone and iPad and in Chrome on Android. Converted files are saved to the Downloads folder.