How to Convert Lotus to Excel 2007

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.

Woman helping man with computer
credit: Jupiterimages/Pixland/Getty Images

Step

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

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

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

Step

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

Step

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

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

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

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.