What Is 1-2-3

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 11, 2026

Quick Answer: 1-2-3, officially Lotus 1-2-3, is a pioneering spreadsheet application developed by Mitch Kapor and released in 1983 for IBM PCs. It became the dominant spreadsheet software of the 1980s and 1990s, selling over 10 million copies, before eventually being overshadowed by Microsoft Excel in the 2000s and discontinued in 2014.

Key Facts

Released on January 26, 1983, by Lotus Development Corporation, founded by Mitch Kapor
Became the first killer application for IBM PCs, driving widespread PC adoption in business
Dominated the spreadsheet market with over 10 million copies sold by the 1990s
Combined spreadsheet, charting, and database capabilities in integrated package
Discontinued by IBM in 2014 after losing market share to Microsoft Excel

Overview

Lotus 1-2-3 is a landmark spreadsheet application that revolutionized personal computing and business operations. Released on January 26, 1983, by Lotus Development Corporation and created by Mitch Kapor, it became the first genuine killer application for IBM PCs, driving millions of business users to adopt computers for financial analysis and data management.

The software earned its name from its three primary features: spreadsheet calculations (1), graphing capabilities (2), and database management (3). By the early 1990s, 1-2-3 had sold over 10 million copies and maintained approximately 50% of the worldwide spreadsheet market, making it one of the most successful business software applications in computing history.

How It Works

The core functionality includes:

Spreadsheet Grid: Users organize data into rows and columns, entering formulas and functions to perform complex calculations automatically, with the ability to recalculate entire sheets in seconds.
Graphing Engine: Built-in charting tools create visual representations of data, including bar charts, line graphs, and pie charts, directly from spreadsheet data without external software.
Database Module: The application includes database functions allowing users to sort, filter, and query data stored in spreadsheet format, bridging spreadsheet and database functionality.
Macro Programming: Advanced users can automate repetitive tasks using 1-2-3's macro language, creating custom workflows and complex business processes within the application.
File Import/Export: Supports reading and writing multiple file formats, enabling data exchange with other business applications and databases.

Key Comparisons

Feature	Lotus 1-2-3 (1983)	Microsoft Excel (1985)	Modern Spreadsheets
Initial Market Position	Dominant, 50%+ market share by 1990s	Secondary player initially	Cloud-based and collaborative
Integration Features	Built-in charting and database tools	Expanded visual capabilities	AI, real-time collaboration, automation
Platform Availability	DOS, Windows, Mac, OS/2	Windows, Mac, Cloud	Web-based (Google Sheets, Microsoft 365)
Development Period	Released 1983, discontinued 2014	Released 1985, actively developed today	Continuous updates and new features

Why It Matters

Historical Significance: 1-2-3 demonstrated that spreadsheet software could drive computer adoption in business, essentially creating a new product category that became essential for corporate operations.
IBM PC Catalyst: By making the IBM PC indispensable for financial analysis, 1-2-3 accelerated IBM's dominance in personal computing and legitimized PCs as serious business tools.
Innovation Template: The three-in-one approach (spreadsheet, charting, database) established a model for integrated business software that influenced application design for decades.
Market Competition Driver: The success of 1-2-3 prompted Microsoft to develop Excel, sparking competitive innovation that benefited users through improved features and capabilities.

Although Microsoft Excel ultimately displaced 1-2-3 as the dominant spreadsheet application by the late 1990s and 2000s, the original software's impact on computing history remains significant. 1-2-3 proved that single-purpose applications could transform entire industries and demonstrated the enormous market demand for business productivity software. Today's spreadsheet applications, from Excel to Google Sheets, owe a conceptual debt to 1-2-3's integrated approach and user-friendly design that democratized data analysis for everyday business users.