Spreadsheet 2.0

What would a spreadsheet look like if it were built for developers?

  • Data separated from processing
  • Integration with SQL (workbench)
  • Shift data between SQL and other formats (SQLite intermediate storage)
  • Integrated language for building pipes
  • Partial stream results for debugging
  • Build processes in the GUI but runnable on the command line

Command line support

The ability to execute a process file via the command line:

ss2 -f process.ss2 -e INPUTFILE:data.csv -e OUTPUTFILE:output.csv

The -e parameters specify configuration variables that can be passed into the process file.

Transformations