Overview
Excel and Google Sheets now feel like everyday tools.
You enter numbers, add formulas, change assumptions, and check the result. For many people, that is simply what computers are for.
But the history of business numbers did not begin with spreadsheet software.
Before spreadsheets, there was the age of punched cards.
A punched card records information by placing holes in specific positions on a paper card. In the history of business and administrative data processing, Herman Hollerith's tabulating system and its connection to IBM are especially important.
To understand spreadsheet software, we first need to understand how business data became something machines could process.
Punched Cards Were Close to the Origin of Business Data Processing
The idea of punched cards existed before computers. The Jacquard loom used punched cards to control woven patterns in the early nineteenth century.
For business data processing, however, Herman Hollerith is the key figure.
In the 1880s, Hollerith developed tabulating machines that used punched cards. The immediate problem was the United States census.
As the population grew, manually counting census results became too slow. Hollerith encoded personal attributes and answers as holes in cards, then used machines to read and tabulate them.
This system was used for the 1890 U.S. census and became a major milestone.
The important point is that punched cards were not just an input format. They were part of a business system for recording, sorting, and counting large volumes of data.
From Hollerith to IBM
Hollerith later founded the Tabulating Machine Company.
That company was eventually combined with others to form Computing-Tabulating-Recording Company, or CTR. In 1924, CTR became International Business Machines: IBM.
At the center of IBM's early history was punched-card data processing.
IBM did not begin as a modern computer company in the current sense. It grew by mechanizing business records, classification, counting, and administrative processing.
Sales, inventory, payroll, accounting, customers, statistics, and budgets have always mattered to organizations.
Punched cards were an early way to move those numbers from paper-only management into machine processing.
They Were Not Yet Interactive Tools for Thinking With Numbers
Punched cards advanced large-scale data processing, but they were very different from modern spreadsheets.
In Excel, changing a cell can immediately update related results. In Google Sheets, multiple people can work on the same sheet at the same time.
In the punched-card world, input was physical work.
- Punch the cards
- Feed them into machines
- Sort them
- Tabulate them
- Produce results
That flow was not the same as watching a screen, changing a number, and immediately seeing the result.
Punched cards mechanized data processing. They did not yet let people interact with numbers as a live thinking tool.
Mainframes Were Still Not on Individual Desks
Electronic mainframe computers came later.
Companies, research institutions, and government organizations used computers for calculation, statistics, accounting, and aggregation.
But computers were still not personal desk tools.
They lived in dedicated rooms and were managed by specialists. Ordinary staff did not open a file, change a number, and instantly test a scenario at their own desks.
Business numbers were becoming machine-processed, but they were not yet personally manipulable.
Semiconductors and Microprocessors Changed the Direction
Semiconductors and microprocessors changed this situation.
Electronic circuits became smaller, and the central processing functions of computers were concentrated into smaller components.
From the 1970s onward, microprocessors helped bring computers closer to individuals and small businesses.
Computers started moving from large facilities toward machines that people could own.
But smaller hardware alone was not enough. Workplaces still needed a reason to use it.
The Apple I Showed the Possibility of Personal Computing
The Apple I was an early computer designed by Steve Wozniak, with Steve Jobs involved in selling it.
It was not a finished personal computer in the modern sense. It was mainly sold as a board, and users needed to provide items such as a keyboard, display, case, and power supply.
So the Apple I was closer to a product for engineers and computer enthusiasts than an office machine for ordinary employees.
Its importance is that it showed computers moving from large institutional equipment toward something an individual could own.
It was not yet the business spreadsheet platform. It was one step before that.
Summary
The history of spreadsheet software is not only a history of personal computers.
Before spreadsheets, there was a history of punched-card data processing. Hollerith's tabulating machines were used in the 1890 U.S. census, and Hollerith's company eventually connected to CTR and IBM.
IBM's roots include the idea of processing business and administrative data by machine.
But punched cards and mainframes were not yet tools for individuals to manipulate numbers while thinking.
The major change brought by spreadsheet software was that business numbers moved closer to individual desks and live scenario testing.
Part 2 looks at how the Apple II and VisiCalc turned the personal computer into a business tool.