VisiCalc

In 1978, Dan Bricklin was attending classes at Harvard Business School when an ordinary situation sparked an idea that would transform personal computing. During a case study on Pepsi-Cola, he watched his professor fill in a financial spreadsheet on the blackboard. With each data modification, the instructor had to laboriously recalculate all the figures, erase, and rewrite. This scene reminded Bricklin of his own calculation sessions with his calculator: scribbled sheets of paper, errors creeping into transferred values, tedious restarts.

The student had solid technical experience from Digital Equipment Corporation, where he worked on digital typesetting systems. He knew about computer systems designed to reduce the number of operator manipulations. This experience led him to envision what he would later call an “electronic blackboard and chalk.” A system where calculations display, modify, and automatically propagate from one cell to another.

Back in his dorm room, Bricklin cobbled together a first prototype in BASIC on a borrowed Apple II. His program managed a small grid of twenty rows by five columns, but the principle worked. He reconnected with Bob Frankston, a friend from MIT with whom he had worked on Multics, the experimental operating system that familiarized them with sophisticated user interfaces. Frankston possessed the technical skills necessary to transform the idea into a commercial product.

Their meeting with Dan Fylstra was a game changer. Fylstra ran Personal Software and wrote for Byte Magazine. He immediately grasped the project’s potential and steered the two men toward the Apple II, a machine that had the decisive advantage of a disk drive. Without external storage, a spreadsheet would remain unusable. Fylstra also suggested adapting the software to HP85 and HP87 programmable calculators, but this avenue led nowhere.

In January 1979, Bricklin and Frankston founded Software Arts Corporation. To develop their spreadsheet, they acquired a Prime 350 minicomputer, chosen for its connection to Multics and its support for the PL/I language. This cross-development approach, unusual for the time, gave them access to tools far more powerful than those available on microcomputers. They wrote and compiled code on the Prime, then transferred it to the Apple II for testing.

Hardware constraints dictated their technical choices. The Apple II provided 48 KB of RAM, part of which was used by the operating system. Every byte mattered. Rather than using faster binary arithmetic, they opted for decimal calculation. This decision sacrificed performance but avoided rounding errors that would have unsettled users accustomed to their desk calculators.

The interface they designed was striking in its apparent simplicity. A grid of cells identified by coordinates: A1, B2, C3. Each cell could contain a number, text, or a formula. Users pointed to other cells rather than manually entering their values. When data changed, all calculations updated instantly. This simulation feature—the famous “what if”—simplified exploring different scenarios with a single gesture.

This design stemmed from their experience with large computer systems and their desire to create a tool accessible to the general public. The coordinate notation actually resulted from deep reflection on ergonomics. How to reference a cell intuitively? How to make calculation logic visible?

Personal Software released VisiCalc in May 1979 at a price of $100. Success didn’t come immediately, but it came quickly. In July, Ben Rosen published an analysis in the Morgan Stanley Electronics Letter that would prove prophetic. VisiCalc was the first “killer app” of personal computing, the first software that let you use a computer without knowing how to program. Buyers purchased an Apple II solely to run VisiCalc.

The program found its place on other machines. The 1981 IBM PC version employed the same optimization techniques as the original, demonstrating the soundness of the initial choices. But success attracted competition. Microsoft launched Multiplan in 1982. The software struggled in the United States but found success elsewhere in the world.

The arrival of Lotus 1-2-3 in 1983 reshuffled the deck. Mitch Kapor, a former Personal Software employee, had developed a spreadsheet specifically optimized for the IBM PC. His program integrated graphics, managed databases, named cells, and automated tasks with macros. Lotus 1-2-3 dominated the professional world.

VisiCalc couldn’t withstand this renewed competition. Relations between Software Arts and Personal Software deteriorated. Each company developed its own projects: VisiOn for Personal Software, TK!Solver for Software Arts. Conflicts escalated into cross-lawsuits in 1984, paralyzing product development. The advanced version of VisiCalc arrived too late in an already conquered market.

The legacy of the first electronic spreadsheet transcends its commercial success. VisiCalc proved that a microcomputer could serve as a serious professional tool. It accelerated business computerization and permanently influenced user interface design. Microsoft Excel, launched in 1985 on Macintosh and in 1987 on Windows, adopted its fundamental principles while adding macro programming capabilities.

Technically, VisiCalc established practices that became standard: cross-development between development machine and target platform, code optimization for limited resources, the importance of an intuitive interface. But this ease of use sometimes conceals underlying complexity. Studies reveal that most spreadsheets contain errors, with approximately 3% of cells being incorrect on average. These mistakes can be costly in financial terms or strategic decisions.

The VisiCalc adventure also illustrates the evolution of the software industry. The collaboration model between technical developer and commercial publisher, initially perceived as an asset, strained relationships when the market evolved. The separation between creation and commercialization, which seemed natural, revealed its limitations in the face of technological changes.

Forty years after its creation, VisiCalc continues to inspire. Its principles—polished user interface, resource optimization, balance between innovation and concrete needs—remain relevant. Its story reminds us that software succeeds as much through its technical design as through its ability to solve a real problem.