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

Posted on 2004-11-08
Last Modified: 2012-06-27
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


Question by:auraorange
    LVL 80

    Accepted Solution

    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.


    LVL 80

    Expert Comment

    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.
    LVL 1

    Expert Comment

    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.

    LVL 8

    Expert Comment

    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.
    LVL 8

    Expert Comment

    I mean, when presented with the option to open it with Word Processor, Spreadsheet, or Database, will it open with Database?
    LVL 31

    Expert Comment

    byundt: is still available for Free.  Except if you are running Linux.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Suggested Solutions

    Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
    The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
    This video will demonstrate how to find the puppet warp tool from the edit menu and where to put the points to edit.
    The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now