How to Convert Lotus to Excel 2007

By R.L. Cultrona

In the past users of Lotus 123 could open their spreadsheets in Excel. However, Microsoft deactivated that feature for its Excel 2007. This means that users of Lotus could no longer share their spreadsheets with Excel users.

Things You'll Need

  • Computer
  • Lotus 123
  • OpenOffice
  • MS Excel 2007

Step 1

Open the file you need to convert in Lotus. Click on the "File" menu button in the top bar then click on "Save As." This will open up a save dialog box.

Step 2

In the dialog box, browse folders until you find the location you want to save the file in and rename the file. Click on the drop down menu next to "Save as Type" and save the file as a .wk1, .wks, or .123 file. These are earlier versions of Lotus files.

Step 3

Download the OpenOffice suite at OpenOffice is a free set of office productivity programs which includes a word processor, spreadsheet, presentation, database, drawing program and a calculator.

Step 4

Double click on the OpenOffice icon to bring up the launch screen. Click on the button "Spreadsheet" to open the spreadsheet program.

Step 5

Click on the "Open" button in the top menu bar (it looks like an file folder). Search for the file you saved, click on it to select it, and then click "Open" to open the file in OpenOffice.

Step 6

Click on the "File" menu in the top bar to open a drop down menu. Click on "Save As" to open the "Save File" dialog box.

Step 7

Browse though the folders to determine where you would like this file to be saved and rename the file. Click on the drop down menu next to "Save as type" to bring up a list of acceptable file types. Click on "Microsoft Excel (.xls)." Click on "Save."

Step 8

Open Excel 2007. Click on the Windows icon at the top left of the screen and click on "Open." Browse through the folders until you find the file you saved in OpenOffice, click on it to select it, and click on "Open" to open it in Excel.

Tips & Warnings

  • OpenOffice can not only convert Lotus to Excel, but allows for the opening and saving as many different file types. Play with the program to see if there is anything else you can use it for.
  • You have to save the file as one of the earlier versions of Lotus. OpenOffice does not recognize files which are have a .wk3 or .wk4 extension.