Lotus 1-2-3

Lotus 1-2-3 was a spreadsheet program from Lotus Development Corporation, first released in 1983 for the IBM PC, with Release 1A following the same year. It quickly displaced VisiCalc as the leading spreadsheet and became the application most associated with the rise of the IBM PC in business. For much of the 1980s, the practical reason a company bought IBM PCs and compatibles was to run Lotus 1-2-3.

The name reflected the product’s pitch: three capabilities in one program. It combined a recalculating spreadsheet, business graphics for turning columns of numbers into charts, and basic database operations such as sorting and querying ranges of data as if they were records. The PCjs archive of the original Release 1A distribution disks shows this structure directly, with separate System, Graph, and utility components shipped together. The Lotus Development Corporation reference manuals document the spreadsheet commands, the library of built-in functions written with the at-sign notation such as @SUM, and the graphing and data features.

A large part of Lotus 1-2-3’s success was speed. It was written to take advantage of the IBM PC hardware, and parts of it were coded in assembly language for performance, which made it noticeably faster than the spreadsheets that had come before. Its menu system, driven by the slash key, and its keystroke commands became so familiar that they were treated as a standard, and later spreadsheets including Microsoft Excel offered Lotus-compatible key sequences to ease the transition for users.

Lotus 1-2-3 also drove the rise of the macro: users could record or write sequences of keystrokes and commands to automate repetitive work, and this grew into a full programming facility within the spreadsheet. Combined with the integration of graphics and data handling, this made 1-2-3 a platform on which entire business processes were built, not just a calculator.

The product dominated the DOS era but struggled to make the transition to Microsoft Windows, where Excel ultimately overtook it during the early 1990s. Lotus Development was later acquired by IBM. Even so, Lotus 1-2-3 stands as the application that confirmed the IBM PC as the standard business machine and as the bridge between VisiCalc’s original spreadsheet and the spreadsheets that followed.