How to Convert Lotus 1-2-3 to Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
IBM stopped supporting Lotus 1-2-3 in 2013.
Image Credit: Drazen_/iStock/Getty Images

When you want to open a Lotus 1-2-3 spreadsheet in Microsoft Excel, you must first convert the files to the Excel format. Microsoft stopped supporting Lotus spreadsheets in 2007. If you still have access to a computer with Lotus 1-2-3 installed, the simplest solution is to reopen the files and then save them in the Excel format. If you don't have access to the original software, you can also use free spreadsheet applications, such as Gnumeric, Apache OpenOffice or LibreOffice to do the conversion.

Advertisement

Gnumeric

Video of the Day

Step 1

Download and install the Gnumeric spreadsheet application (link in Resources). This open-source software is free for anyone to use, and is available for both Windows and Linux. It supports all of the Lotus 1-2-3 extensions, including 123, WKS, WK1, WK2, WK3 and WK4.

Advertisement

Video of the Day

Step 2

Launch Gnumeric and open your Lotus 1-2-3 file. When opening the file, change the file type option from "Spreadsheets" to "All Files," in order to see the filename in the list.

Step 3

Save the file as an "MS Excel 97/2000/XP" file. This saves the spreadsheet as an XLS file, which you can open in all recent versions of Excel, including Excel 2013.

Advertisement

OpenOffice/LibreOffice

Step 1

Download and install either Apache OpenOffice or LibreOffice (links in Resources). These free open-source applications are almost identical, and are available for the Windows, Linux and Mac operating systems. These applications can only open Lotus 1-2-3 files with a 123, WK1 or WKS extension.

Advertisement

Advertisement

Step 2

Open your Lotus 1-2-3 file. Select "Western Europe" as the character set when prompted.

Step 3

Save the file as a "Microsoft Excel 97/2000/XP" file. This saves the spreadsheet as an XLS file, which you can open in all recent versions of Excel, including Excel 2013.

Advertisement

Advertisement

references & resources