Open ODS File

Information, tips and instructions

Edit ODS Spreadsheet in Excel

With Excel, you can open and save files in the ODS file format, which is a Spreadsheet in OpenDocument, used in some office applications for spreadsheets such as LibreOffice Calc and Google Docs.

Open an ODS Spreadsheet in Excel

  • Click File>Open>Computer>Browse.
  • To view only files saved in the OpenDocument format, in the list of file types, click ODS Spreadsheet.
  • Find the file that you want to open, and then click Open.

You should consider that when an ODS file is opened in Excel, it may not have the same format as it was in the original application.

Save an Excel spreadsheet in ODS format

  • Click File>Save As>Computer>Browse.
  • In the Save as type list, click ODS Spreadsheet.
  • Name the file and save it.

It is recommended to save an original Excel version of the file, to do this, you must first save the file as an Excel spreadsheet, either in XLSX or XLS, and then you must save it again in the ODS format.

As mentioned above, the format when exchanging XLSX and ODS can be lost, in whole or part of it.

This is due to the different features and options, as well as the XML encoding and structure of each format. Although they follow the same XML standard, the organization and structure of each compressed file varies from one format to another.

For example, the tables, formulas, graphs, etc. can vary from one to the other.

Tip: Before sending a file to another person, after consulting if it is required in ODS format, it is recommended that you close the file and reopen it to see its appearance in ODS.

To compare the Excel file format with the ODS file format, first save the file in the Excel format, then open the Excel version and the OpenDocument Spreadsheet version, and visually compare them for differences.