From Spreadsheets to AI: Lessons on Programming's Evolving Role

The advent of spreadsheets sparked concerns among programmers, with some predicting the obsolescence of professional coding. Yet, history shows that like many technological waves, spreadsheets primarily augmented roles rather than eradicating them, paving the way for a redefined landscape in software development.

The Rise of End-User Programming and its Impact

Early professional programmers were often domain experts—statisticians, geologists, chemists—who developed computing skills out of necessity. Software was highly specialized and expensive. Spreadsheets, on the other hand, were a "killer app" that made computing accessible to a much broader audience. They drove the adoption of personal computers and allowed non-programmers (like accountants, farmers, and small business owners) to create their own solutions for quick calculations and internal tools. This expansion of computer usage proved to be a rising tide that lifted all boats in the nascent PC industry, ultimately increasing the demand for professional software to build more complex systems around these end-user tools.

The Shadow IT Phenomenon and its Lessons

A critical takeaway from the spreadsheet revolution is the emergence of "shadow IT." When official IT departments were perceived as too slow, expensive, or disconnected from immediate business needs, end-users naturally gravitated towards powerful, flexible, and readily available tools like spreadsheets. These tools became integral to critical business processes, but often operated without proper documentation, version control, or maintenance. The real nightmare emerged when key personnel left, taking their undocumented spreadsheet-based systems with them, leaving IT to reverse-engineer and stabilize crucial, but hidden, infrastructure.

This pattern of "routing around" official channels is highly relevant to the current wave of AI adoption. Businesses eager to save money and accelerate work will embrace powerful AI tools, leading to a similar mix of genuinely useful innovations, invisible infrastructure, and potential future headaches for those tasked with untangling the complexities later.

Analogy to Industrial Shifts and Current Realities

Comparing this shift to the introduction of sewing machines in manufacturing offers another perspective: rather than eliminating jobs, sewing machines dramatically increased output per worker, drove down costs, and led to the creation of new specialized roles (e.g., industrial engineers, material scientists). While some jobs were displaced, the overall market expanded and evolved.

However, the current AI landscape differs in context. Today's major tech incumbents are often supply-constrained (e.g., by chip availability) rather than demand-constrained for developers, and they hold significant market positions. This could mean a different dynamic than past competitive environments where increased efficiency immediately translated to more hiring to outproduce rivals. Nonetheless, the principle of technology enhancing capabilities and redefining work, rather than outright replacing it, remains a strong historical precedent.

Cultivating Essential Skills for All Professionals

The discussion also underscores the growing importance of basic logic and programming understanding for professionals in many fields. For instance, accountants could significantly benefit from skills in git for version control, SQL for data management, and Python for automation and analysis. A fundamental grasp of computational thinking and logic is becoming increasingly valuable across the professional spectrum, enabling better utilization of powerful tools and avoiding common pitfalls.