By Hiran de Silva

There is a fascinating pattern hiding inside the history of spreadsheets.

It only becomes visible when several different ideas are placed side by side.

Individually, these ideas look unrelated:

• the evolution of spreadsheet technology
• the changing footprint of Excel models
• the difference between document thinking and systems thinking
• the differing perspectives of junior users and senior management

But when we place them on the same timeline, something remarkable appears.

These are not separate stories.

They are parallel stories moving in the same direction.

And together they explain both:

• the true potential of Excel, and
• why that potential is almost invisible in public discussion.

---

The First Story: The Caterpillar

Let us begin with the history of spreadsheets.

The earliest spreadsheet programs — VisiCalc (1979) — were revolutionary because they introduced a simple but powerful idea:

Change an input, and the output recalculates automatically.

A primitive model might have looked like this:

Revenue
Costs
Profit = Revenue – Costs

That was the entire magic.

But the model lived entirely inside one sheet.

Its footprint was tiny.

The spreadsheet was essentially a digital sheet of paper.

A few years later came MultiPlan (1982), Lotus 1-2-3, and eventually Excel.

Hardware improved.

Computers became faster.

Networking appeared.

Windows allowed multiple programs to run simultaneously.

The spreadsheet became more powerful, but conceptually it remained the same creature.

It was still a document.

A workbook was simply a bigger sheet of paper.

Even when spreadsheets linked to other spreadsheets across networks, they still behaved like documents passing information between each other.

The caterpillar had grown longer.

But it was still a caterpillar.

---

Stage 4: The Hidden Turning Point

Something profound happened in the mid-1990s.

Microsoft introduced ADO (ActiveX Data Objects) and universal data connectivity across applications.

For the first time, Excel could interact seamlessly with external databases.

This was a quiet revolution.

Suddenly, spreadsheets no longer needed to contain their own data.

Instead, they could become clients of a central data system.

In this architecture:

• spreadsheets became interfaces
• databases became data custodians
• data could be shared across many users simultaneously

This is what I often describe as the Digital Librarian concept.

The spreadsheet becomes a visitor.

The database becomes the librarian.

Instead of storing thousands of books inside your briefcase, you simply visit the library.

And the library serves everyone.

At that moment, the caterpillar began its transformation.

---

Stage 5: The Butterfly

The final stage arrived not through Excel itself, but through infrastructure.

The arrival of cloud computing meant that the “digital librarian” could now sit anywhere.

A central database could live on the cloud and serve users everywhere:

• Excel on Windows
• Excel on Mac
• Excel on the Web
• Google Sheets
• tablets
• mobile devices
• web applications

At that moment the spreadsheet ceased to be a document.

It became part of a system.

The data had been liberated.

The caterpillar had become a butterfly.

The spreadsheet could now fly.

---

The Second Story: Document Thinking vs Systems Thinking

Running parallel with this technical evolution is another story.

A psychological one.

Most Excel users think of Excel as a document.

This mental model is extremely powerful because it matches how people first encounter spreadsheets.

You open a file.

You enter numbers.

You calculate results.

You save the document.

Everything happens inside the workbook.

This is document thinking.

But enterprise processes are not documents.

They are systems.

Systems have characteristics that documents do not:

• multiple users
• continuous activity
• shared data
• end-to-end processes
• automation
• minimal manual intervention

A document mindset struggles to address these needs.

A systems mindset embraces them.

This distinction explains why spreadsheets used as documents often lead to what people call Excel Hell.

The problem is not Excel.

The problem is the mental model being applied.

---

The Third Story: The Human Spectrum

There is also a human dimension to this story.

Excel users occupy a spectrum.

At one end are junior or novice users.

These users naturally think of Excel as a document.

That is what they see.

That is what they are taught.

That is what most training materials reinforce.

At the other end of the spectrum are senior managers.

Senior managers care about completely different outcomes:

• end-to-end processes
• automation
• system reliability
• reduced manual intervention
• enterprise scale

These concerns naturally lead to systems thinking.

But there is a problem.

Most Excel education is aimed almost entirely at the bottom of the pyramid.

The massive ecosystem of Excel tutorials, courses, and videos focuses on:

• formulas
• formatting
• dashboards
• features

All within the document paradigm.

Very little education addresses the needs of the people at the top of the pyramid.

And yet those are the people who ultimately care about process architecture.

---

The Fork in the Road

This creates a fork in the road.

If we remain within document thinking, even modern Excel features simply produce increasingly elaborate spreadsheets.

They become:

• larger
• more complex
• more fragile
• harder to maintain

This is the familiar territory of Excel Hell.

But the alternative path is surprisingly simple.

Instead of building bigger spreadsheets, we separate the data from the spreadsheet.

The spreadsheet becomes an interface.

The database becomes the central data store.

Suddenly:

• consolidation becomes trivial
• collaboration becomes natural
• automation becomes possible
• the system scales effortlessly

The butterfly takes flight.

---

Why Nobody Talks About This

At this point an obvious question arises.

If this architecture exists, why is it almost never discussed?

The answer lies in three different groups within the Excel ecosystem.

---

The Good

There are professional consultants who build exactly these kinds of systems.

They work with large organisations.

They solve real enterprise problems.

But they rarely publish their work.

Why?

Because:

• their work is confidential
• they operate under NDAs
• their methods are valuable intellectual property
• their clients prefer discretion

These professionals are busy delivering results, not producing social media content.

---

The Bad

There is also an industry built around replacing Excel.

These vendors frequently present spreadsheets as fundamentally flawed.

They highlight the chaos that arises when spreadsheets are used as documents.

And they use that chaos as evidence that Excel itself is inadequate.

But this argument quietly assumes that Excel must remain trapped inside the document paradigm.

Once Excel becomes part of a client-server architecture, that argument collapses.

---

The Lovely

Finally there is the world of social media.

Many Excel influencers produce excellent educational content.

But almost all of it operates within the same framework.

Excel as a document.

Excel as a personal productivity tool.

Excel as a place to demonstrate clever formulas.

This content is extremely popular because it serves the largest audience — the beginners and intermediate users at the bottom of the pyramid.

But it does little to address the needs of enterprise management.

---

The Vacuum

The result is a vacuum.

At one end of the spectrum we have millions of Excel users learning how to manipulate spreadsheets.

At the other end we have executives being told that Excel must be replaced.

Between those two worlds lies a largely unexplored territory:

Excel as a platform for enterprise systems.

---

The Parallel Stories

When we place all the pieces together, we can see several stories unfolding in parallel.

Technology evolution

VisiCalc → Excel → ADO → Cloud

Conceptual evolution

Document → Model → System

Data evolution

Trapped → Shared → Liberated

Human perspective

Novice → Professional → Management

Each of these stories describes the same transformation.

The transformation from caterpillar to butterfly.

---

The Real Opportunity

Excel’s greatest strength is not that it is the most powerful programming platform.

It is not.

Its greatest strength is that it is everywhere.

Excel is the oxygen of the corporate world.

And wherever Excel exists, intelligent people have access to it.

When those people discover how to separate data from spreadsheets, something extraordinary happens.

The caterpillar becomes a butterfly.

And suddenly Excel can fly.

An additional Parallel Story – The Literal vs the Lateral

In document thinking, spreadsheets are literally documents. It’s easy to work in this paradigm when recording the screen to demonstrate a feature.

But, system thinking requires thinking way outside the box. This is lateral thinking.

Thinking outside the box cannot be demonstrated by recording the screen. It needs allegory, illustration, ice-breaker type puzzles. Whiteboards and animated pictures. This is hard and unnecessary work if your objective is simply to get social media engagement. It also requires understanding real-life business pains at a higher level of responsibility – that neither the social influencers nor the junior learners possess through experience.