How to Convert Lotus 123 Files to Excel

Written by ken burnside Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Convert Lotus 123 Files to Excel
(Siri Stafford/Digital Vision/Getty Images)

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:
Easy

Other People Are Reading

Things you need

  • Excel 1997 or later
  • Lotus 123 (recommended)

Show MoreHide

Instructions

  1. 1

    Open your file in Lotus 123.

  2. 2

    Go to the "File" menu, select "Save As," and save it as a Microsoft 97 file (*.xls).

  3. 3

    Open the resulting .xls file in Excel.

  1. 1

    Open Excel.

  2. 2

    Locate the Lotus 123 file (with an extension of *.wk4 in most cases).

  3. 3

    Click "Open." Excel will prompt you for approval before converting the file.

  4. 4

    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.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.