The Birth of Spreadsheets: Humanity’s Long Effort to Organize the World in Tables

In the spring of 1978, a student named Dan Bricklin sat in a classroom at Harvard Business School, watching his professor. The professor was drawing grid lines on a blackboard and filling in numbers to explain a financial model. But when he changed one assumption partway through, he had to erase and recalculate dozens of cascading figures. It was tedious just to watch.^[1]

In that moment, a question formed in Bricklin’s mind: What if that blackboard could recalculate itself?

That idea would eventually give birth to spreadsheet software. What makes it fascinating is that the problem Bricklin was trying to solve — organizing data in a tabular format and recalculating everything when a value changes — was one humanity had been wrestling with for thousands of years.

The First Spreadsheet: Sumerian Clay Tablets

Around 3200 BCE, in the Sumerian city of Uruk in what is now Iraq, scribes began pressing the first cuneiform marks into clay.^[2] Many of these tablets were administrative documents recording rations of barley and emmer wheat from temple storehouses, worker rosters, and livestock counts.^[3]

What’s striking is the format of these documents. Items were listed vertically, quantities arranged in horizontal columns. Subtotals were organized by date and category. To modern eyes, it looks unmistakably like a table. The Sumerians intuitively chose a tabular structure to manage their complex economic activities.

This invention was no accident. Human short-term memory has limits on how much information it can process at once. Tracking the quantities of dozens of items mentally is nearly impossible. The tabular structure is a way around that limitation. By arranging information in rows and columns, it becomes far easier to visually grasp the relationships between individual items, locate specific values quickly, and review subtotals and totals.

Similar tools were used in Roman times as well. Roman accountants recorded income and expenses in tabular form on wooden or wax tablets. The evolution from single-entry to double-entry bookkeeping was also the story of increasingly sophisticated table formats. The structure of double-entry bookkeeping itself — debits on the left, credits on the right — is essentially a two-column table.^[4]

Double-Entry Bookkeeping and the Origins of the Word “Spreadsheet”

In 1494, Italian mathematician Luca Pacioli published Summa de arithmetica, geometria, Proportioni et proportionalita, a mathematical encyclopedia, in Venice.^[5] The book contained a systematic account of the double-entry bookkeeping methods used by merchants in northern Italy at the time. Pacioli didn’t invent double-entry bookkeeping, but his book became the decisive vehicle for spreading the method across Europe.

As double-entry bookkeeping became widespread, accountants began spreading large sheets of paper across their desks to compare multiple accounts side by side. This “spread sheet” — a large sheet spread out — is the etymological origin of the word “spreadsheet.” Records show the term being used as an accounting word at least as early as 1906.^[6] Traditionally, these forms were spread across two facing pages, or printed in rows and columns on analysis paper roughly twice the width of regular paper.

By the mid-twentieth century, accountants’ desks were piled with paper spreadsheets. Changing a single number meant redoing all connected calculations by hand. Updating one row of figures could take hours. That was the scene Bricklin witnessed in 1978.

Jeong Yak-yong: Revolutionizing Administration Through Tables

At roughly the same time — on the other side of the world — a figure in Joseon Korea had also grasped the power of tabular formats. Jeong Yak-yong (1762–1836) was a scholar of the Silhak (Practical Learning) movement in late Joseon, known for overseeing the basic design of Suwon Hwaseong Fortress and devising construction equipment such as the geojunggi, a type of pulley crane.^[7] But there is another, less celebrated side to Jeong Yak-yong.

When King Jeongjo was wrapping up a tree-planting project around Sadoseja’s tomb and preparing to award merits to those who had contributed, the related documents filled cartloads of paper. Jeong Yak-yong condensed this vast documentation into a single table and presented it to the king — an episode so impressive that today he is jokingly called “the pioneer of Excel.”^[8]

In fact, the Hwaseong Seongyeok Uigwe — the comprehensive record of the Hwaseong Fortress construction — systematically documents the day-by-day progress of construction, the types and names of craftsmen employed, the number of days worked, and the types and quantities of materials used, all in organized lists and tabular format.^[9] Recording hundreds of thousands of data points in a searchable, indexed form was a remarkable achievement in information design by the standards of early nineteenth-century administration.

What makes Jeong’s example interesting is that it represents an independent path of development in East Asia. At roughly the same time as Western double-entry bookkeeping, and in response to the same fundamental question — how to systematically organize vast amounts of data — the tabular format was chosen as the answer. This suggests that human cognition universally gravitates toward tabular organization.

VisiCalc: The Blackboard That Calculated Itself

Back to 1978. Dan Bricklin teamed up with MIT classmate Bob Frankston to turn the imagined blackboard into reality. The two founded a company called Software Arts and completed the program in roughly two months over the winter of 1978–79.^[10]

VisiCalc (short for “Visible Calculator”) was released on October 17, 1979, for the Apple II.^[11] It sold for $100. The core innovation was simple: change the value in any one cell and every connected cell recalculates automatically. Tasks that had taken twenty hours now took fifteen minutes.

The impact of VisiCalc cannot be explained simply as the arrival of “convenient software.” This program changed the direction of the personal computer industry itself. In 1979, an Apple II was a $2,000 hobbyist device. Once VisiCalc launched, corporate finance officers bought Apple IIs in order to run this software. It is estimated that more than 25% of Apple IIs sold in 1979 were purchased specifically to use VisiCalc.^[12] It was the first time software drove hardware sales.

Bricklin described the phenomenon himself: “People came to buy the software and ended up buying a computer too.”^[1] The concept of the “killer app” as we know it today traces directly to this moment.

There is a paradox in VisiCalc’s success. The program demonstrated the potential of personal computers to the business world, which prompted IBM to act. IBM launched the PC in 1981, opening the age of modern personal computing — and it was VisiCalc that provided the catalyst.^[13] Yet the two people who created VisiCalc never reaped the rewards of this revolution. They failed to patent their work, and competitors took the market with superior products.

Lotus 1-2-3: The Killer App for the IBM PC

On January 26, 1983, Lotus Development Corporation, founded by Mitch Kapor and Jonathan Sachs, released Lotus 1-2-3.^[14] If VisiCalc was the killer app for the Apple II, Lotus 1-2-3 became the killer app for the IBM PC.

Lotus 1-2-3 quickly overtook VisiCalc for good reasons. It integrated spreadsheet functionality with chart and graph creation and basic database features — all in a single program. The “1-2-3” in the name symbolized these three capabilities. Revenue in its first year, 1983, reached $54 million, making Lotus the world’s largest independent software company.^[15]

Kapor designed the interface with non-technical users in mind. Using focus group feedback to develop the user manual was unusual for the technology industry at the time.^[14] This approach made Lotus a tool used not just by professional accountants but by general office workers as well.

Lotus 1-2-3 dominated the business software market throughout the 1980s. But that dominance didn’t last. A competitor was approaching from an entirely different direction.

Excel and the GUI: Clicking with a Mouse

On September 30, 1985, Microsoft released the first version of Excel. Remarkably, it was not for the IBM PC but for the Macintosh.^[16] Excel was never released for the DOS environment used by IBM PCs.

Microsoft’s strategy was clear: rather than competing in the text-command-dominated DOS environment, it would establish itself first in the Mac ecosystem with its graphical interface (GUI). Clicking menus with a mouse, dragging cells directly, and seeing results visually in real time was fundamentally different from Lotus 1-2-3’s keyboard-shortcut-centric interface.^[17]

On November 19, 1987, Excel 2.05 for Windows was released.^[16] This version brought essentially the same interface as the Mac version to the Windows environment. As Windows began to spread from 1988 onward, Excel started outselling Lotus 1-2-3.^[18] From that point on, Excel became synonymous with spreadsheet software.

Lotus’s decline was not solely due to Microsoft’s offensive. The company was slow to transition a product optimized for DOS into the GUI era, and rested too long on its captured market. It was a classic pattern in the technology industry: a pioneer overtaken by a latecomer.

Google Sheets: From Solo Table to Shared Table

In June 2006, Google acquired a web-based spreadsheet developed by 2Web Technologies and relaunched it as Google Spreadsheets (now Google Sheets).^[19] A beta service launched alongside Google Docs in October of that year.

What Google Sheets changed was not simply “where you work.” It changed “how you work together.” An Excel file could only be edited by one person at a time. Google Sheets allowed multiple people to edit the same file simultaneously while watching each other’s cursors move in real time.^[20]

The impact on working practices was significant. Teams sharing and editing a single dataset at the same time represented a clean break from the old way of managing versions by emailing files back and forth. Today, Google Sheets is used for everything from a startup’s initial financial model to a school attendance sheet to a data-collection tool for citizen journalism.

The Universality of Tabular Thinking

More than five thousand years have passed from Sumerian clay tablets to spreadsheets in the cloud. In that time, the materials changed from clay to wax tablets to paper to monitor screens. The tools evolved from reed styluses to pencils to keyboards to mice. But the fundamental structure — arranging information in rows and columns — has not changed.

Is this a coincidence? Probably not. Tables connect deeply with the way human cognition works: the instinct to classify into categories, compare items, and find patterns. When Jeong Yak-yong condensed cartloads of documents into a single table, and when Bricklin watched a blackboard and imagined automatic recalculation, what each of them discovered was not a technological innovation but an ancient tool of human thought.

The spreadsheet may not have been invented at all. It may simply have been remade, in each era, with that era’s materials and technology.