Software

Ask something
Discussion Locked

Converting Lotus 123 files to Excel

0 helpful
6 replies

by jbeaucaire 4 views

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Is there a program that will convert Lotus 123 files into an Excel program? I have a lot of old 123 files in multiple formats wks wk1 wk3 wk4. I need to convert them to Excel. Anyone with any suggestions?

Thanks

6 replies

by dklippert

Excel will open these files. Go to File>Open and choose Lotus on the Files of type list. Macros may give you some problems, but Excel does a pretty good conversion. Type Lotus in the Help file for more information.

by jbeaucaire

This only works for wk4 files. I need it for the other types of Lotus files, like WK1 & wk3 or 123.

by dklippert

This will probably wrap, but here are the formats supported:

File Formats for Lotus 1-2-3
When you open a .wk1 or .wk3 file in Microsoft Excel, Excel applies the formatting in the associated .fmt, .fm3, or .all file. If you save a Lotus 1-2-3 file in Microsoft Excel format, Microsoft Excel saves the spreadsheet data and formatting in a single workbook file.

The WK1 (1-2-3) (*.wk1) and WK3 (1-2-3) (*.wk3) formats save only limited worksheet formatting. To save a Microsoft Excel workbook in Lotus 1-2-3 format and retain borders, cell shading, fonts, and other formatting, select a Lotus 1-2-3 file format that stores formatting in a separate .fmt, .fm3, or .all file.

The following table lists supported Lotus 1-2-3 file formats. Lotus 1-2-3 file format Version Note
----------------------------------------------------------------------

WK4 (*.wk4) 4.0 Saves the entire workbook

WK3 (*.wk3) 3.x and Saves only worksheets and
WK3, FM3 (*.wk3) Lotus 1-2-3/W chart sheets

WK1 (*.wk1) 2.x Saves only the active sheet

WK1 (FMT) (*.wk1) 1.0 and 1.0A Saves only the active sheetWK1 (ALL) (*.wk1)
WKS (FMT) (*.wks)

.PIC (when included in 3.x and Lotus Open but cannot save this
an .All file) 1-2-3/W format

This discussion is closed to new replies.