How to open an Open Office file(.ods) in Excel?

One of the easiest way is to transfer the file to google drive (convertor: ON) and have it converted there. But if it is possible, it is best to do it in Open Office.

Another method is to enable Microsoft Office XP, 2003, or 2007 to open the Open Office files.  This can be done by downloading and installing the converter from http://odf-converter.sourceforge.net/ . Just like any other file converters, it is not perfect and the converted file may have some issues.