Template:VisiCalc capsule
In 1979, Dan Bricklin and Bob Frankston created a new application for the Apple II computer. They called it “VisiCalc”. It was a grid of cells that you could input numbers and text into and then run calculations on by reference to cell coordinates. VisiCalc was, of course, the first spreadsheet program. It is the primordial ancestor of that beast we all now know and love as Microsoft Excel. The brilliant innovation was to separate the actual data — the numbers and text in the cells that you wanted to calculate, from the calculation operation, which referenced the just cell coordinates, not the data inside the cell itself. You could change the data without changing the calculation operations.
It might not have seemed much in 1979, but it would revolutionise business computing. While not nearly as intuitive as the “desktop” — there was no graphic user interface or anything like that — VisiCalc was a much purer expression of what a personal computer could do. It promised even modest undertakings a powerful means of storing, augmenting, filtering, analysing and manipulating unprecedented amounts of information as structured data.