Open AppleWorks spreadsheets in Mac OS X when Numbers won't work

Question

I have a number of old AppleWorks spreadsheets that I'm trying to open. I've tried a number of solutions that I've found while searching for an answer (below), but none of them really get me to where I want to be. Anyone know of a simple solution?

1. Open in Numbers.app

When I try to open them in Numbers.app, I get the following error. I think the issue may be that these documents were not made in the final version of AppleWorks (many are so old they were made when it was still called ClarisWorks).

Import Error

The document was created with an unsupported version of AppleWorks.

2. Use an old Mac to convert them to the most recent version of AppleWorks, then use Numbers.app

Unfortunately I don't have an old Mac to do this with.

3. Use some hacky solution to extract text from the files

I was able to open the file with text editors, but I'm aiming to keep the formatting and functionality and not spend lots of time parsing text.

Answer 1

These files will open just fine in LibreOffice. Mac OS X (tested on OS X 10.11.5) does recognize that each of the files I want to open is an "AppleWorks Document" (as can be seen in the "Kind" column in Finder.app), but it does not know that LibreOffice can open it.

After you've downloaded and installed LibreOffice, there are a few more steps to get them open:

1. Right click on the AppleWorks document you want to open.
2. From the contextual menu's "Open With" submenu, select "Other…".

This will open the "Choose Application" window. In that window:

1. From the "Enable" pulldown menu, select "All Applications".
2. If you want LibreOffice to automatically open this document going forward, check "Always Open With".
3. Select LibreOffice. You'll get a warning staying that "It's not known if this application can open" the document. Don't worry about that!
4. Click "Open".

You should now be looking at a well-formatted spreadsheet in LibreOffice. It looks like the original formatting has been maintained; the spreadsheets I opened have colors, italic, bold, etc.

Once you've got it open in LibreOffice, from the "File" menu select "Save As" and you'll have the option to save it in any number of supported formats, such as Excel. Once that's done, your AppleWorks spreadsheet data has been brought into the modern world.

If you always want AppleWorks docs to open with LibreOffice, follow these instructions.

Answer 2

LibreOffice works great on old Appleworks spreadsheets. I had to open them directly (rather than drag-and-drop), a tiny issue. Thanks, all.