Conversion of Lotus spreadsheet (WK1) for Windows

  elder 22:50 19 Nov 05

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 05

Which program are you trying to open them in?

  elder 04:52 20 Nov 05

Sorry. I want to convert them to MS Excel

  Abel 10:56 20 Nov 05

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 05

Thanks Abel. worked perfectly

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

Hands-on: Acer Predator Triton 700 review

1995-2015: How technology has changed the world in 20 years

This poetic animation about monsters is illustrated in a Van Gogh painterly style

Apple predictions 2017