What Is .WK4

Content on WhatAnswers is provided "as is" for informational purposes. While we strive for accuracy, we make no guarantees. Content is AI-assisted and should not be used as professional advice.

Last updated: April 10, 2026

Quick Answer: .WK4 is a spreadsheet file format used by Lotus 1-2-3 Release 5 and later versions, introduced around 1992 to replace the earlier .WK3 format. It stores spreadsheet data, formulas, and formatting, though it is largely obsolete today as modern applications like Excel and Google Sheets dominate the market.

Key Facts

Lotus 1-2-3 Release 5 introduced .WK4 format in 1992 as an upgrade from .WK3
.WK4 files support formulas, charts, multiple sheets, and cell formatting unlike simpler .WK1 format
Peak usage occurred in 1990s when Lotus 1-2-3 held 60% of spreadsheet market share before Excel's dominance
Modern applications including LibreOffice Calc, Microsoft Excel, and Google Sheets can open .WK4 files with conversion
.WK4 files remain in legacy systems and older business archives requiring occasional conversion to .XLS or .XLSX formats

Overview

.WK4 is a proprietary spreadsheet file format developed by Lotus Corporation for its popular Lotus 1-2-3 spreadsheet application. Introduced with Lotus 1-2-3 Release 5 in 1992, the .WK4 format represented a significant upgrade from the earlier .WK3 format, offering enhanced functionality and support for more complex spreadsheet operations.

While Lotus 1-2-3 dominated the spreadsheet market in the 1980s and early 1990s, commanding approximately 60% market share at its peak, the format has largely become obsolete with the rise of Microsoft Excel and cloud-based alternatives like Google Sheets. However, .WK4 files remain embedded in legacy systems, archived business documents, and specialized financial applications, making format conversion and compatibility an ongoing concern for organizations managing historical data.

How It Works

.WK4 files function as binary containers that store spreadsheet data in a structured format. The file structure allows Lotus 1-2-3 to efficiently read and write spreadsheet contents while maintaining formula integrity and cell references.

Data Organization: .WK4 files organize spreadsheet information into cells arranged in rows and columns, with each cell capable of containing numbers, text, or formulas that reference other cells
Formula Support: The format maintains compatibility with Lotus 1-2-3's extensive formula library, allowing complex calculations and conditional logic to be preserved when files are opened and saved
Worksheet Tabs: Unlike earlier formats, .WK4 supports multiple worksheet tabs within a single file, enabling users to organize related data across separate sheets while maintaining inter-sheet formula references
Formatting Preservation: Cell formatting attributes including font styles, colors, alignment, and number formatting are encoded within the .WK4 file structure
Chart Embedding: .WK4 files can embed charts and graphs directly within the spreadsheet, with chart data and formatting preserved alongside raw spreadsheet information

Key Comparisons

Aspect	.WK4 (Lotus 1-2-3)	.XLS (Excel 97-2003)	.XLSX (Excel 2007+)
File Size	Smaller binary format, more compact	Larger binary format with extended features	Compressed XML-based, most efficient
Market Adoption	Dominant 1990s, now legacy only	Industry standard 1997-2007	Current standard, 90%+ modern usage
Application Support	Lotus 1-2-3 only, limited modern support	Widely supported with conversion utilities	Universal support across all platforms
Formula Compatibility	Lotus-specific formula syntax	Mostly compatible with modern Excel	Full compatibility with modern Excel
Maximum Sheet Size	256 columns × 16,384 rows	256 columns × 65,536 rows	1,048,576 rows × 16,384 columns

Why It Matters

Legacy System Integration: Organizations managing decades-old financial records, accounting archives, or statistical databases frequently encounter .WK4 files that require conversion or interpretation for modern analysis
Data Migration Challenges: Converting .WK4 files to modern formats like .XLSX presents technical challenges, as Lotus 1-2-3's proprietary formula syntax and specialized functions may not translate directly to Excel without manual intervention
Compliance and Archival: Industries with strict data retention requirements, such as banking and insurance, must maintain the ability to access and verify historical .WK4 files for audit purposes and regulatory compliance
Cost of Obsolescence: The continued existence of .WK4 files in production systems imposes maintenance costs, as organizations must retain specialized conversion software or maintain legacy Lotus 1-2-3 installations to manage these files

Understanding .WK4 format remains relevant for professionals working with historical data, managing legacy systems, or conducting data archaeology projects. While new spreadsheet creation using .WK4 is virtually non-existent, the format's continued presence in corporate archives ensures that knowledge of its structure and conversion requirements remains valuable for IT professionals, data analysts, and records managers worldwide.