Will pivot tables survive?

No — the pivot output values are kept as static cells.

Are macros converted?

No. VBA cannot be translated to LibreOffice Basic automatically.

Does LibreOffice open the result exactly?

Yes; the file is a standard ODS.

Data & Spreadsheets

Excel to ODS

Some organisations and procurement portals require OpenDocument files. Convert an Excel workbook to ODS with sheets, formulas and formatting intact.

Runs in your browser — files never leave your device.

Drop Excel (XLSX), Excel 97–2003 (XLS) files here

or click to browse · paste from clipboard · up to 100 MB each

Select files

Why convert Excel (XLSX) to ODS

ODS is an ISO standard mandated by several governments and universities. Producing it directly from Excel via Save As works, but this converter lets you do it from any device, including phones and Chromebooks.

Formulas, number formats, merged cells and column widths are translated; Excel-only features (pivot tables, macros, slicers) are not representable in ODS and are dropped.

How it works

Drop Excel (XLSX), Excel 97–2003 (XLS) files onto the box above, click it to browse, or paste from the clipboard.
Check the file list; remove anything you added by mistake.
Press Convert. The work happens on your device, so speed depends on your computer or phone.
Download the ODS — individually or all at once.

About the formats

Excel (XLSX) · Microsoft Excel workbook · .xlsx

The current Excel format: multiple sheets, formulas, formatting, charts and pivot tables in one file.

XLSX stores both the formula and its last computed value, so a converted CSV contains the values.
Maximum 1,048,576 rows and 16,384 columns per sheet.
XLSM is the same format with macros enabled.

Excel 97–2003 (XLS) · Legacy Microsoft Excel workbook · .xls

The binary Excel format used until 2007, limited to 65,536 rows and increasingly refused by web apps.

XLS supports 65,536 rows and 256 columns per sheet — larger data is silently cut off.
Many banks and legacy systems still export XLS.
Excel opens XLS in Compatibility Mode and recommends saving as XLSX.

ODS · OpenDocument spreadsheet · .ods

The LibreOffice Calc spreadsheet format, an open ISO standard that Excel and Google Sheets can also open.

ODS supports formulas, multiple sheets and charts like XLSX.
Some Excel-specific functions and pivot features do not round-trip through ODS.
ODS files are ZIP archives of XML, like ODT.

Related conversions

ODS to ExcelOn-deviceLibreOffice Calc ODS to Excel XLSX.Excel to CSVPopularOn-deviceExcel sheets to CSV with chosen delimiter and encoding.ODS to PDFLibreOffice Calc spreadsheets to PDF.Excel to JSONOn-deviceExcel sheets to JSON arrays with typed values.XLS to XLSXOn-deviceLegacy XLS to modern XLSX.CSV to ExcelPopularOn-deviceCSV into a proper Excel workbook, delimiter auto-detected.

More in Data & Spreadsheets · All converters