Need Design Help? Hit us up!

History

Spreadsheet software reformed the world of business as we know it and was a major force in making computers a household name. This curation picks out the pivotal moments that lead to convergence of design patterns in the spreadsheet paradigm.

Budgeting Models and System Simulation

Originator
  • Portrait of Richard Mattessich Richard Mattessich

The first paper to outline the concept of an electronic spreadsheet. Subsequent work resulted in the implementation of computerized spreadsheets on mainframe systems.

Screenshot from page 392 of The Accounting Review 1961 Volume 36 Issue 3 https://archive.org/details/sim_accounting-review_1961-07_36_3/page/392/mode/2up showing the paper Budgeting Model sand System Simulation

LANPAR

Originators
  • Portrait of Rene Pardo Rene Pardo
  • Generic profile image Remy Landau

Rene Pardo and Remy Landau created the first commercial electronic spreadsheet called LANPAR. The name is also a mix of the surnames of the originators. It introduced the idea of forward referencing and natural order evaluation.

Rene Pardo on the cover of ComputerData magazine from July 1982

VisiCalc

Apple II
Originators
  • Portrait of Dan Bricklin Dan Bricklin
  • Portrait of Bob Frankston Bob Frankston

VisiCalc was a smash hit spreadsheet application for Apple II, one of the very first personal computers. The name is a shortening of Visible Calculation. It was the first spreadsheet application to have WYSIWYG editing capabilities and introduced many UI design innovations which were then adopted in later software becoming the prototypical spreadsheet example.

Screenshot of VisiCalc from https://en.wikipedia.org/wiki/VisiCalc#/media/File:Visicalc.png

Multiplan

Windows
Originator
  • Portrait of Doug Klunder Doug Klunder

Multiplan was developed by Microsoft as a competitor to VisiCalc. It was eventually replaced by Excel. It used R1C1 addressing instead of the A1 addressing which was present in VisiCalc.

Multiplan on the C64 from: https://en.wikipedia.org/wiki/Multiplan#/media/File:C64_Multiplan.png

Lotus 1-2-3

MS-DOS
Originator
  • Portrait of Lotus Software Lotus Software

Popular spreadsheet application from Lotus that took over VisiCalc. Offered charting and graphics capabalities. It allowed cell naming and macros.

Screenshot of Lotus 123 from: https://winworldpc.com/res/img/screenshots/1x-e2e2d90bdf7274fbdcf97e98ca638b45-lotus123v10a.png

Boeing Calc

MS-DOS
Originator
  • Portrait of Boeing Computer Services Boeing Computer Services

Boeing Calc was a spreadsheet application by the computer subsidiary of the aviation company Boeing. It was the first application to feature the concept of a 3D spreadsheet where a single cell could house an entire spreadsheet.

Screenshot of Boeing Calc from: https://winworldpc.com/product/boeing-calc/300e

Excel

MS-DOS
Originator
  • Portrait of Doug Klunder Doug Klunder

Superseded Multiplan and became the industry standard for spreadsheet editing in 1990s till 2020s.

Screenshot of Excel from: https://winworldpc.com/res/img/screenshots/Microsoft%20Excel%201.5%20-%20About.png

Lotus Improv

NeXTSTEP
Originator
  • Portrait of Lotus Software Lotus Software

Improv attempted to re-imagine interaction design for spreadsheets. It introduced separation of concerns in using cells only for input and output of data and formulae and notes were separated into different domains.

Screenshot of Lotus Improv from: https://en.wikipedia.org/wiki/Lotus_Improv#/media/File:Lotus_Improv_screenshot,_NeXTSTEP_version.jpg

Scheme in a Grid

Linux, Mac OSX, BSD
Originator
  • Generic profile image Ulric Eriksson

Siag is a spreadsheet that has a full-blown programming language support inside it's environment.

Screenshot of SIAG from: https://siag.nu/siag/siag2.gif

Google Sheets

Web
Originator
  • Portrait of Google Google

Online spreadsheet application from Google. Features scripting capabilities.

Screenshot of Google Sheets from: https://en.wikipedia.org/wiki/Google_Sheets#/media/File:Google_Sheets_Untitled_spreadsheet.png

Airtable

Web
Originator
  • Portrait of Airtable Airtable

Airtable is a cloud based spreadsheet + database application

Screenshot of Airtable from: https://static.airtable.com/sandbox/2uQws3IGYp5JmQy5LDJGi2.png

IronCalc

Web
Originators
  • Portrait of Nicholás Hatcher Nicholás Hatcher
  • Portrait of Daniel González-Albo Daniel González-Albo

An embeddable spreadsheet engine

Screenshot of IronCalc from: https://www.ironcalc.com/images/spreadsheet.png