First time here? Check out the FAQ!
x

How to Convert Wk1 to Xls?

0 votes
asked by
edited by

I want to convert a WK1 Lotus file to Excel file format. Is it possible?

2 Answers

0 votes
answered by (100k points)
edited by

You do not need an advanced converter to accomplish this request, instead you can use Excel, by default, to open Lotus files that were created in 2.0 all the way through 2.2 versions. The standard format Lotus saves files is WK1, just like the files you have. After you import the files into Excel, some menus will become available where you can audit the file you just imported. To be able to import the files, you first need to select List all files then browse to the location of your Lotus file. You can also use macros for your WK1 files as well as all the standard features that Excel offers such as charts, graphs, commands or functions.

commented by (100 points)
Andrew is right, but only Excel 2002 and prior can read wk1 files. Everyone else stupidly abandoned converting the platform.  If you work with local governments or even the Federal Government in the USA, you still need to submit data to them in wk1 format.  Smartest answer is to shop around for Lotus 1-2-3 DOS versions 2.x and Funk Software DOS version Worksheet Utilities, because Excel and all other Windows-platform spreadsheets are less functional.  Excel 2002 and prior cannot itself program the wk1 functions, but can READ and CALCULATE the functions, if you first do your worksheet in DOS.

I don't know whether the MAC OS can read wk1 files, but I doubt it, since MAC uses Windows products for its own Office stuff.  So ask Apple.

Latest Windows platform on which you can comfortably use a DOS window, is XP Pro SP3.  It might be possible to run a DOS program in 32-bit Windows, I'm not sure.  According to MS Answers forum, you'd have to get DOSBOX to run in Win7 64-bit.  I have no idea how valid that is, since I refuse to upgrade.  Am only reporting what I found in Google.

Win8 is an arcane interface over Win7, so maybe the foregoing paragraph will also be true for Win8.  Again, I'm only guessing, as I refuse to upgrade.
0 votes
answered by

You can safely download and use Gnumeric which is an open source spreadsheet software capable of opening almost all formats and converting to each other.

Mustafa Esitgen

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register
...