Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What is the best way to open ods files in Excel 2003?

Is there some plug-in available? Should I use some convertor to xls? Or would it be best if I just used LibreOffice (or OpenOffice)?

The file I want to open shouldn't contain anything fancy, so I probably don't need a solution that understands every detail of the format.

share|improve this question
Upgrade to Excel 2007? – grawity Jan 2 '12 at 16:28
Unfortunately, the computer I'm using right now has only Excel 2003 and I don't have Excel 2007 available. – svick Jan 2 '12 at 16:35
up vote 6 down vote accepted

Using OpenOffice is probably the easiest option IMO because there's no file format conversion necessary and OpenOffice is freely available.

There is a BSD licensed Microsoft Office 2003 plugin that is available, OpenXML/ODF Translator Add-in for Office. I don't have Microsoft Office so I'm unable to try it.

share|improve this answer
Nice answer, I didn't know that existed. I'm curious to know how well it works. – Aaron Jan 2 '12 at 16:59
The plugin worked fine for the file I wanted to open, thanks. – svick Jan 2 '12 at 17:04

Would it be best if I just used LibreOffice (or OpenOffice)?

Yes, it would probably work best if you just used Libre/OpenOffice. As much as OpenOffice does a good job of viewing Microsoft files, it doesn't do a perfect job. Sometimes there will be little differences (more noticeable with word documents), so it's always best to use Office for Microsoft files and OpenOffice for the open formats. But once you do that, you can save it as an xls and then it should open in Excel 2003 just fine.

share|improve this answer

To add to the previous comments:

The converter for opening .ods files in Microsoft Excel 2003 is very clumsy to use. You need the Compatibility Pack and then you need the Converter on top of that. I don't know how well it converts formulas, especially for the most-recent versions of and LibreOffice. I definitely don't recommend this path for Office 2003 if you need to return an .ods.

Another solution is to use either of or to open them. Both have Save As ... Microsoft Excel 97/2000/XP (.xls) that is usable in moving the spreadsheet to Microsoft Excel if that is where you need it. If you just want to view and use the spreadsheet, you should use one of those applications. LibreOffice has more-recent releases while Apache OpenOffice won't produce a successor to 3.3 until farther into 2012. It's your choice.

share|improve this answer
What converter are you talking about? – svick Jan 2 '12 at 17:07
This one: - It is the same one that is linked in the previous answer. – orcmid Jan 2 '12 at 22:28

If your files do not hold sensitive data you can upload the ods file to Google Drive. Afterwards open the file as spreadsheet, then use the top menu to download the file as XLS or XLSX. Google does the conversion for you.

Disclaimer: I could not open some files in Excel 2003 after conversion. If you run into the same problem, open the spreadsheet in Google Drive, mark all cells, copy, paste them into a newly created spreadsheet. Downlaod the new spreadsheet, then it works.

share|improve this answer

You must log in to answer this question.

protected by slhck Sep 19 '13 at 6:40

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged .