Use Excel to open or save a worksheet in the OpenDocument Spreadsheet (.ods) format
After you install the 2007 Microsoft Office system Service Pack 2 (SP2), you can open and save files in the OpenDocument Spreadsheet (.ods) file format used by some spreadsheet applications, such as OpenOffice.org Calc and Google Docs.
What do you want to do?
Open an OpenDocument Spreadsheet in Excel
Click the Microsoft Office Button , and then click Open.
Click the file you want to open, and then click Open.
Save an Excel file in OpenDocument Spreadsheet format
Click the Microsoft Office Button , and click Save As.
Click OpenDocument Spreadsheet.
Learn more about the OpenDocument Format
When you open or save worksheets in the OpenDocument Spreadsheet (.ods) format, some formatting might be lost. This is because of the different features and options, such as formatting and tables, that OpenDocument Spreadsheet applications and Excel 2007 support. For more information about the differences between the OpenDocument Spreadsheet format and the Excel 2007 format, see Differences between the OpenDocument Spreadsheet (.ods) format and the Excel (.xlsx) format.