xlsx & openoffice

November 11, 2007

By ikd

In an earlier posting, I wrote about a filter to open docx files in open office. Unfortunately, this is half the story in this world of digital, paperless office. What happens in the case of Excel 2007 files?

Now, these files have an extension of xlsx. Note the slight difference from the typical xls extension of previous versions of Excel. This may sound like a small deal, but it is not if you don’t have Office 2007. Mind you, office xp, 2k do not open naturally these files. More, Office 2007 saves files in xlsx (and docx), so easily the mistake can be made and presto, you have a file only you can open and read and share with yourself. Great move for productive minds!

I looked in the usual places for solutions. There are a few online services, like zamzar and docx2doc, which will convert your files from and to the new formats (if you want to share your files with someone else). A search for some perl scripts and modules gave quite a few answers NOT for the lighthearted, though.

The method I tried and worked for me was to use the Excel 2003 viewer with the addition of the 2007 FileFormat Converter. Even this method is kludgy. You have to:

install the converter,
double click on the file (cannot open the file directly from within the viewer),
watch it being transformed),
select the sheet (or parts of it),
do the copy-paste trick to the earlier version of Excel or OpenOffice,
Optionally, curse and swear at the madness of Office 2007.

The funny part is that xlsx is supposedly an open format, an xml variation. So, if you rename the file from filename.xlsx to filename.zip and unzip it, you will get a bunch of files and directories with encodings and content. Then you can open the xml file that is at the heart of the xlsx spreadsheet and see its content.

Enjoy!

OpenOffice.org beta fails the Office 2007 test [via Zemanta]
iWork and Office: Can they work together? [via Zemanta]
Microsoft makes last-gasp OOXML push [via Zemanta]
IBM releases ODF-based Office killer [via Zemanta]
Microsoft confirms Excel bug, hacks; recommends blocking files [via Zemanta]
ODF wins the office document format war? [via Zemanta]
OpenOffice.org 3 for Mac Beta is available [via Zemanta]

Svante on May 21, 2008 at 9:31 am

Thank you mate, really saved me alot of trouble !
ikd on May 21, 2008 at 2:11 pm

@Svante:
We aim to please! Of course, when you open the xlsx file in OpenOffice, don’t forget to save it as ods (the OpenOffice extension) or, at least, xls (the “old” Microsoft version) for the unfortunate souls who have not yet switched.

I.
microsoft ofice will not support older microsoft office formats « Blah blah blah on June 20, 2008 at 10:59 am

[...] ones, too. Yes, I am referring to the newer marketing stint from microsoft with the docx and xlsx files which do not open with older versions of office, say office [...]
GX on October 2, 2008 at 3:38 pm

What are you supposed to do if you are running on linux?
zamzar still hasnt sent email with the converted version after some time and
docx2doc does not support xlsx clearly online converters are untrusted and unreliable I hope that this does nothing more than alienate micro$osft!
Waleed on December 2, 2009 at 3:38 pm

Thank you for your kind effort.