Use Excel to open or save a worksheet in the OpenDocument Spreadsheet ...
Open an OpenDocument Spreadsheet in Excel. Click File > Open > Computer > Browse. To only see files saved in the OpenDocument format, in the file type list (next to the File name box), click OpenDocument Spreadsheet (*.ods). Find the file you want to open, and then click Open.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013