Ask Your Question

Revision history [back]

SueKL, Mike Kaganski and gabix have addressed your question, but I would like to clarify if I might.

FIRST, let's answer your question:

  1. In LibreOffice Calc, click File > Save As.
  2. In the Save window, click on the All Formats list box and select the .xlsx format.
  3. Choose the file name and path and click the Save button.

That's all there is to it. Now the file should open in Excel with no problems.

SECOND, let's address what appears to be a misconception. The ods file format stands for "Open Document Spreadsheet." It is one component of the universally-recognized and non-proprietary Open Document Format standard set of file formats. Basically, that means that many different software applications recognize and use these file formats and can freely exchange files saved in these formats.

Microsoft Office file formats (including xlsx) are proprietary and are NOT universally recognized. Widely used, yes -- but not universally recognized by other software applications in order to freely exchange files.

THIRD, let's discuss problems you may encounter when exchanging files with your associates and how to avoid them.

Your question doesn't indicate the operating system you are using but your question seems to imply a couple of possibilities:

  1. Your Calc file had no file extension assigned and you are using the Linux operating system on your computer. Linux does not require (or automatically add) a file extension appendage, while Windows does.
  2. Your associates tried to open your ods file directly from Windows Explorer without proper file association (the file extension tells Windows the application to use to open the file, based on the file associations set on the Windows computer).

Assuming proper file associations on the Windows computer, an ods file extension would tell Windows to open the file using Excel. However, Microsoft Office will probably tell you the file is corrupted and offer to "fix" it for you. This is because Microsoft only pays lip service to the Open Document Format standard. As I understand it, Microsoft uses a form of ODF that is not quite compatible with that used by most of the rest of the world.

If you stop at the warning, you may indeed believe you are unable to open the ods file using Excel. Accept Microsoft's offer to "fix" the file and it may open just fine after a moment.

On the other hand, simply save the ods file to xlsx format in LibreOffice Calc and Microsoft will likely open it in Excel without an objection. This is because LO has converted the file to Microsoft's particular specifications. (LO will open an xlsx file with no problem, but may urge you to save any changes to the ods file format in order to prevent losing special features that may be unique to Calc.)

THE BOTTOM LINE, then, is that you should open xlsx files from your associates in Calc and save to ods while working with on them, then save back to xlsx and quickly check to see if everything looks okay before transmitting the files to your associates. (Make sure the xlsx file being transmitted includes the "xlsx" file extension in the file name.)

I hope this helps.

Please clck the check mark beside the response you believe best answers your question.