At one point, Lotus 123 was the dominant spreadsheet on the market. It steadily lost market share to Excel through the 1990s. Loading Lotus 123 files into Excel is doable, and there are two ways to do it: Saving the file in Excel format from Lotus 123, or opening the Lotus 123 file in Excel and letting Excel handle the conversion.
- Skill level:
Other People Are Reading
Things you need
- Excel 1997 or later
- Lotus 123 (recommended)
Open your file in Lotus 123.
Go to the "File" menu, select "Save As," and save it as a Microsoft 97 file (*.xls).
Open the resulting .xls file in Excel.
Locate the Lotus 123 file (with an extension of *.wk4 in most cases).
Click "Open." Excel will prompt you for approval before converting the file.
Go to the "File" menu, and select "Save As" to save a copy of the file as an Excel native format.
Tips and warnings
- There are a number of places where functions work differently between the two spreadsheets. If you have access to both programs, check the formula results to spot discrepancies. To get a list of these differences, please see the References section.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for