Lotus 1-2-3

From Just Solve the File Format Problem
(Difference between revisions)
Jump to: navigation, search
(Added file extension (.123) for Lotus 97/9.x format)
Line 2: Line 2:
 
|formattype=electronic
 
|formattype=electronic
 
|subcat=Document
 
|subcat=Document
 +
|subcat2=Spreadsheet
 
|extensions={{ext|wks}}, {{ext|wk1}}, {{ext|wk2}}, {{ext|wk3}}, {{ext|wk4}}, {{ext|123}}
 
|extensions={{ext|wks}}, {{ext|wk1}}, {{ext|wk2}}, {{ext|wk3}}, {{ext|wk4}}, {{ext|123}}
 
|mimetypes={{mimetype|application/vnd.lotus-1-2-3}}
 
|mimetypes={{mimetype|application/vnd.lotus-1-2-3}}

Revision as of 23:18, 24 April 2018

File Format
Name Lotus 1-2-3
Ontology
Extension(s) .wks, .wk1, .wk2, .wk3, .wk4, .123
MIME Type(s) application/vnd.lotus-1-2-3
PRONOM x-fmt/116, x-fmt/117, x-fmt/114, x-fmt/115
Released 1983-01-26

Lotus 1-2-3 was regarded as the "killer app" of the IBM PC in its early days, just as VisiCalc was for the Apple II platform. Both were spreadsheets which used a similar interface, still familiar to modern spreadsheet users, consisting of a matrix of rows and columns where the columns have letters and the rows have numbers, and a cell can be addressed by an address such as "B2".

After years of dominance of the spreadsheet market for PC/MS-DOS, 1-2-3 failed to successfully move over to the Windows platform, and was eclipsed by Microsoft Excel. Making 1-2-3 part of a new "Lotus SmartSuite" didn't help bring it back to prominence. When 1-2-3 was finally officially discontinued in 2013 (by IBM, which now owns Lotus), the general reaction was "What, they still made 1-2-3 until now? I thought it died a long time ago."

The original 1-2-3 files had a .wks extension. Version 2.0 originally used a .wk1 extension, but that was soon changed to .wk2, and from then on the number in the extension corresponded to the program version number. Lotus Symphony (the '80s version, not the unrelated 2000s version which used a variant of Open Office format) used a similar file format.

Contents

Format specs

End of support

IBM officially ceased its support for Lotus 123 on 30 September 2014 (see the announcement here). This also applies to its SmartSuite and Organizer products.

Support by modern spreadsheet software

Support of the Lotus 1-2-3 formats has shown a steady decline over recent years. Although older versions of Microsoft Excel were able to read (some of?) these formats, Excel 2010 doesn't support any of them anymore, as shown in this overview of unsupported formats on Microsoft's website. Meanwhile, OpenOffice only supports the old (.wk1, .wks and .123) versions of the format (source here). No specific info could be found on LibreOffice, but the situation is probably identical to OpenOffice.

Sample files

Import/export info

See also

Other links

Personal tools
Namespaces

Variants
Actions
Navigation
Toolbox