The Spreadsheet Revolution
Abstract
A Harvard student no longer wanted to recalculate numbers on paper every time an assumption changed. What he built with a friend over two months in the winter of 1978–79 became the first “killer app” in computing history, a program that sold hardware rather than the other way around. VisiCalc, Lotus 1-2-3, and Microsoft Excel are three products that mark three eras of the personal computer, and the spreadsheet itself may be the most influential human-computer interface ever invented.
The Paper Problem
Dan Bricklin was a student at Harvard Business School in 1978. Like all MBA students, he spent hours doing “what-if analyses” on large sheets of paper (the greenbar sheets): a company has these costs, that revenue, this growth rate. What happens if you change one assumption? You erase, recalculate, fill in, and discover that three cells further up you forgot a dependency.
Bricklin imagined the paper pad existing on a screen: cells that recalculate automatically when you change a number. He spoke with his friend Bob Frankston, an experienced programmer then living near MIT. Frankston was enthusiastic. They founded the Software Arts Corporation and split the work: Bricklin designed the interface and the logic, Frankston wrote the actual code.
Frankston programmed VisiCalc over two months in the winter of 1978–79, working at night on MIT’s computing systems; daytime usage fees would have been too expensive. He wrote the code so compactly that the finished program fit in 20 kilobytes and ran on an Apple II with 32 KB of RAM, the then-common configuration.
On October 17, 1979, VisiCalc went on sale, produced and distributed by the publisher Personal Software. The price: just under 100 US dollars (it had risen to 250 by 1982).
The First Killer App
What happened next was, up to that point, unique in the history of computing: a software product drove the sale of hardware.
VisiCalc had not been written for hobbyist tinkerers or academics. It was built for a clearly defined professional group: accountants, financial analysts, entrepreneurs. People who worked with columns of numbers every day and who bought an Apple II because they wanted VisiCalc. Not the other way around.
Steve Jobs later recounted watching people carry VisiCalc under their arm in shops and offices and then buy an Apple II to be able to use it. The Apple II had come to market in 1977; sales moved, but slowly. With VisiCalc they exploded.
Info
Software drives hardware, not the other way around. VisiCalc was the first clear historical example of this principle. The Apple II was technically interesting, but VisiCalc made it necessary. The pattern repeated: Lotus 1-2-3 sold IBM PCs, Microsoft Office sold Windows PCs. The lesson (that a computer’s value comes from its software) sounds trivial, but in 1979 it was a genuine surprise for an industry that still thought hardware-first.
Within six years VisiCalc sold more than 700,000 copies, and roughly a million across all versions. Analysts at Datapro Research estimated that VisiCalc was responsible for more Apple II sales than all other reasons combined.
Bricklin and Frankston nevertheless profited less than hoped. They had not patented VisiCalc (software patents were considered legally uncertain at the time) and quickly faced imitators. Above all, the IBM PC arrived in 1981, and VisiCalc for the PC was a quick port, not a new development. A competitor seized the opportunity.
Lotus 1-2-3 and the IBM PC Era
Mitch Kapor was, in the mid-1970s, a transcendental meditation teacher and psychology student who began taking an interest in computers as a hobby. He learned to program, worked briefly for Personal Software (the VisiCalc publisher), and made a precise observation: VisiCalc was revolutionary in effect but limited. It could tabulate. But what about charts? Database queries? Reports?
Kapor founded the Lotus Development Corporation in 1982 and launched Lotus 1-2-3 on January 26, 1983. The name was programmatic: three functions in one program (spreadsheet, charting, database). The price was 495 dollars, five times VisiCalc, and it still sold in record numbers.
What distinguished Lotus technically was that Jonathan Sachs, who wrote the program, spent ten months coding it for the IBM PC: directly on the hardware, in x86 assembly, exploiting every available clock cycle. Lotus 1-2-3 was simply faster than anything that existed before. On an IBM PC with an 8088 processor it computed in seconds what took VisiCalc minutes.
Lotus 1-2-3 dominated the market from 1983 into the late 1980s. It was the best-selling PC software product of its time; Lotus Development Corporation became the most important independent software company in the world before Microsoft. Many people bought an IBM PC not for the operating system or word processing; they bought it for Lotus.
Mitch Kapor was smart enough to know that dominance is transient. What came next came from Redmond.
Microsoft Excel and the Quiet Victory
Microsoft Excel did not first appear for Windows or the IBM PC. It appeared on September 30, 1985, exclusively for the Apple Macintosh.
That was no accident. Bill Gates had recognized that the Macintosh’s graphical interface enabled a different kind of spreadsheet: one operated with the mouse, one that rendered fonts, one integrated directly with graphics. Lotus 1-2-3 was built for the character-based IBM PC mode; on the Mac it looked like a foreign object.
Excel on the Mac was an immediate success, and it showed where things were heading: a spreadsheet that looked like a real document, not like a terminal window.
In 1987 came Excel for Windows 2.0, and here the real race began. Windows was initially slow and unattractive, but Microsoft could do something Lotus could not: develop Excel and Windows together. Every Excel version got better through better Windows; every Windows update was an argument for Excel.
Lotus reacted late. Lotus 1-2-3 for Windows appeared only in 1991 (four years after Excel for Windows) and was slow and buggy. Lotus had held on too long to optimizing DOS instead of developing for Windows.
The end of the contest came with Microsoft Office (1990). By bundling Excel, Word, and PowerPoint into one package and selling it to companies at a discount, Microsoft displaced Lotus not through superior technology but through superior bundling. Lotus Development Corporation was acquired by IBM in 1995 for 3.5 billion dollars, not to save the product, but to secure the technologies and patents.
Dead End: Lotus Improv
In 1991, Lotus released a product that experts praised as conceptually well ahead of everything that had come before: Lotus Improv.
The basic problem of the classical spreadsheet that Improv wanted to solve is real: a spreadsheet model is essentially bound to its geometry. Rows are one thing, columns another, but what if an analysis has three or four dimensions? What if you want to break down quarterly revenue by region, product category, and sales channel? In the classical grid, that forces either endless copying or impenetrable 3D worksheets.
Pito Salas, the lead developer, designed Improv around a different paradigm: items, categories, and views. Instead of cells in a fixed geometry, the user arranged named data points in dimensions and then defined different views on that data, each view a different arrangement of the dimensions. The model separated the structure of the data from its presentation.
In practice this meant: a financial analyst could have displayed the same revenue data once as a quarter×region matrix, once as quarter×product, and once as region×product, without copying the data.
Why did Improv fail? On a psychological problem known in software development today as paradigm discontinuity. Users who knew Lotus 1-2-3 or Excel had mental models of rows, columns, formulas, and cell references. Improv threw all that away. The learning curve was not steep, it was vertical. And whoever had years of work invested in Excel models had no incentive to relearn.
Improv initially appeared for the NeXT computer (Steve Jobs’ post-Apple platform) and thus on a machine that sold fewer than 100,000 units. The Windows version came in 1993, at a time when Excel already controlled the category.
Warning
The Improv paradox: A conceptually superior tool loses to a sufficiently well-established tool when the switching cost outweighs the benefits. Improv was not too complex; it was too different. This mechanism recurs in computing history: better technologies often fail not on technical flaws but on the inertia of existing habits and network effects.
Lotus Improv was discontinued in 1996. The ideas it contained lived on in business intelligence tools, OLAP cubes, and modern tools like Airtable or Notion, but the spreadsheet grid has kept its firm grip on the world of knowledge work.
The Spreadsheet as a Cognitive Tool
What makes the spreadsheet so durably successful? The answer is not technical, it is epistemic.
The spreadsheet offers a metaphor that is intuitively accessible to people: a table with rows and columns. The metaphor existed before the computer (as accounting journals on paper) and survived the computer (as a digital grid). Its strength lies in enabling non-programmers to write executable logic. An Excel formula is code. A user who writes =IF(A2>B2,"Target met","No") is programming, without ever using the word “programming”.
Spreadsheet users number in the hundreds of millions, far more than any programming language has. That is not a niche of software history; it is the mainstream of human knowledge work.
And errors in these spreadsheets have real consequences: in 2012, JP Morgan Chase lost 6.2 billion dollars in a trading debacle traced in part to a copy-paste error in an Excel risk model. In 2020, the English government lost 15,841 positive COVID-19 test results because an Excel file exceeded the 65,536-row limit of the old .xls format. In 2013 a graduate student found that an AVERAGE formula in an influential Reinhart-Rogoff austerity paper had silently omitted five countries, turning a claimed -0.1% growth figure into +2.2% (see Fun Fact: The Excel Error Behind an Austerity Argument).
The spreadsheet is powerful enough to move billions, and fragile enough that one wrong cell reference changes the world.