Conversion of Lotus spreadsheet (WK1) for Windows

  elder 22:50 19 Nov 2005

A friend uses a Lotus spreadsheet with suffix WK1. When I had Windows 98SE I was able to convert his spreadsheets to make them readable. Now that I have Windows XP I can find no way to convert the Lotus sheets. Any advice please.


  VoG II 22:53 19 Nov 2005

Which program are you trying to open them in?

  elder 04:52 20 Nov 2005

Sorry. I want to convert them to MS Excel

  Abel 10:56 20 Nov 2005

Fire-up Excel
Click File/Open
Click down arrow on "Files of Type"
Scroll down and click Lotus 1-2-3 Files (*.wk1)
Click down arrow on "Look in"
Locate folder in which Lotus wk1 files appear
Click Open and file will be converted
Save newly converted file in Excel

Incidentally, you may see a number of Hash characters in your new file. This simply means that the column is not wide enough for the data it contains. Go to the column headings and hover the cursor/pointer over the dividers between the columns until it changes to a double headed arrow, then double click. The column width will change to accommodate the maximum width of data.


  elder 12:55 20 Nov 2005

Thanks Abel. worked perfectly

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best Amazon Echo: What’s the best Alexa speaker?

Kano Computer Kit Complete review: A fun DIY 'laptop' that teaches kids to code

Best pro photo editors for Mac 2018

TV & streaming : comment regarder les Jeux olympiques d’hiver 2018 ?