Opening an Appleworks spreadsheet in Excel

Question

Opening an Appleworks spreadsheet in Excel

I transfered some files that were created in Appleworks 6.0.4 onto my MacBook with Office: Mac 2004. Nothing seems to open these files. I want to convert (or even copy) them into an Excel spreadsheet. Any suggestions?

MacBook, Mac OS X (10.4.10)

Posted on Oct 7, 2007 3:06 PM

Reply

Answer 1

Brie Fly

Level 5

7,925 points

Oct 7, 2007 4:56 PM in response to MelissaJGraham

Well, one way would be to open the original in AppleWorks and make a copy using "Save As..." and choose an Excel format. Make sure you also append the ".xls" suffix to the file name.

Reply

Answer 2

Oct 7, 2007 5:07 PM in response to Brie Fly

Thank you. In that scenario I would have to purchase Appleworks for OSX on my computer then open them in that application and then save them in excel. Was hoping there would be a simpler (and less expensive)way.

Reply

Answer 3

Sagesse

Level 5

6,685 points

Oct 7, 2007 5:07 PM in response to MelissaJGraham

icExcel will open AW spreadsheets and save them as Excel if you no longer have access to AW.

http://www.panergy-software.com/products/icexcel/features.html

Reply

Answer 4

Oct 7, 2007 5:37 PM in response to Sagesse

Brilliant - icExcel will open AW spreadsheets! Only $20 to solve the problem immediately. Bought it online and already downloaded. Tried it and it opened right away. You have saved my so much time! Now just need to figure out how to save it without copying it and opening Excel to drop it in and resave it.

Reply

Answer 5

Barry

Level 9

60,023 points

Oct 8, 2007 3:23 PM in response to MelissaJGraham

Hi Melissa,

Welcome to Apple Discussions and the AppleWorks forum.

icExcel should also be able to save the spreadsheet as an MS Excel document.

Or you could:

• Open the AW spreadsheet in icExcell
• Select All and Copy*
• Launch MS Excel and open a new spreadsheet.
• Paste, then Save the spreadsheet using MS Excel.

*(I don't know if the select and copy part of this is possible in icExcel)

Regards,
Barry

Reply

Answer 6

Peggy

Level 8

41,847 points

Oct 8, 2007 3:49 PM in response to Barry

*(I don't know if the select and copy part of this is possible in icExcel)

Yes, it is.

Reply

Answer 7

Nov 15, 2007 2:33 AM in response to Brie Fly

Brie Fly
When I try to save an Appleworks (6.2.9) spreadsheet as an Excel Win 2000 document, I get the MaclinkPlus converter window that stalls at about 95% (with spinning beachball) and I have to Force Quit AppleWorks. An Excel document is created but it can't be opened and it is huge (6.8 MB compared to 215 KB), presumably due to file corruption. Any ideas about the reason for this?

Reply

Answer 8

Brie Fly

Level 5

7,925 points

Nov 15, 2007 3:00 PM in response to roger Symons

Roger,

My first guess would be that your AW spreadsheet document is corrupted in some manner (it's usually some unseen formatting or style issue).

Close the document and open a new AW spreadsheet. Drag the old document's icon into the new AW spreadsheet window. Give that newly populated spreadsheet an altered name and save the document to disk. Then try an excel export again from the new version.

Reply

Answer 9

Nov 21, 2007 2:05 AM in response to Brie Fly

Brie Fly
Problem solved, thanks to your suggestion. Only qualification is that you need to format your blank spreadsheet with exactly the same number of rows and columns before dragging the old document's icon onto it.
My original had several text frames, special borders etc. and these, plus headers and footnotes were all lost in the move; also all dates were translated to text. However the new document saved to Excel format without trouble.

Reply