How to Convert Wk1 to Xls

1. Confirm that both the data and the format file for the WK1 file are in the same folder.
2. Open the Excel “File” drop-down menu. Click “Open.” Find and open the WK1 file in the folder tree. Don’t open the formatting file yourself, just the file with the WK1 extension.
3. Open the “File” drop-down menu again. Click “Save.” Select .XLS as the file type in the Save panel. Select “OK.” Excel then converts the workbook into the Excel format.
4. Open the converted .XLS file to check for errors. Search for the phrase “formula failed to convert.” If Excel was not able to convert a formula, it defaults to displaying the value that the formula produced and writes “formula failed” in a cell comment. To search the comments for this phrase, open the Edit drop-down menu and click following sequence: 'Find > Look in: Comments.' Recreate the lost formulas where possible.
5. Print out the new spreadsheets and compare the numbers with printouts of the original Lotus workbook spreadsheets, if they are available. This is an additional check to make sure the conversion was performed correctly.