.WK1

WK1 File

Lotus 1-2-3 Release 2 Worksheet
Ask a question
QUICK ANSWER

A WK1 file is a spreadsheet created by Lotus 1-2-3 Release 2.x for DOS (1985). Modern Microsoft Excel cannot open it - support was removed in Excel 2007. Use the free LibreOffice Calc or Gnumeric to open the file and save it as XLSX or CSV.

Developer: Lotus Development Corporation (later IBM) Category: Spreadsheet Files MIME: application/vnd.lotus-1-2-3
OPENS ON Windows macOS Linux
Related: .ODS · .NUMBERS · .XLSX · .XLSB

On this page

19k+ extensions indexed
Last reviewed Jul 5, 2026

Not sure what your file is?

Drop any file into our identifier - we read just the first bytes to name the format.

Identify a file

What is the WK1 file format?

A .wk1 file is a binary spreadsheet created by Lotus 1-2-3 Release 2.x (1985), the DOS-era spreadsheet that dominated the personal-computer productivity market before Microsoft Excel overtook it in the mid-1990s. The .wk1 format became so widely deployed that virtually every competing spreadsheet of the late 1980s and early 1990s implemented an importer for it.

The file is structured as a sequential stream of type-length-value binary records, opening with a Beginning-Of-File (BOF) record and closing with an EOF record. The BOF record's 2-byte version word 0x0405 identifies the file as Release 2.x (.wk1), distinguishing it from the earlier .wks (Release 1.x) and the later .wk3 and .wk4 formats. Individual records encode cell values (blank, integer, float, formula, or label), column widths, named ranges, print settings, and graph data.

.wk1 is a single-sheet format limited to 256 columns × 2,048 rows (A1 to IV2048). Multi-sheet support did not arrive until .wk3 (Lotus Release 3, 1989).

The format specification was published by Lotus in 1984-1985 and is well-documented for its era. IBM ended Lotus 1-2-3 sales in 2013 and support in 2014. Modern Excel (2007+) dropped the Lotus import filter; LibreOffice Calc and Gnumeric still read .wk1 files natively.

Security & safety

RISK: LOW

WK1 is a DOS-era binary spreadsheet with no modern macro/scripting payload. Opening one in LibreOffice or Gnumeric carries essentially no risk. The main concern is data preservation: WK1 is very old and a few Lotus @functions may not survive conversion perfectly, so validate results after opening. Avoid sketchy "WK1 converter" download sites that could bundle adware; use official LibreOffice or Gnumeric instead.

Format details

in a nutshell
FULL NAMELotus 1-2-3 Release 2 Worksheetaka Lotus 1-2-3 WK1 spreadsheet, Lotus 2.x worksheet
DEVELOPERLotus Development Corporation (later IBM)since 1985 (Lotus 1-2-3 Release 2.0 for DOS)
MIME TYPEapplication/vnd.lotus-1-2-3
TYPEProprietary binary spreadsheet (binary record stream)
MAGIC BYTES · FILE SIGNATURE
OFFSET
000102030405060708090a0b0c0d
HEX
0000020006040600080000000000
ASCII
··············
WK1 begins with a Beginning-Of-File (BOF) record: 2-byte record type 0x0000, 2-byte length 0x0002, and a 2-byte version code 0x0405 (for Release 2.x). The extended signature above (14 bytes) further identifies the file type. There is no ASCII magic string. The version word in the BOF distinguishes WK1 (v2.x) from WKS (v1.x) and WK3/WK4 (later releases).

Programs that open WK1 files

Windows3 apps
Gnumeric Open-source Open the .wk1 - Gnumeric supports the full Lotus WK* family (WKS/WK1/WK3/WK4/.123). Particularly good for tricky legacy files.
LibreOffice Calc Open-source File > Open the .wk1; Calc imports it directly. Then Save As XLSX/ODS/CSV. The most reliable free opener for WK1 in 2026.
Corel Quattro Pro (WordPerfect Office) Paid Quattro Pro historically imported Lotus WK1. Use only if already owned; LibreOffice Calc is the free alternative.
macOS1 app
LibreOffice Calc Open-source Open the .wk1 on macOS and re-save as XLSX/ODS/CSV.
Linux2 apps
Gnumeric Open-source Lightweight spreadsheet with strong Lotus WK* family support on Linux.
LibreOffice Calc Open-source Open the .wk1 - bundled with most Linux desktops; includes the Lotus WK importer.

Technical details

deep spec
ContainerSequential binary record stream (type-length-value records, BOF to EOF)
BOF version word0x0405 at bytes 4-5 identifies Release 2.x (.wk1)
Record structure2-byte record type + 2-byte length field + variable-length payload
Grid limit256 columns × 2,048 rows (A1 to IV2048); single worksheet only
Cell typesBlank, 16-bit integer, IEEE 754 double, tokenized formula, label (string)
Byte orderLittle-endian throughout
Password protectionOptional; extremely weak scheme, trivially bypassed
Typical file sizeA few KB to ~1 MB (single-sheet DOS-era data)
MIME typeapplication/vnd.lotus-1-2-3
Modern supportLibreOffice Calc and Gnumeric read .wk1 natively; Microsoft Excel 2007+ dropped the filter
Successor formats.wk3 (Release 3, 1989 - 3D multi-sheet), .wk4 (Release 4, 1993), .123 (Lotus Millennium)
Format documentationPublished by Lotus Development Corporation, 1984-1985; widely used by third-party importers
Operating systemDOS (native); Windows, macOS, Linux via importers
Released1985 (Lotus 1-2-3 Release 2.0 for DOS)
Latest versionWK1 corresponds to Lotus 1-2-3 Release 2.x; superseded by WK3 (Release 3) and WK4 (Release 4)
Specificationfileformats.archiveteam.org

WK1 conversions

Community Q&A

asked by users
Ask a quick question
Get help from people who work with WK1 files. Be specific - include your system and software version.
No account needed · answers usually within a day

No questions yet - be the first to ask about WK1 files.

Frequently asked questions

How do I open a WK1 file?
Use the free LibreOffice Calc or Gnumeric - both import Lotus 1-2-3 WK1 files directly. Modern Microsoft Excel (2007 and later) cannot open WK1; open it in LibreOffice and Save As XLSX first.
Why won't Excel open my WK1 file?
Microsoft removed the Lotus import filters from Excel 2007 and later. Excel 2003 and earlier could open WK1. Use the free LibreOffice Calc or Gnumeric to open it and convert to XLSX.
How do I convert WK1 to Excel XLSX?
Open the .wk1 in LibreOffice Calc or Gnumeric and Save As > Excel 2007-365 (.xlsx). Check complex formulas after conversion - some Lotus @functions translate differently.
What program made WK1 files?
Lotus 1-2-3 Release 2.x for DOS (1985). IBM, which acquired Lotus, ended sales of 1-2-3 in 2013 and support in 2014; the program is now abandonware.
Is WK1 the same as WKS or WK3?
Related but different: WKS = Lotus 1-2-3 Release 1.x (1983); WK1 = Release 2.x (1985, single-sheet); WK3 = Release 3.x (1989, first 3D multi-sheet); WK4 = Release 4/5 for Windows (1993). All are in the same binary record-stream family. LibreOffice and Gnumeric open all of them.
Is there a free tool to convert WK1 to CSV or XLSX?
Yes - LibreOffice Calc and Gnumeric are free and open-source. Both import WK1 and export to XLSX, ODS, and CSV.

References

1Wikipedia - Lotus 1-2-3en.wikipedia.org
2Just Solve the File Format Problem - Lotus 1-2-3fileformats.archiveteam.org

Keep exploring

across the database

Top extensions this week

1.AQQAQQ Instant Messenger File
2.BINCD/DVD Disc Image (BIN/CUE)
3.MDMarkdown Document
4.CRDOWNLOADChrome Partial Download File
5.RPMSGRestricted Permission Message
6.PARTPartial Download File
7.NOMEDIAAndroid No-Media Marker File
8.EXEWindows Executable (Portable Executable)
9.SWFSmall Web Format (Shockwave Flash)
10.DAVDVR365 / Dahua DVR Video File (DHAV stream)

Related extensions

.ODSOpenDocument Spreadsheet
.NUMBERSApple Numbers spreadsheet
.XLSXMicrosoft Excel Open XML Workbook
.XLSBMicrosoft Excel Binary Workbook
.GSHEETGoogle Sheets Shortcut (Link to a Google Sheets spreadsheet)
.XLSMMicrosoft Excel Macro-Enabled Workbook (Open XML)

Free file tools

An in-browser file identifier and image converter - everything runs on your device.

Open the toolbox

Browse file extensions A-Z