How can I convert a wks spreadsheet file to open in ms office / open office i can find text convertors but not for this!

This question i have already posted......but read below please

I have a client with a windows 95 computer and works Version 4 installed

They have a spreadsheet on the desktop will a whole years sales data on it,  usually by double-clicking it will open in spreadsheet using works 4.

However, when it is double clicked the computer starts to load works 4 then asks;

do you want to open this document using
1) wordprocessor
2) spreadsheet
3) database

so they select spreadsheet

then it says which format do you want to open using;

1) DOS
2) Windows

they select Windows format

the file then loads but presents loads of rubbish ..... computer type language..

now the only thing I can think is, was there a power failure while this file was open or a system crash.  Or has the file extension changed.

Finally,  can you install Office 97 on a win 95 pc or could I transfer this file to my up to date pc and try opening it eg using win 2000 or xp?

my knowledge doesnt really take me back this far so can anyone help me please?



I probably have come to the conclusion that the file is corrupt BUT

I have come across TEXT convertors on MS website etc and seen more evidence opf ths on google, however, I need to try and locate the convertor to this WKS spreadsheet file to a readable format on open office or MS office.  Someone has told me he was has in the past had a few works / MS spreadsheets corrupt on him in the past but was able to open it using star/open office


Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

byundtMechanical EngineerCommented:
Hi auraorange,
The wks file format is for Lotus123. Microsoft Excel should be able to import it using File...Open menu item. I suggest transferring the file to a machine that has Office on it, then opening it and saving as an Excel file format.



Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
byundtMechanical EngineerCommented:
StarOffice used to be a free download, but now appears to be commercial software ($79.95 at ). It does have a reputation for being able to open files that Microsoft Office cannot--but the Open and Repair tool in Excel XP and Excel 2003 has been able to meet my needs in that respect. If your file is corrupt because you have lost one or more file segments (lost clusters), then you'll need to resort to disk repair tools (like Norton DiskDoctor)--or else locate an older copy of the file that hasn't been damaged.
Hi  auraorange,

Yes, you can definitely install Office 97 on a Windows 95 box. As to transferring it to a 2000 or XP machine, you can do that too. They would need some form of MS Office on them. Excel would be my choice for opening your spread sheet. It seems to be able to deal with most spreadsheets quite well.

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Can it be opened as Database? If so, then save it to CSV (option may be called "Text and Commas"). You should then be able to open the file in Excel, and possibly even in the Spreadsheet part of Works.

Note: You can choose to save the file in DBF format out of Works Database (instead of CSV) but it will truncate field names to 10 characters, so you would need to be sure that the 1st 10 characters of each field name are unique. Then of course in Excel you would change the Open type to DBF.
I mean, when presented with the option to open it with Word Processor, Spreadsheet, or Database, will it open with Database?
byundt: is still available for Free.  Except if you are running Linux.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.