How to Convert Lotus 123 to Excel

1. Click the “File” drop-down menu in Excel. Select “Open.” Double-click the Lotus file in the tree that pops up. Spot check the file to see if formula and formats look the way they should. If the formatting is wrong, keep in mind that WK1 and WK3 files save formatting to a separate file. You’ll have to have that file in the same directory as your WK1 or WK3 file.
2. Click the “File” drop-down menu in Excel. Select “Save.” The Save panel will pop up.
3. Select the .XLS file type in the Save panel and click OK. Excel will then convert the workbook to Excel format.
4. Open the new .XLS file. Search on the phrase “formula failed to convert.” If Excel couldn’t convert a formula, it displays the value that the formula produced and leave the “formula failed” comment. Since these are comments, you’ll have to find them by clicking the following sequence: Edit (drop-down menu), Find, Look in: Comments. Return these cells to formulas if possible.
5. Print out the newly converted spreadsheets and compare the numbers to a printout of the original spreadsheet to make sure every formula converted correctly.