Importing a Works Spreadsheet into Excel

Posted on 2003-02-26
Medium Priority
Last Modified: 2013-12-27
A friend of mine bought a new XP computer with Microsoft Excel 2002.

He used to do his spreadsheets in Works with the extension of .wks.  We are trying to transfer all his spreadsheets to the new computer.  He does not have Works on the XP computer and when we try to open the Works Spreadsheet in Excel, it said it is not the right format.

We cannot find anything that has a converter to do the job for us.

Is there an easier way to convert these documents to the Excel format.  The only way we know is to Save each file (and there are many) as an Excel document.  Then bring it over to the new XP computer.

I'm hoping that we can just import each one into the Excel spreadsheet but can't find a way to do so.

Thanks for your help.

Question by:Jeanne061397
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 18

Accepted Solution

Curt Lindstrom earned 200 total points
ID: 8031240
When you open a file in Excel it provides "Microsoft Works 2.0" as one of the options in "Files of type"
What version of Works did your friend use?

Regards Curt
LVL 43

Expert Comment

by:Steve Knight
ID: 8032740
Is this Word Perfect Works rather than Microsoft Works by any chance?  Only real solution I found for WP Works documents was SaveAs to Excel etc. from Works as I haven't found a converter for XL that will read them either.

If it is that, listening for a solution myself...


Author Comment

ID: 8033826
My friend uses Microsoft Works spreadsheet (not Word Perfect Works).  I'm having him check out the possible solution that Curt has suggested.  I'll let you know if this works and also find out what version of Works he is using.

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

LVL 43

Expert Comment

by:Steve Knight
ID: 8033861
That should be simpler then, confusion is both are called "works" by people I have dealt with you see and they are somewhat different..

No reason why Curt's suggestion shouldn't work in that case.

LVL 17

Expert Comment

ID: 8034383
I have run into this many times.  The answer is to open Excel first then use file open and select the works file.  

You will not be able to double click on the .wks file as it is not associated with Excel.  I would personally suggest not associating it with the Excel program.

Hope this helps.

Author Comment

ID: 8074848
Thanks for you help.  He was able to finally open his document.


Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Curious about the latest ransomware attack? Check out our timeline of events surrounding the spread of this new virus along with tips on how to mitigate the damage.
This month, Experts Exchange’s free Course of the Month is focused on CompTIA IT Fundamentals.
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

801 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