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

  1. Click the Microsoft Office ButtonButton image , and then click Open.
  2. Click the file you want to open, and then click Open.

 Note   When you open an OpenDocument Spreadsheet file in Excel 2007, it might not have the same formatting as it did in the original application it was created in. This is because of the differences between applications that use the OpenDocument Format.

Top of Page Top of Page

Save an Excel file in OpenDocument Spreadsheet format

 Important   If you want to keep an Excel version of your file, you must first save the file as an Excel file, for example in the .xlsx file format, and then save it again in the OpenDocument Spreadsheet (.ods) format.

  1. Click the Microsoft Office ButtonButton image , and click Save As.
  2. Click OpenDocument Spreadsheet.

Top of Page Top of Page

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.

 Tip   Before sending a file to someone else, you might want to close the file and open it again to see what it looks like in the OpenDocument Spreadsheet (.ods) format. To compare the Excel 2007 format of the file with the OpenDocument Spreadsheet format of the file, first save the file in the Excel 2007 format, then open both the Excel 2007 version and the OpenDocument Spreadsheet version and visually inspect the files for differences.

Top of Page Top of Page

 
 
Applies to:
Excel 2007