Why convert XLSM to ODS?
ODS is the native open-standard format for LibreOffice, OpenOffice, and Collabora, so teams sharing workbooks outside Microsoft Office often need this conversion. It also removes the macro-safety prompts that XLSM files trigger on many corporate systems. If you want to understand the target format better, see .ODS.
How to convert XLSM to ODS
LibreOffice Calc FREE
Open the XLSM in Calc, choose File > Save As, and select ODF Spreadsheet (.ods) from the format list.
Microsoft Excel PAID
Open the XLSM, go to File > Save As, pick ODS from the format dropdown, and confirm the macro-drop warning.
Command line - LibreOffice CLI
Run soffice --headless --convert-to ods file.xlsm to convert without opening the GUI.
Programs that convert XLSM
About these formats
An XLSM file is a Microsoft Excel spreadsheet that contains VBA macros - automation code that runs inside the file. Open it in Microsoft Excel (full macro support), LibreOffice Calc, or WPS…
Open .XLSM details →An ODS file is an OpenDocument Spreadsheet, the vendor-neutral format standardized by OASIS in 2005 and used natively by LibreOffice Calc and Apache OpenOffice. You can open it in…
Open .ODS details →Quality & what to watch
- VBA macros are always dropped - the
ODSfile contains only data, formulas, and formatting. - Charts and most formatting survive, but complex Excel-specific chart types may render differently in LibreOffice.
- Pivot tables are preserved but may need minor layout adjustments after conversion.
Frequently asked questions
Will my macros work in the converted ODS?
ODS. All macro code is dropped; only the spreadsheet data and formulas carry over.Can I convert back from ODS to XLSM?
ODS in Excel or LibreOffice and save as XLSM, but any macros lost during the original conversion will not be restored.Does LibreOffice Calc handle this conversion reliably?
Why does Excel warn me when saving as ODS?
ODS and will be dropped; the spreadsheet content is not affected.